Tm1 MDX Select Query

Post Reply
Posts: 149
Joined: Sat May 05, 2018 11:48 am
OLAP Product: tm1
Version: 10.3.10100.8
Excel Version: 14

Tm1 MDX Select Query

Post by kavitha2002 » Tue Jul 02, 2019 8:57 pm

Hello Everyone,

I want to clarify a doubt related to MDX Select query. I have a Cube in which the same elements in Row dimension has recursively represented many times in .xdi file.

To read the cube values, below query am using, it returns the wrong value of the cube because of the recursiveness I think.

{"MDX":"SELECT {([Row_dim].Members)} on 0,{([colDim].Members)} on 1 FROM [cube] Where ([titleDim1].[value],[titleDim2].[value],[titleDim3].[value],[titleDim4].[value],[titleDim5.[value]) "}

But query returns correct cube values in these two situation:
1) When row and column dimension elements has no recursive representation
2)using subset in the query works fine

Reading all the members of the Row/column returns wrong value.
Is it the behaviour of the MDX or my understanding is wrong?? Kindly clarify. Thanks.

Post Reply