Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

When REPORT AGGREGATE Works And How To Disable

Received Response
91
Views
1
Comments
Ganim Altiok
Ganim Altiok Rank 3 - Community Apprentice
edited Aug 13, 2024 5:57PM in Oracle Analytics Forum

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.

Answers