Hierarchies across multiple dimensions


How can we make a hierarchy from multiple dimensions ? I am not able to select attributes from another dimension. – Sreekumar KP

Ans : The doubt arise here is because there is no relation defined between tables in DSV. If there is no table level relationships defined, then we should consider making logical relationship. Once you define logical relationship between tables, then you define the dimension, attributes from related dimensions will come there, and you can simply select the hierarchical attributes.

image

If you make this change after creating the dimension then it may not reflect there, you may need to go back and recreate the dimension again.

Advertisements

Comment please...

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s