dbTalk Databases Forums  

ordering child members in a ragged hierarchy

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss ordering child members in a ragged hierarchy in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
DanW
 
Posts: n/a

Default ordering child members in a ragged hierarchy - 09-06-2005 , 06:07 PM






We've worked a lot with ragged hierarchies, hiding intermediate levels
with "Hide Member if No Name". Our problem is that the children of
these hidden members are not displayed in the proper order when viewed
as children of a common grand-parent.

Example with a 3-level ragged hierarchy:

Level 1 Level 2 Level 3
Store Type 1
Type 1 L2 A
Type 1 L2 A Store 1
Type 2 L2 A Store 2
Type 1 L2 B
Type 1 L2 B Store 1
Type 1 L2 B Store 2

Store Type 2 (ragged)
Type 2 Store 2
Type 2 Store 1

Note that stores at level 3 are displayed in their proper order when
the intermediate levels (Type 1 L2 A and B)exist.

Store Type 2 contains two separate hidden intermediate levels, so it
appears that the two grandchildren are direct children of Store Type 2.
However the grandchildren do not appear sorted.

QUESTION: Is there any way to keep the grandchildren sorted when the
intermediate level is hidden?


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.