EvPXR 
The EvPXR (Property) function returns an MDX property expression and works with the EvEXP, EvNXP, EvENE, EvSET, and EvLST functions.
Instead of using the Filter property in those functions, you can use the EvPXR function to return an MDX property expression in the form of DimensionName:memberName.Properties("PropertyName").
For example: [Entity].[SalesUS].Properties(Currency) This function can also return the dimension hierarchy name. For example: [Entity.H1].[SalesUS].Properties(Currency)
Syntax
EvPXR("DimensionName","PropertyName","MemberName")
Parameter |
Description |
|---|---|
DimensionName |
The name of the dimension whose members you want to retrieve. |
PropertyName |
The name of the property you want to filter on. |
MemberName |
(Optional) The name of the member you want to filter on. If no member is specified, the current view member is used. |
Example
In the following example, the EvSET function contains an EvPXR formula. The EvPXR formula returns SalesUS and its parents from the Entity dimension, whose currency value is USD and are descendants of WorldWide1.
EvSET("Finance","WorldWide1","SELF_AND_BEFORE",99,TRUE,EVPXR("Entity","Sal esUS","Currency") & "=""USD""")