Search found 28 matches
- Tue Jan 28, 2020 11:00 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX filter according to attribute of current user
- Replies: 2
- Views: 2239
Re: MDX filter according to attribute of current user
Thanks Mark, that works perfectly!
- 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: 2239
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...
- 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: 2691
Re: Unable to destroy Cell Security cube
I see - obvious when you point it out. Thanks for your help, that works well now.
- 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: 2691
Re: Unable to destroy Cell Security cube
Code: Select all
CellSecurityCubeDestroy('}CellSecurity_Allocations');
- 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: 2691
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.
- 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: 2691
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...
- 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: 12946
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!
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!
- 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: 12946
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...
- 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: 12946
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...
- Tue Nov 05, 2019 9:48 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX - dynamic subset to filter by two other dimensions
- Replies: 12
- Views: 12946
Re: MDX - dynamic subset to filter by two other dimensions
Bump. Any insights?
- 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: 12946
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...
- Tue Aug 27, 2019 8:11 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Export list of System Names
- Replies: 4
- Views: 11024
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.
- Fri Aug 23, 2019 3:56 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Export list of System Names
- Replies: 4
- Views: 11024
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...
- Fri Aug 23, 2019 1:34 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Active Form - TM1RPTROW MDX issue
- Replies: 9
- Views: 9775
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...
- Fri Aug 23, 2019 12:51 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Active Form - TM1RPTROW MDX issue
- Replies: 9
- Views: 9775
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...
- Fri Aug 23, 2019 12:32 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Active Form - TM1RPTROW MDX issue
- Replies: 9
- Views: 9775
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...
- Fri Aug 23, 2019 11:35 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Active Form - TM1RPTROW MDX issue
- Replies: 9
- Views: 9775
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...
- 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: 9420
Re: Cube Viewer suppress zeroes hiding non-zero cells
Definitely check feeders! See the picture if it works:
- 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: 9420
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...
- 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: 9420
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.