on 06-28-2013 12:55 PM
Hi,
I have a report in BPC 7.5 using EVDRE that shows me entities in columns. It is a dynamic report, meaning the entities shown are determined by the expansion range. The expansion range is defined by a simply Excel formula:
if(currency=LC;bas(GROUP);bas(GROUP),GROUP)
in other words, when the report is run in local currency it shows me all my entities across with no total at the end and when it is run in converted currency I get all entities and then the total group at the end.
How do I create such a report in the EPM Add-In for BPC 10? I have tried to use a local member to calculate the total and then hide all empty and zero value columns, but that functionality does not seem to inlcude local members.
Is there a way to create my report (dynamically, so that when I add a new entitiy it is visible in the report without any further changes)?
Thanks,
Arnold
Hi Arnold,
Please use EPMDimensionOverride function for this.
Please refer the below link as well for other function in EPM 10.
http://help.sap.com/businessobject/product_guides/boeo10/en/EPMofc_10_user_en.pdf
Hope this helps.
Regards,
Kalyan.
Addition:
To be more specific it will be something like this,
=EPMDimensionOverride("000","CompanyCode",IF(A1="LC","BAS(Group)","BAS(Group),Group"))
Where
"000" - is the default report ID.
"CompanyCode" - is the dimension name.
Assuming cell A1 will have LC or other currency selection.
Regards,
Kalyan.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I agree with Kalyan; the only way to do that is to use the EPMDimensionOverride. Evdre was really powerfull but actually EPM is not able to do everything in the same way we did in the past with Evdre.
Belive me, In your case you are luky!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
14 | |
4 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.