Question:
Hi all,
For the query with hierarchy,
Is it possible to suppress all result rows in workbook except for the lowest level node in the hierarchy?
Regards,
SA
Answer:
Unless the hierarchy is fully expanded - all entries displayed are "summary" results.
Are you just wanted to remove the grand total?
If you only want particular levels of the hierarchy to display, you could consider restricted key figures instead (but this removes the drill down capability).
_________________
Mitchell Lehr
BW - Share the love ><
Answer:
No, I just want to show the result of leaves node only for example.
The result now show as below,
Characteristics , Result
Level 1.0 , 5
Level 2.0 , 5
child node 1 , 3
child node 2 , 2
What I need is,
Characteristics , Result
Level 1.0 ,
Level 2.0 ,
child node 1 , 3
child node 2 , 2
Pls suggest
Sirikan
Answer:
Hello Sirikan,
I have exactely the same issue in my project.
I see that your inquiry dates July, and so I would like to know if in the meanwhile you found a solution...
Many thanks,
michelino
Answer:
Hi michelino,
I haven't found any solution for this issue yet.
Sorry for couldn't help.
Regards,
Sirikan
Answer:
There is a way to do this but it is a bit messy. It may not give you exactly what you want but play arround with it a bit maybe you get somethign that fits for your situation.
E.g. you have your hierarchy in the rows section of the query,
then add another characteristic to the rows underneath your hierarchy, typically something that only has a single value for the lowest level of the node.
Right click anywhere in the rows box and "Display as hierarchy"
On both the Hierarchy and the second characteristic supress results always
Hope this helps
Answer:
If you are not posting any values to any of the summary nodes you simply need to restrict the characteristic with the hierarchy and de-activate the hierarchy.
This will display only the postable nodes.
Carlos
Answer:
No, there is another solution, which is changing your key figures by formulas, using the LEAF function (In boolean operators).
LEAF retrieves 1 if you're on the end of the tree (individual values) and 0 if you're on a node ...
So, just multiply the KF by LEAF and you should have your solution.
_________________
When my car stops, I first look at the gasoline's level before dismounting the engine.
Tuly Idiot's fan club active member.
Answer:
Sirikan
I am having the same problem.
I have tried all three suggestions and none ot these have given the required result. Please could you let me know which of the suggested solutions you found to work best, or if you found an alternative.
The Boolean option provides zeros for the summary levels, and suppressing the zeros means that the summary levels of the hierarchy do not show at all.
Thanks
Ross
Answer:
Ross
I would suggest using the LEAF Function. What I need is to suppress 0 for the summary and show the result of the leaf node. So this works fine.
Sirikan
Answer:
Sirikan,
How did you exactly do the LEAF function? Did you create a new formula?
Thanks,
John
Answer:
Hi John,
Yes, Create a formula and use the LEAF Function in the Boolean Operators.
LEAF(KF)* KF
Sirikan