TM1 Forum

Hi Mark, Thanks for the reply. There are 2 lookup cubes: 1. CUBE2.LOOKUP Dims: KPI, CENTRE, PERIOD 2. CAT.LOOKUP Dims: CATEGORY, KPI, CENTRE, PERIOD My bad, I have mentioned it wrong, but it is as below in the actual TM1 environment: MDX:"{FILTER({TM1FILTERBYLEVEL({HIERARCHIZE({TM1SUBSETALL(CAT...

Hi Folks, Query: Unable to load MDX dimension if dependent on another MDX dimension in the same sheet. Details: Attached is the active form of Cube 2 with 2 dimensions in the title, 2 in rows and 1 in column. Dimensions in rows are: KPI CAtegory Row dimension KPI is calculated as MDX depending on th...