TM1 Forum

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")}

What is the logic for the mdx of the second row dimension ?

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.