Hi All,
we are having issue in calc times for our aggregations in PBCS.
They are all good until last weekend and calc times exploded from Monday.
- There were no addition of accounts or any dense dimension members
- Data copies, allocations, clears are running good except aggregations
The same aggregation which took less than 5 min last week is taking an hour this week.
Created a SR with Oracle and they say the environment is not changed.
I created a clone in QA and changed the fix statement to limit aggregation only to a month and even that change in calc is taking similar amount of time.
what can I change.
Help please