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 126.96.36.199.0
If the aggregation rule of your column formula is set to Server Complex Aggregate then OBIEE will do a REPORT_AGGREGATE.