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!

Help on OLAP 10g Cube

446982Aug 16 2011 — edited Aug 16 2011

Hello Experts ,

Anybody has idea why simple SUM on measure group by dimension on my OLAP 10g cube performing so slow even a simple query taking lot of time and even not returning the result , Is it due to performance cause or due to some design issue or due to DB pramaters which restricting the cube data to be returned ?Is it known issue with database bug . I am on AWm 10g latest with 10g 64 bit DB 10.2.0.4 .

As we are completly stuck and not being able to progress the query on simple cube build on 20K data wiith 7 dimension However we tried with 2 dimension and it works perfectly fine .

any advice ?

Thanks ,
Debashis

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 13 2011

Added on Aug 16 2011

#data-warehousing, #olap

5 comments

113 views