Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

calculate measure in parent child hierarchy

2885278Apr 24 2015

Halo everyone

I have a requirement about parent child hierarchy namely:

1. see the following picture as a sample.

parent child hierachy.png

the situation I got here is every employee has its own measure (Sales Amount). when it rolls up to 'Employee1' so the Sales will calculate all measure (Employee1 and all the descendents) but when it drill down, 'Employee1' will ONLY show its own 'measure' (it does'nt calculate from its descendents).

Any suggestion, Any idea, Any sharing, Any inspiration would be appreciated. thanks alot.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details