Skip to Content
0

MDX BW : Get data from two hierarchies which are part of the same dimension

Mar 07, 2017 at 09:37 PM

34

avatar image
Former Member

Hi,

I'm trying to get data from two hierarchies which are part of the same dimension with a statement like the one i pride below and even the syntax check does not throw and error, the execution fails. Is this something not supported or there is a different syntax I should use.

SELECT {[Measures].[IOCKFP]} on 0,

( [IOCCUST CUST BY CAR COMPANY].[LEVEL01].Members *[IOCCUST CUST BY LOCATION].[LEVEL01].Members ) on 1
from [$ICCASAL]

Thank you

mdx
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers