EPM Member property as a selectable field

[former_member254616]

Dear All,

In one of our report, when we select the "Market" in cell B1, the property of Market which is "REP_UNIT" populates in cell B2 based on the selection in cell B1

In Cell B1, Market =@EPMContextMember(,"market",,1)

In Cell B2, Entity =@EPMMemberProperty(,B1,"REP_UNIT")

Now, the requirement is, Cell B2 should be a selection field instead of a display field but it should still point to default "REP_UNIT" up on the selection of the Market but should be selectable field.

so, for e.g., when user selects Market "US" in cell B1, Cell B2 should populate "RUS33971" which is populated from the Dimension but Cell B2 should be selectable field.

Any ideas please?

Thanks and Regards,

VRR

[former_member254616]

Hi Nikhil,

Thanks for your reply. I agree with you but that is the Business requirement. They want it to be selectable instead of display only.

Regards,

VRR

[N1kh1l]

vrr.kovvuri

What business requirement does it serve to make it selectable? You can make B2 a dropdown selection then but its still weird. If B2 contains the formula it cannot be selectable. So either a dropdown in B2 or use another cell B3 to read the property and then using a macro assign the value in B3 to B2 in a cell change event of B1 or after refresh based on your need.

Nikhil

[N1kh1l]

vrr.kovvuri

vrr.kovvuriWhat's the idea behind making B2 as selectable when it only displays the property of member in B1. B2 will always have a single value as its a property value so what is the point of making it selectable. Unless you are running some macro on B2 selection it does not make any sense.

Nikhil