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
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
I normally use the descendant function, like descendants([All],2) or you can prompt for a level descendants([All],?level_no?)
Thanks for the help Bark, bi4u2.
Your help is much appreciated :)