Multiple property values in a dimension

[Former Member]

Dear All,

Please help me if BPC can identify multiple property values in a property field separated by comma.

Please see below example:

I have 3 plants and 6 customers and not all customers are supplied from all plants. In customer dimension, I have mapped the plants from where they are supplied as one of the property.

(Dimension)	(Property)
CUSTOMER	PLANT
Customer_A	Plant_A,Plant_B
Customer_B	Plant_A,Plant_C
Customer_C	Plant_B,Plant_C
Customer_D	Plant_B,Plant_C
Customer_E	Plant_A,Plant_B
Customer_F	Plant_A,Plant_B,Plant_C

Now, In excel EPM add in, I want to write a dimension override formula for customer to display customer list applicable for a selected plant as: =EPMDimensionOverride("000","CUSTOMER","PLANT=PLANT_A"). From this formula I expect only customers A, B, E and F are displayed.

But this does not work.

I was able to achieve this by modifying my customer dimension as below and use EPMDimensionOverride("000","CUSTOMER","PLANT_A=Y") formula.

(Dimension)	(Property)	(Property)	(Property)
CUSTOMER	PLANT_A	PLANT_B	PLANT_C
Customer_A	Y	Y	N
Customer_B	Y	N	Y
Customer_C	N	Y	Y
Customer_D	N	Y	Y
Customer_E	Y	Y	N
Customer_F	Y	Y	Y

However, I would prefer initial option of having all the applicable plants defined in only one property field.

Is this possible and will BPC identify different property values separated by comma (",")

Regards,

Sandeep.

[Former Member · Accepted solution]

Hi Sandeep,

I would suggest to try create a formula in another cell to determine if PLANT_A exists in a property, then return Y or N, then use Y or N inside you override formula.

if you use PLANT=PLANT_A then it try to match text that =PLANT_A which will return false as you have PLANT_A,PLANT_B

Andy