Skip to Content
0
Apr 09, 2016 at 01:28 AM

Hierarchy Disaggregation in Input Ready Query

317 Views

Hi,

I have few questions on Disaggregation being done on Hierarchy:

I have a simple input ready query with Customer hierarchy being drilled down and Input Ready Key Figures with setting "Disaggregate Value Entered" and using Self Reference.

Case 1: When i enter any values at Level 3 as 300 (shown below), it is disaggregated between Level 4 as 200 & Level 5 as 100.

Not sure how it is deriving the ratios when i have marked it as Self Reference for the first time there are no values at all.

Shouldn't this Level 4 be 300 and Level 5 as 300. ??

Because, when Level 4 is collapsed and its showing 200 it gives wrong impression to the user. Can you please help me with solution to fix this.

For eg:

Hier Level 1- 300

-Level 2 -- 300

- Level 3

- Level 3 -- 300

- Level 4 -- 200

- Level 5 - 100

Case 2: Now when i change some values at Level 5 as 100, it is getting updated even to Level 4 as 200 (+100) and thus Level 3 is showing wrong aggregation values.

Hier Level 1-

-Level 2

- Level 3

- Level 3 -- 400

- Level 4 -- 300

- Level 5 - 200