Financial Management Blogs by Members
Dive into a treasure trove of SAP financial management wisdom shared by a vibrant community of bloggers. Submit a blog post of your own to share knowledge.
cancel
Showing results for 
Search instead for 
Did you mean: 
Shrikant_Jadhav
Active Contributor
19,191

As EPMDimensionOverride is mostly used function and requirement is to pass multiple property, I decided to write different scenario of this function with dynamic selection of multiple properties and values of properties.

Function and it's parameters -

EPMDimensionOverride("reportID","Dimension","Member")

The logical operator supported by this functions are as follows

ANDOR
;,

Background

PRODUCT Dimension contains three properties and values as shown in below table.

AREAGROUPFIELD
5109011A

In my given case these are the Dimensions as well.

User is selecting "AREA", "GROUP" and "FIELD" and these value are used to override PRODUCT dimension.


As third parameter of function is "Member" , Concatenate all the desired properties and values of properties in separate cell and give reference of that cell as third parameter in function.

As shown in below first example, Properties and property values are populated in cell "C7:E8" along with logical operator. Desired combination of properties and operator is Concatenated in cell "I8". The formula of cell "I8" is displayed in cell "I7" (Formula 2) . Alternate formula also provide in above cell "I6" (Formula 1). The EPMDimensionOverride function is written in cell "I4". Formula of "I4" is displayed in above cell "I3" . The cell "I8" is used as third parameter in function.

Tested on EPM Add-In SP 20, .NET 3.5 , BPC 10.0 NW.


Comments and suggestions are highly appreciated.


Best Regards,

Shrikant

14 Comments
Labels in this area