SummaryWhat are the best Practices to Optimize PCMCS
We using two POV members, Period and Scenario as Dynamic Type to facilitate Formulas. On Top of it we have Account as Dynamic. So, When you run reports or run a query, PCMCS chokes out. Specially when you try to Zoom in or Run Desc of Member in HFR.
The reports run considerably faster when you query only one POV member with Formula. However, when you combine two POV's with Formulas its Chokes really good. Wonder why these two are Allergic to each other.. Any Thoughts ??