This content has been marked as final. Show 4 replies
Are you using calc parallel in any of the scripts or essbase.cfg as I wonder if the following doc in Oracle Support helps in anyway - "Essbase 22.214.171.124 Calculations/Business Rules Performance Degradation from Previous Versions [ID 1393530.1]"
Sorry for the delay, I was OOO.
I am actually using calcparallel 3 in the essbase.cfg.
I will try using
SET CALCPARALLEL 1;
SET CALCTASKDIMS 1;
and update the results soon.
I tried to use the solution you proposed, but it didn't help.
Still a calculation that took 12 min in the old enviroment, took hours in the new one.
I Have the same issue on 126.96.36.199 and did not find any solution other than using SET CALCPARALLEL 1; but server is only use with 3% of his capacity...