Hi, all,
Just suddenly dont see a big deal of creating user-defined hierarchies. As user-defined hierarchies are used for navigation purpose only. But you wont complete all possible hierarchies where users may want to browse? What I mean is users can alwyas feel it more flexible to browse the cube data by simply drag and drop any attributes into any way of levels they want to see. Does this make more sense?
Just a bit confused about the big deal of user-defined hierarchy and looking forward to hearing from you shortly for your guidance and advices.
Thanks a lot in advance.
With best regards,
Yours sincerely,
Well, it is pretty much a matter of taste whether you create user hierarchies or you let users use individual attribute hierarchies. However while user hierarchies are less flexible in terms of querying they are arguably more user-friendly, they make defining several types of common calculation much easier (for example if you have a user hierarchy on your Time dimension going Year->Quarter->Month it's very easy to work out what Year any particular Month is in; it's a bit more complex just using attribute hierarchies) and I've heard there are performance benefits to using user hierarchies although I've never noticed any significant different myself.
Chris
|||Hi, Chris,
Thanks a lot for your advanced ideas.
With best regards,
Yours sincerely,
