Database 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!

How should we aggregate measures in the cube

3241376May 21 2016 — edited Jun 9 2016

Hi People,

I am new to Oracle Olap ,and I am facing issue when I am mapping the Measure and dimensions in the cube . there is option in the cube mapping for sum ,count etc ,so if I choose option sum, its applying sum to all the measure in the sql ,but my measure some have count and some have sum.

Could you please tell me how can I achieve it.

Thanks,

Pallavi Screen Shot 2016-05-21 at 3.11.18 PM.png Screen Shot 2016-05-21 at 3.33.53 PM.png

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 7 2016

Added on May 21 2016

#data-warehousing, #olap

6 comments

2,077 views