Need to Generate some records based on attributes of two dimensions

[guvvalasairam436]

Hi Connections,

There is a requirement to generate values based on the attributes of the dimension's, as per the below example for brand and legal entity we are maintaining country property based on that the records need to generate. Attribute of type is text

[N1kh1l · Accepted solution]

guvvalasairam436

If country us not a dimension in your model, You would need another 2 set of attributes of type integer and maintain numeric codes for all possible country values. For e.g. PL =1, UK = 2 etc.

FOREACH[d/BRAND],[d/LEGALENTITY]
IF[d/BRAND].[p/Country_code]=INT(ATTRIBUTE([d/LEGALENTITY].[p/Country_code])) THEN

DATA()= 0.000001

ENDIF
ENDFOR

Please specify all dimensions in MEMBERSET or DATA(). Also as this will run on master data mode, its not advisable to do such calculations with large dimensions.

Br.

Nikhil