For multiple FUNCTIONS look on my example:
I have COMPANY_CODE and COST_CENTER with a property BPC_COMPANY_CODE
First I create report with both COMPANY_CODE and COST_CENTER in row axis.
Then in member selector for COMPANY code I use:
And with EPMDimensionOverride I have report for 2 COMPANY_CODE members:
You can use Excel formulas to create the override condition like: "BPC_COMPANY_CODE=CO_BR00 OR BPC_COMPANY_CODE=CO_AU00"
Easy:
If you need to select only one function then you can use EPMDimensionOverride to override PROJECT dimension using FUNCTION property.
If you want to select multiple functions then you can establish relation between function and project in the function member selector (function = property function of project). Also use EPMDimensionOverride to override PROJECT dimension using FUNCTION property (multiple properties).
Hi Jordan
Function can be given as selection in the context depending on the function selected Epmdimensionoverride for PROJECT will display many projects which are relavent to that function.
Example:
If Function is given as selection in c9 cell as =epmcontextmember(,Function)
if selection is Function1
Selected member in this case Function1 should be passed to dimension override function as below
=EPMDimensionOverride("000","PROJECT","'$C$9'")
Row axis will be filtered by Function1 relavent projects.
Other way:
This can also be done using linking Function property to PROJECT dimension.
Hope this helps for your requirement. Thank you
Regards,
Durgaprasadh
Add comment