Ultimate Long TM1 quiz
-
- Regular Participant
- Posts: 353
- Joined: Sat Jun 08, 2019 9:55 am
- OLAP Product: Planning Analytics
- Version: Planning Analytics 2.0
- Excel Version: Excel 2016
Re: Ultimate Long TM1 quiz
MDX can be used in:
Dimension Subsets
Cube Views in PAW, PAX
In TI processes to create source views, build subsets.
In PAX or Perspectives dynamic reports, and probably Universal reports but not got around to those yet.
Just to be clear, re the last question, is that scenario theoretically possible and if so is there nothing that can be done? Asking for a friend....
Dimension Subsets
Cube Views in PAW, PAX
In TI processes to create source views, build subsets.
In PAX or Perspectives dynamic reports, and probably Universal reports but not got around to those yet.
Just to be clear, re the last question, is that scenario theoretically possible and if so is there nothing that can be done? Asking for a friend....
-
- Posts: 101
- Joined: Wed Apr 03, 2019 12:10 am
- OLAP Product: IBM PA
- Version: 2.0.9.x
- Excel Version: Microsoft 365 x64
Re: Ultimate Long TM1 quiz
- In PAFE, report definition for: Quick Report, Exploration, Universal Report, as well as parameter for functions e.g. TM1SET
- In PAW, report definition for explorations and all other visualizations
- In TM1 Server definition for subsets/sets and views, as well as input for various Turbo Integrator functions impacting subsets/sets and views
- In PAW, report definition for explorations and all other visualizations
- In TM1 Server definition for subsets/sets and views, as well as input for various Turbo Integrator functions impacting subsets/sets and views
Take care.
Adam
Adam
- Elessar
- Community Contributor
- Posts: 343
- Joined: Mon Nov 21, 2011 12:33 pm
- OLAP Product: PA 2
- Version: 2.0.9
- Excel Version: 2016
- Contact:
Re: Ultimate Long TM1 quiz
Correct answer:
MDX can be used in:
Question #15:
What will happen after you type "10>" in a cell?
MDX can be used in:
- Dynamic subsets
- MDX views
- TM1SET function
- Tm1ellist function (nobody has mentioned it, but it's a very powerful function, check it if you are not using it. For example, here I have described how to make dependent picklist using TM1ELLIST: https://advoynev.wordpress.com/2021/10/ ... -function/)
- CreateFromMDX, ReplaceWithFormats and other functions in PAX-API
Question #15:
What will happen after you type "10>" in a cell?
Best regards, Alexander Dvoynev
TM1 and Data Science blog: 6th article - PAfE + VBA: Commit each cell without pressing “Commit” button.
TM1 and Data Science blog: 6th article - PAfE + VBA: Commit each cell without pressing “Commit” button.
-
- Posts: 101
- Joined: Wed Apr 03, 2019 12:10 am
- OLAP Product: IBM PA
- Version: 2.0.9.x
- Excel Version: Microsoft 365 x64
Re: Ultimate Long TM1 quiz
Nothing. You have to hit enter first.
After you hit enter, 10 will replace each of the cells in that cell and to the right. In this case Total Year will now equals 120.
After you hit enter, 10 will replace each of the cells in that cell and to the right. In this case Total Year will now equals 120.
Take care.
Adam
Adam
- Elessar
- Community Contributor
- Posts: 343
- Joined: Mon Nov 21, 2011 12:33 pm
- OLAP Product: PA 2
- Version: 2.0.9
- Excel Version: 2016
- Contact:
Re: Ultimate Long TM1 quiz
Correct answer:
This will put "10" to current cell and all leaf cells to the right.
Winner of this week is Adam! (and nice catch with Enter)
Question #16:
What is the minimum dimension quantity in a cube?
This will put "10" to current cell and all leaf cells to the right.
Winner of this week is Adam! (and nice catch with Enter)
Question #16:
What is the minimum dimension quantity in a cube?
Best regards, Alexander Dvoynev
TM1 and Data Science blog: 6th article - PAfE + VBA: Commit each cell without pressing “Commit” button.
TM1 and Data Science blog: 6th article - PAfE + VBA: Commit each cell without pressing “Commit” button.
- Elessar
- Community Contributor
- Posts: 343
- Joined: Mon Nov 21, 2011 12:33 pm
- OLAP Product: PA 2
- Version: 2.0.9
- Excel Version: 2016
- Contact:
Re: Ultimate Long TM1 quiz
Wow, I'm not aware of this! How?
Best regards, Alexander Dvoynev
TM1 and Data Science blog: 6th article - PAfE + VBA: Commit each cell without pressing “Commit” button.
TM1 and Data Science blog: 6th article - PAfE + VBA: Commit each cell without pressing “Commit” button.
-
- Posts: 101
- Joined: Wed Apr 03, 2019 12:10 am
- OLAP Product: IBM PA
- Version: 2.0.9.x
- Excel Version: Microsoft 365 x64
Re: Ultimate Long TM1 quiz
Two. However, I remember getting weird issues with some client apps, so I always do at least three.
Take care.
Adam
Adam
- Elessar
- Community Contributor
- Posts: 343
- Joined: Mon Nov 21, 2011 12:33 pm
- OLAP Product: PA 2
- Version: 2.0.9
- Excel Version: 2016
- Contact:
Re: Ultimate Long TM1 quiz
Correct answer: 2
Winner of this week is Adam and he takes the lead!
Question #17:
Where are dimension attributes stored?
Winner of this week is Adam and he takes the lead!
Question #17:
Where are dimension attributes stored?
Best regards, Alexander Dvoynev
TM1 and Data Science blog: 6th article - PAfE + VBA: Commit each cell without pressing “Commit” button.
TM1 and Data Science blog: 6th article - PAfE + VBA: Commit each cell without pressing “Commit” button.
-
- Community Contributor
- Posts: 288
- Joined: Fri Feb 15, 2013 5:49 pm
- OLAP Product: TM1
- Version: PA 2.0.9.1
- Excel Version: 365
- Location: Minneapolis, USA
Re: Ultimate Long TM1 quiz
Dimension attributes or element attributes? Attributes for elements of the primary hierarchy of a dimension are stored in a separate, two-dimension cube with name like "}ElementAttributes_<DimensionName>". The two dimensions are the dimension itself and a measures dim called "}ElementAttributes_<DimensionName>". Attributes for consolidated elements of alternate hierarchies are presumably also stored in a similar cubestore, but that's not viewable as a control object in PAW/Pafe or Architect. Dimension level attributes are stored in a cube called "}DimensionAttributes".