Search found 3 matches

by ice1000
Fri Apr 18, 2025 3:09 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to use a parameter cube in PAW MDX
Replies: 3
Views: 12949

Re: How to use a parameter cube in PAW MDX

For posterity, I got these two to work. I do want to get the TM1SUBSETTOSET to work. Still testing that one. STRTOMEMBER("[Scenario].[Scenario].["+LOOKUPCUBE( "Control","([Control Parameter].[Control Parameter].[Target Scenario],[Control Measure].[Control Measure].[String])&...
by ice1000
Thu Apr 17, 2025 11:12 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to use a parameter cube in PAW MDX
Replies: 3
Views: 12949

How to use a parameter cube in PAW MDX

I have a calculated member in a PAW view. Instead of hardcoding the values in the calculation I would like to retrieve the element name from a parameter cube. I can't figure out the correct syntax. This is the MDX with the hardcoded values: WITH MEMBER [Scenario].[Scenario].[Plan / Actuals] AS [Scen...
by ice1000
Thu Feb 22, 2024 9:30 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: OptimusPy - Ideal dimension order finder
Replies: 15
Views: 12398

Re: OptimusPy - Ideal dimension order finder

Could you post an example of the ini file parameters to connect to v12?