EPMDimensionPropertyValues and datavalidation

[Former Member]

HI All,

Im trying to use this epmfunction, to make a drop down list in report, based on properties values,

But the result given not appears correctly so that, it is not possible to select one property values

Does anybody faces that problem ?

tks for your help,

[Former Member · Accepted solution]

Hi Olivia,

If it's ok to double click in a cell and get the member selection instead of a dropdown list you can always do this:

step 1, list of all members, type this in cell C1

=EPMDimensionPropertyValues("connection_name";"DIMENSION";"ID";B2;A:A)

(you can leave connection_name blank)

DIMENSION should be replaced with for example Entity

this will result in a list of ID's in column A

step 2, create a member selector, type this in cell C2

=EPMSelectMember("connection_name";A:A;"PROPERTYNAME=PROPERTYVALUE";"DIMENSION")

PROPERTYNAME should be replaced with your property name

PROPERTYVALUE should be replaced with your property value

if you now doubleclick in cell C2 you will get a list of ID's from choosen dimension where Propertyname=yourPropertyvalue

Brgds

Mattias

[Former Member · Accepted solution]

Thanks a lot for this.

I ve a last question : it seems it is not possible to use this EPMFunction in a diferent sheet,

Is there a way to avoid that, or am I required to make it on the same sheet ?

I'd like, if possible, maintain a specific sheet for this kind of parameters.

Tks,

[Former Member · Accepted solution]

Did a quick example based on Environmentshell... please try and see if it's what you want...

the example use account as dimension and property Acctype

Dropbox - example.xlsm

Brgds

Mattias

[Former Member · Accepted solution]

Really interesting. tks a lot.

[Former Member · Accepted solution]

de rien, there is also a hidden sheet called config sheet