When REPORT AGGREGATE Works And How To Disable

Ganim Altiok

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.

Martin van Donselaar

If the aggregation rule of your column formula is set to Server Complex Aggregate then OBIEE will do a REPORT_AGGREGATE.