Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a case, we have to report some figures on a node level and ignore the aggregated value of its children.
How to manage the Measure in this case?
Please, share some data of what u have and what u want to do..
It's nearly impossible that someone would try to imagine what u have and come up with a response..
We need a bare minimum to be able to help 🙂
Ex:
Dimension: Account Hierarchy.
Lev1,Lev2,Lev3
Total, AccL1, AccL1.1
Total, AccL1, AccL1.2
Total, AccL2, AccL2.1
Total, AccL2, AccL2.1
Data:
Acc,Data
AccL2.1, 200
AccL2.2, 200
AccL2, 50
AccL1.1, 100
AccL1.2, 100
AccL1,30
A normal report should be like
AccL1 ----> 200
AccL2 ----> 400
The requirement is to ignore the aggregation and show only the member's value like
AccL1 ----> 30
AccL2 ----> 50