Hello Everyone,
I have gone through couple of threads but couldn't find proper way to proceed. Please provide your input on the same.
1. I have to develop Finance report which has
- Organization Dimension which has Hierarchy of All Units -> Unit 1, Unit 2 & Unit 3.
- Account Dimension have values like Revenue, Tax, Expense and Tax % to Revenue.
- Time Dimension have values like 2016.01, 2016.02,2016.03, 2016.Q1
I want to show MTD Finance report where Time dimension is in Context and based on the month I select from context, It should show MTD Finance report. You can see from above screenshot if user selects 2016.01 then it should show data for 2016.01 and likewise for 2016.02 and 2016.03 . which is easy and managed.
1. User wants to see the same Finance report at Unit level and consolidated also (Means All Units column). I have brought All Units node into BPC report but the only problem I have is Average of Percentage. It sums up all the values and percentage in BPC where as I want Percentage should get Average and values should get sum.
2. User also wants this report to be managed by Time Context. Means if he selects 2016.Q1 instead of 2016.01, 2016.02, 2016.03 then above report should look like below screenshot. Again here all the Accounts values like Revenue, Tax and Expense should be summed up but Tax% to Revenue should show Average of Percentage value for the entire quarter.
3. Last requirement I have is....I have Budget data for all Units. I want to show Budget, Variance and Variance % column for all Units individually and at consolidated level also.. I was able to achieve Variance by writing Member formula's (Actual-Budget) but I want to show Variance % value in Percentage which I am not able to get by writing member formula. Can anybody suggest how to achieve this ?
Did anybody come across this kind of scenario before ? Please provide your input on how this can be achieved ?. Appreciate all your input help in advance.
Regards,
BI New