Hello
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
Thanks
Marc Kuipers
Hello,
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.
Hi,
it's better you post it on the right forum, i.e.
http://scn.sap.com/community/epm/businessobjects-planning-and-consolidations-for-microsoft or
http://scn.sap.com/community/epm/businessobjects-planning-and-consolidations-for-netweaver
Kind regards
Roberto
Hello Roberto,
The EPM Add-in is used for all EPM products, not just BPC
In fact, its predecessor (Excel Analyzer) was initially developed for BFC
So, this forum is the correct one
Marc
Hi Marc,
sorry for the mistake.
Kind regards
Roberto
Hi there,
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.
HTH,
John
Marc,
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,
Rob
