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!

Dimension Data summarizing

clifford_dMar 30 2011 — edited Mar 31 2011

We are using Discoverer Plus version 10.1.2.45.46c. I have some reports out of our data warehouse which is a regular star schema format. Some pretty standard tables, Fact table called Sales Facts and dimension tables called : Vendor, Item, Date,Customer. When I create a report some of the columns in the dimension tables sum. So a numeric dept column should show as 111, will show as 111, 222, 333, etc and it is not real consistent. These fields are defined with a Default Position of Top.

Any help would be appreciated

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 28 2011

Added on Mar 30 2011

#business-intelligence-applications, #business-intelligence-foundation, #discoverer

1 comment

133 views