Question:
Help!
I need to create a reporting hierarchy that is based on customer. I need for the data to be displayed so that Sales Group is the high level node, then Sales Office, then Division of the Material. Basically, I need to create a custom hierarchy using those 3 navigational attributes of Customer Sales and Material.
I don't see where you can select nav attributes to use in a hierarchy? I can't find where you "turn on" nav attr to make them available to be used in hierarchies?
I do see where we can use 0SALES_GRP, 0SALES_OFF etc as an info object in the hierarchy. This gives me no data when we run because these fields are not in the cube and are only navigational attributes of OCUST_SALES?
What am I missing? Help!
Peggy
Answer:
Have a look here:
/forums/viewtopic.php?t=134349