Ragged Hierarchy

[Spharingo]

 Hi Guys
My structure is a Ragged Hierarchy  the requirements i have got is to display the second last level plus some other items.this is easy when you have a balanced Hierarchy because you can drag a certain level to a report. but with ragged hierarchy you wont know the last level it rolling down to.

i have used below query to get the last level but i need level prior to this.

filter( members (HIERARCHY );  count(1 within set children( currentMember( HIERARCHY )  )  ) = 0 )

Regards
Spharingo

[MFGF]

Hi Guys
My structure is a Ragged Hierarchy  the requirements i have got is to display the second last level plus some other items.this is easy when you have a balanced Hierarchy because you can drag a certain level to a report. but with ragged hierarchy you wont know the last level it rolling down to.

i have used below query to get the last level but i need level prior to this.

filter( members (HIERARCHY );  count(1 within set children( currentMember( HIERARCHY )  )  ) = 0 )

Regards
Spharingo

Hi,

In a ragged (and in an unbalanced) hierarchy there is no concept of there being a last level or a second last level. If you follow different branches of the hierarchy you might find the members extend for three, four, ten, twenty levels, and it will vary from branch to branch. Essentially you're not going to be able to deliver a robust, reliable solution based on an unbalanced or ragged hierarchy - OLAP tools are simply not designed to work in this way. You really need to revisit the design of the hierarchy and balance it to make it useable and robust.

Oh, and please don't use the calendar to create new posts on Cognoise. If you are unsure how to create a new post, please read the FAQs thread here - FAQ3 covers how to create posts.

MF.