Search found 2 matches

by sg9489
Mon Jan 13, 2020 10:55 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX Issues with 2 row dimensions in Active form
Replies: 3
Views: 1002

Re: MDX Issues with 2 row dimensions in Active form

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(CATEGORY...
by sg9489
Sun Jan 12, 2020 10:16 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX Issues with 2 row dimensions in Active form
Replies: 3
Views: 1002

MDX Issues with 2 row dimensions in Active form

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...