Hi Experts
I am working on building a P&L statement with variance reporting. I have categories Actual, Budget and the once finalized, the Budget will be copied into year specific budget category. Here I have two issues:
1. While creating the local member for comparison of Actual with one specific Budget is no issue and I can write a formula with local member detection ON to get something like below:
=EPMComparison(, EPMDIM_CURRENT_MEMBER(GL_ACCOUNT), EPMMEMBER([CATEGORY].[].[BUDGET]), EPMMEMBER([CATEGORY].[].[ACTUAL]))
But I am still trying to find a way to make the Category for Budget dynamic, so that user can compare the Actual with any category of budget depending on the context selection.
I have gone thru the webblog How to build Rolling Forecasts in BPC 10.0.
2. I have done formatting on the basis of HLEVEL and have the conditional formatting for Variance local member, the issue is, at the intersection, the formatting of local member prevails and it overwrites the formatting, which is different for each HLEVELs, I have tried "1719535 - EPM Add-in: Formatting an intersection between a local member and dimension member" but didnt not help.
Any idea about these two.
Regards
-SM