Ignore Aggregation on one of a Dimension Levels

[bannax]

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?

[OmarBenSalem]

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 🙂 

[bannax]

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