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!

Cube population with Foodmart data

user38248May 19 2009 — edited May 20 2009

Hi

I am trying to recreate one of the cube's from Foodmart 2000 in Oracle OLAP 11.1.0.7. The cube is mapped to a fact table which references a dimension table. This dimension table has some members which do not have corresponding entries in the fact table. Eg there is a category called 'ADJUSTMENT' which appears in the dimension table but is never referenced by the fact table. In other words there is no data about the ADJUSTMENT category.

In Analysis Services, these unreferenced members remain members of the dimension. In Oracle OLAP they do not appear in the cube's view. Is this by design, or have I made a mistake when replicating the cube/dimensions?

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 17 2009

Added on May 19 2009

#data-warehousing, #olap

2 comments

1,664 views