Skip to Main Content

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!

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.

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details