1 Reply Latest reply on Aug 25, 2017 12:40 PM by Martin van Donselaar

    When REPORT AGGREGATE Works And How To Disable

    Ganim Altiok
    Ganim Altiok Aug 25, 2017 9:34 AM

      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.