Multiple property values in a dimension
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.
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.
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 (",")