03-22-2022 07:19 PM - last edited on 05-03-2023 12:03 PM by JackLacava
Hi Everyone,
Thanks in advance for the responses. I am reviewing the impacts on a force consolidate on a specific entity and noticed that my results differ when i run a force conoslidate from a cube view and a force consolidate using the calculation definition within process cube.
I made sure that my POV was identical on the cube view versus the process cube.
Can someon explain to me what the difference is or how there could be a difference between the two methods?
Thank you!
03-23-2022 10:07 AM
There should be no difference. Can you explain the differences in results that you are seeing? Perhaps it is a Formula Pass issue. Also screenshot the Calculation Definition and POV of Cube View if possible.
04-06-2022 12:53 PM
Agree with TheJonG. Comparing apples to apples testing, the consolidation times for a force consolidation executed from a Cube View vs. Calc Definition should be negligible. Maybe +- a few seconds. Without more details or screenshots, I can only provide general reasons on why you may be seeing a difference.
1 . The Calculation Definition has additional steps to perform outside of the Force Consolidation or the Force Consolidation points between the 2 are not the same
2. One of the processes was the 1st time a consolidation was done for the month. All subsequent consolidations after the 1st consolidation for the month are faster.
3. The force consolidations were executed on different Consolidation servers. Check to see if both force consolidations were performed on the same Consolidation server.
4. Is the Force Consolidation in a Calc Definition triggered through a Data Management Step and Sequence? If so, the consolidation would execute on a Data Management server while the Cube View Force Consolidation would execute on a Consolidation server. 2 different servers which goes back to item 3 above about different hardware configuration.
5. Were both of the consolidations performed with no user activity in the system? If not, there could have been a slight delay running 1 or both of the processes. Other users may have been executing calculations, translations, or consolidations during the same time of your consolidations. This situation could have put your consolidations in a temporary queueing phase waiting for CPU resources to free up.
There is a lot to think about to answer your question accurately. However, functionally, if you are testing in a vacuum, there should be very little to no consolidation time difference between execution through those 2 processes.