Hi Everyone
I think this is the right Board index to ask a general questions.
I have an active form with two dimensions on the rows and want to filter on a value in the column. It works great with 1 dimension on the row but how do I get it to work with two dimensions. The MDX below is for when there is 1 dimension called ICP_OH Account. I would like to put a second dimension called S_Business Unit but don't know how to merge the MDX. Any suggestions would be greatly appreciated.
Thanks!!
Hiten
{FILTER({TM1SUBSETALL([ICP_OH Account])},[ICP_OH Allocations Method].([ICP_OH Allocation Method Measure].[Spread Method])="Input")}
MDX statement when having two dimensions on the rows in Active form
-
- MVP
- Posts: 3117
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.0.9.18
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: MDX statement when having two dimensions on the rows in Active form
What is the logic for the mdx of the second row dimension ?
Best regards,
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
- PavoGa
- MVP
- Posts: 617
- Joined: Thu Apr 18, 2013 6:59 pm
- OLAP Product: TM1
- Version: 10.2.2 FP7, PA2.0.9.1
- Excel Version: 2013 PAW
- Location: Charleston, Tennessee
Re: MDX statement when having two dimensions on the rows in Active form
If an account has different spread methods depending on the BU, this cannot be done in a regular cube view with both dimensions on the rows. It can be done with the BU as a title dimension.
You might can in a websheet.
You might can in a websheet.
Ty
Cleveland, TN
Cleveland, TN