SSAS Cube creating one hierarchy from to dimensions

• christian_t

  Hall of Fame

  Points: 3588

  More actions

  March 11, 2011 at 5:07 am

  #248036

  hi guys,

  a college of mine is building a cube and has built a few dimensions.

  The users now want a hierarchy over to independend dimensions.

  Is is possible to build this hierarchy or does he have to join the to dimensions to do it?

  Greetz Mitch

• Koen Verbeeck

  SSC Guru

  Points: 259115

  More actions

  March 11, 2011 at 7:36 am

  #1297615

  As far as I know, you can only build hierarchies inside a dimension, so you'll probably need to join the dimensions into one single dimension.

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP