Search found 28 matches

by jamesbennett
Tue Jan 28, 2020 10:20 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX filter according to attribute of current user
Replies: 2
Views: 2228

MDX filter according to attribute of current user

I'm trying to set up a dynamic subset and have unsuccessfully been attempting to replicate the MDX code found here: https://tm1forum.com/viewtopic.php?t=14061 I have a dimension, 'Organisation'. The }Clients dimension has a 'Department' attribute. Every value of 'Department' matches an element or co...
by jamesbennett
Mon Jan 20, 2020 11:52 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Unable to destroy Cell Security cube
Replies: 6
Views: 2663

Re: Unable to destroy Cell Security cube

I see - obvious when you point it out. Thanks for your help, that works well now.
by jamesbennett
Mon Jan 20, 2020 11:24 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Unable to destroy Cell Security cube
Replies: 6
Views: 2663

Re: Unable to destroy Cell Security cube

Wim Gielis wrote: Mon Jan 20, 2020 11:22 am Show us the code please.

Code: Select all

CellSecurityCubeDestroy('}CellSecurity_Allocations');
As mentioned it's in the Prolog tab of the TI, Data Source set to None.
by jamesbennett
Mon Jan 20, 2020 11:20 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Unable to destroy Cell Security cube
Replies: 6
Views: 2663

Re: Unable to destroy Cell Security cube

I hadn't - I wasn't aware of such an option - however having just ticked that I've rerun the process and get the same issue, 'Process Completed Successfully' but no impact on the cube.
by jamesbennett
Mon Jan 20, 2020 10:45 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Unable to destroy Cell Security cube
Replies: 6
Views: 2663

Unable to destroy Cell Security cube

I recently created a Cell Security cube via TI using the CellSecurityCubeCreate function. However, now I would like to destroy and recreate the cube as I need to include another dimension that was missed out the first time around. I have tried running another TI with the CellSecurityCubeDestroy func...
by jamesbennett
Tue Dec 03, 2019 4:30 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX - dynamic subset to filter by two other dimensions
Replies: 12
Views: 12850

Re: MDX - dynamic subset to filter by two other dimensions

PlanningDev and Mark,

Sorry for the delay in replying, but wanted to say thanks - I've made a couple of tweaks to your syntax but got it working exactly as intended now - couldn't have got there without you both!
by jamesbennett
Thu Nov 07, 2019 2:04 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX - dynamic subset to filter by two other dimensions
Replies: 12
Views: 12850

Re: MDX - dynamic subset to filter by two other dimensions

Hi Mark, Apologies - Global Level and Global Mode are both title dimensions in this cube, the values of which correspond to attributes in the Course dimension. E.g. Global Mode has two elements (FT and PT) grouped under a consolidation All Modes. Each element in the Course dimension has a Mode attri...
by jamesbennett
Thu Nov 07, 2019 10:34 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX - dynamic subset to filter by two other dimensions
Replies: 12
Views: 12850

Re: MDX - dynamic subset to filter by two other dimensions

Thanks for your reply PlanningDev. Using your code with the StrToSet seems to work well - however the UNION still doesn't seem to work. It doesn't matter in which order I put Level or Mode - the Course dimension only filters by the first one and ignores the second one. Testing each block of code ind...
by jamesbennett
Mon Oct 28, 2019 4:28 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX - dynamic subset to filter by two other dimensions
Replies: 12
Views: 12850

MDX - dynamic subset to filter by two other dimensions

This issue has come up before in other threads on this forum, but I'm having difficulty implementing it. I think it's a straightforward syntax error with my MDX but can't work out how to rectify it. I have a row dimension, Course, which I want to filter by the values of two other title dimensions, L...
by jamesbennett
Tue Aug 27, 2019 8:11 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Export list of System Names
Replies: 4
Views: 11012

Re: Export list of System Names

Is there any way to access it if I don't have access to the data directory? I can only use Perspectives.
by jamesbennett
Fri Aug 23, 2019 3:56 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Export list of System Names
Replies: 4
Views: 11012

Export list of System Names

The documentation ( https://www.ibm.com/support/knowledgecenter/en/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_dg_dvlpr.2.0.0.doc/t_tm1_dev_ob_creatinghyperlinkstouploadedfiles_nb0f65.html ) describes that to generate a hyperlink to an application, one should "use the Properties pane to find the Sys...
by jamesbennett
Fri Aug 23, 2019 1:34 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Active Form - TM1RPTROW MDX issue
Replies: 9
Views: 9721

Re: Active Form - TM1RPTROW MDX issue

And try DBR instead of DBRW. Changing the DBRW to DBR seems to work. So my next question is why would that be? I understood DBRW was generally higher-performance than DBR. Could that be why (using DBRW) the active form is evaluating in TM1 Web, but not in Perspectives? That the data can still be dr...
by jamesbennett
Fri Aug 23, 2019 12:51 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Active Form - TM1RPTROW MDX issue
Replies: 9
Views: 9721

Re: Active Form - TM1RPTROW MDX issue

It looks like you have both a subset parameter AND an MDX formula parameter in your TM1RPTROW formula. This is really an either/or thing. TM1 either uses the subset or the MDX, it can't use both. Perhaps it uses the MDX parameter over the subset one as long as it can be evaluated easily but once yo...
by jamesbennett
Fri Aug 23, 2019 12:32 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Active Form - TM1RPTROW MDX issue
Replies: 9
Views: 9721

Re: Active Form - TM1RPTROW MDX issue

Hi, i always build the MDX Query in a Excel cell (with reference etc...) In TM1RPTROW i only refer to the cell. My TM1RPTRow looks like that: =TM1RPTROW($B$9;"MyServer:TM1User";;;"Name";;$G$14) Maybe that helps Best regards orlando Thanks, that is what I've been doing - apologie...
by jamesbennett
Fri Aug 23, 2019 11:35 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Active Form - TM1RPTROW MDX issue
Replies: 9
Views: 9721

Active Form - TM1RPTROW MDX issue

Hi there, I've set up an Active Form that I have published through TM1 Web. I have the original TM1RPTROW formula as follows: =TM1RPTROW($B$9,"server:Global Orgstructure","n-level","","Code and Name",0) I inserted an MDX formula into cell C14: ="{TM1FILTE...
by jamesbennett
Fri Jan 25, 2019 4:57 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cube Viewer suppress zeroes hiding non-zero cells
Replies: 12
Views: 9362

Re: Cube Viewer suppress zeroes hiding non-zero cells

Definitely check feeders! See the picture if it works:
Untitled.png
Untitled.png (48.89 KiB) Viewed 9295 times
by jamesbennett
Fri Jan 25, 2019 2:26 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cube Viewer suppress zeroes hiding non-zero cells
Replies: 12
Views: 9362

Re: Cube Viewer suppress zeroes hiding non-zero cells

Have you checked? In Perspectives, right-click on a cell, select 'Check Feeders'. What should I be seeing here? I do this and it shows the formula in the top half of the window, but nothing in the Trace / Value columns as in the 'Trace Calculations' window. Same result for the cells that are not di...
by jamesbennett
Fri Jan 25, 2019 1:47 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cube Viewer suppress zeroes hiding non-zero cells
Replies: 12
Views: 9362

Re: Cube Viewer suppress zeroes hiding non-zero cells

I believe so. The rules calculate values for five divisions using an 'All divisions' consolidation. On an unsuppressed view, values show up for all five divisions. When zeroes are suppressed, one of the five disappears.