If you are unable to create a new account, please email support@bspsoftware.com

 

How to remove 'All' level member from a hierarchy,which is displayed in the list

Started by xyz, 27 May 2014 09:15:50 AM

Previous topic - Next topic

xyz

Hi All,

Say suppose, I have a tree prompt, which is using a hierarchy known as Priority, which has levels and members like below, which I am using in a list report.

Hierarchy.Priority
-All     Level 1
--Priority Level 2

My requirement is Priority tree prompt which is required and mutli select will display 'All' by default, if we expand it, it will display further level. I am displaying Priority hierarchy in list along with load count measure. The issue, I am facing is, under Priority tree prompt, I have different members in level 2, if I filter on level 2 member then list displays 'All' level member as well as filtered member from level 2. Where as it should not display 'All' level1 member. How to avoid 'All' member? 

List with default selection

Priority                             Load Count
All                                    2

List with level 2 member selection

Priority                            Load Count
All                                   2
Everything                      2


Where as, if I check in the database the Load count measure is only 2 for 'Everything' level 2 member. If we do over total for the list then the sum is 4, which is wrong. Can you guys, help me, how to achieve the above same.

I tried option like splitting the tree prompt with two queries, one contain only 'All' data and other query contain other than 'All' members data, using conditional block and variable, i tried swapping between two tree prompts, when the tree prompt with except 'All' members is selected, then the tree prompt with 'All' member is getting checked by default, how to avoid it?

My requirement is even though 'All' is selected, I don't want 'All' member to be displayed in the list as well as tree prompt


Your help will be much appreciated :)


Thanks & Regards,
Xyz

Bark

If you don't want the All displayed at all, ever, then you could an "except(?pMembers?,[All])" in the data item that goes into the list.

If you want the [All] displayed only if nothing else is selected, then you could use:
#promptmany('pMembers','memberuniquename','[All]',set(','',')')# in the data item that goes to the list. This will use "[All]" if nothing is selected (so you would probably need to add a note in the tree prompt stating that no selection means all). and it creates a set if any selection is made.

Also, you could combine them to assure the All is not displayed if selected by mistake:
#promptmany('pMembers','memberuniquename','[All]',except(set(','','),[All])')#

Hope it helps.

Regards,

Bark

bi4u2

I normally use the descendant function, like descendants([All],2) or you can prompt for a level descendants([All],?level_no?)

xyz