MDX statement when having two dimensions on the rows in Active form

Post Reply
hpansar
Posts: 17
Joined: Fri Apr 19, 2013 6:50 pm
OLAP Product: IBM Cognos TM1
Version: 10.2.2
Excel Version: 2013

MDX statement when having two dimensions on the rows in Active form

Post by hpansar »

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")}
Wim Gielis
MVP
Posts: 3105
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

Post by Wim Gielis »

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
User avatar
PavoGa
MVP
Posts: 616
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

Post by PavoGa »

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.
Ty
Cleveland, TN
Post Reply