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!

Set Aggregation type of Count Distinct to use correct table aggregation in

octoniJun 8 2011 — edited Jul 5 2011

Hi there,

Currently I use OBIEE 10.1.3.4.1 , and there is a case where a fact table consist of 2 logical table source: detail and aggregate table, which has some measure using count distinct as aggregation type. The problem is everytime I browse the measure with no dimension at all , it always use detail table not aggegation one..

Really appreciate for any suggestion ..

thanks a lot

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 2 2011

Added on Jun 8 2011

#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee

7 comments

883 views