Search found 3 matches
- 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])&...
- 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...
- 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?