Skip to Content
0
May 23, 2016 at 08:27 AM

EPM10 SP24. EPMDimensionOverride ... drop down selection

307 Views

Hi

New to BPC so please be gentle 😊

Designing an input form in EPM add-in and looking to use a drop down list in the form for our Profit Centre dimension. The drop down list is to contain a large number of members not linked in any way by hierarchical relationship or property.

This is what I have attempted so far:

-- Profit Centre in the rows with a single member selected and the column hidden.

-- On another sheet, list of 5 members from the Profit Centre dim and another cell with a drop down list containing these members (using the Excel Data Validation functionality)

-- The following formula in the Page Axis of my input form ... =EPMDimensionOverride("000","Profit Centre",Sheet1!C3) (where Sheet1!C3 is the cell with the drop down list)

The cell with the formula in states 'Expansion of Profit Centre Overriden' so it seems to suggest it has worked? However changing the selection in the drop down then refreshing the report does not appear to change the member of the dimension selected (I had input a value against one of the Profit Centre members and this value still shows no matter which member I select in the drop down).

I have tried wrapping the members in double quotes on the second sheet but this doesnt appear to have made a difference.

It seems a pretty simple requirement so I must be missing something obvious, or maybe this isnt the correct approach to take for this. I have checked the forums but cant seem to find a solution ... in examples I found, the above formula appears to be getting used where member properties are involved so maybe it wont suit in my case.

Any advice appreciated.

Thanks

JB