I need to use some functions of the FPMXLClient Library in an Excel report but I haven't got neither documentation nor examples of use about this library, and there's no help at the Object Browser in the VBA Window. Is there any documentation about this Library and its functions?
Especifically, I need to apply a filter by property to a dimension in the row axis, but I don't know which of the Library functions related to filters can help me to do this.
Thanks in advance.
The is some information in the "EPM Add-in for Microsoft Office User Guide" related to this.
You can find the user guide at http://help.sap.com
I've consulted the guide, and there's explanation about some of the functions, but doesn't explain nothing about filtering functions.
I need to add a filter by property (the value of the property comes from a combobox) to a dimension in the row axis. Which is is the function that I can use to do that?
Thanks in advance.
it's better you post it on the right forum, i.e.
I've been looking around for this as well.
You can try using the EPMDimensionOverride function because the third parameter ("members") in the EPMDimensionOverride function can be a defined as "property=propertyvalue"
(i.e. for the Account dimension, you could use ACCTYPE=INC ).
EPMDimensionOverride ( reportID , dimension, members )
If you are good with Excel you can figure out a way to retrieve the Dimension properties ( EPMDimensionProperty ) and the dimension property values ( EPMDimensionPropertyValues ) and then populate the members parameter dynamically.
Be careful with EPMDimensionProperty function as that brings back "Friendly" values (what was stored as the description in Admin) and EPMDimensionOverride currently does not work with the Friendly values (only technical values). For example in EnvironmentShell, the technical name for Account Type is Acctype, but the friendly name is Account Type. EPMDimensionOverride will work with Acctype, but not Account Type.
To get around this, have the developer know exactly which properties are needed for the report and make a Data Validation Range using the techinal name. Then, use EPMDimensionPropertyValues to get the values of the property. Lastly, as John stated, use EPMDimensionOverride's 3rd parameter (Members) to create a dynamic filter which references the correct values.
Hope this helps,