Multiple values for a property against a dimension member

[Former Member]

Hello All,

Is it possible to have multiple values for a property against a dimension member in BPC 10 NW?

We have a Plant dimension with Vendor as a property. Vendor is another dimension in the model.

Against a given plant member, say 1000 can we have 2 or more vendors as property, say V1 and V2?

We tried to maintain the property values as V1,V2 and also as [V1],[V2] , however in both cases it fails to retrieve V1 and V2 when we use the EPMMemberProperty function.

The requirement is to have vendors identified against each plant, such that while creating an input schedule relevant vendors automatically appear against each plant.

Can it be handled through vendor property in plant dimension if not is there any other better way to handle it apart from creating a static input schedule.

Thanks in advance

BR

Vineet

[former_member186498]

Hi Vineet,

maybe another possibility is to write some VB code to extract from the string V1,V2 the single dimension values and call the  EPMMemberProperty function you have to try.

Regards

     Roberto