How to publish calculated data from PCM_CLC to PCM_REP for reporting purposes?
Hello,
We are currently working with Oracle EPM – Profitability and Cost Management and would like to gain a better understanding of how the PCM_REP cube is intended to be used in practice for reporting.
At present, all of our source data and calculated results reside in the PCM_CLC cube, where the model calculation processes are executed. We have already applied optimization options on this cube; however, we are still experiencing delays when running reports, especially those that include formulas.
For this reason, our objective is to shift the reporting workload to the PCM_REP cube, while keeping all calculation processes in PCM_CLC. That said, it is not clear to us what the
0