Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

0 Answers