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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

When REPORT AGGREGATE Works And How To Disable

Ganim AltiokAug 25 2017 — edited Aug 25 2017

Hello,

I building a report with counting customer IDs. I have a column formula like "COUNT(CASE WHEN "DIM_DATE"."AS_OF_DATE" = DATE'2017-08-24' THEN "DIM_CUSTOMER"."CUSTOMER_ID" END)".

While usually OBI aggregates the report on DB level with a group by but in this particular report OBI chooses to aggregate on report level.

So my report performance crashes.

How can I make OBI to make aggregation on DB level instead REPORT AGGREGATE?

Oracle Business Intelligence 12.2.1.1.0

Thank you.

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 22 2017

Added on Aug 25 2017

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

1 comment

580 views