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!

Finding Average of Sales

564824Apr 3 2008 — edited Apr 23 2008

Hello,
Database Version: Oracle 11g
I have a cube having 4 dimensions-- 1 Time dimension and 3 User dimensions namely Channel, Mode and Type.
I want to find the average of sales over a period of 3 months based on different Channel, Mode and type.
For Eg., i want to find average sales done by Channel A AND Mode B AND Type C between 1-JAN-2008 and 31-MAR-2008.
How can i find this.
Using the views created by AWM while creating the cube, i can get the cummulative sales for these dimensions, but not average.I tried using Calculated measures, but whenever i select the required Channel, Mode and Type, the selected Channel, Mode and Type is not added in the expression created. And again i get the cummulative value irrespective of Channel, Mode and Type.
Please help me find a solution for this. Or atleast a query for finding the average.

Locked Post

New comments cannot be posted to this locked post.

Locked on May 21 2008

Added on Apr 3 2008

#data-warehousing, #olap

20 comments

4,060 views