Need help - Mapping cube

[amritha.tm1]

Hi Everyone,

I am trying to Populate the mapping value from Dim 4 to the mapping cube. Here are the information for the mapping cube and dimensions.
Mapping cube has Geo, Entity and Mapping value dimensions.

1. Geo dim has Geo_Code attribute
2. Entity dim has Entity_Code attribute.
3. Mapping value dim has an element value which needs to be populated from Dim 4, by looking the combination of Geo attr and Entity attr.

mapping value needs to be populated using rules.

Can anyone help me as how to populate using rules.

Please see the screenshot attached for ref:

Thanks in Advance...

[MSidat]

Hi,

Looks like a pretty straight forward rule to write. I am all for being proactive and self learning so will point you in the right direction rather than give you a solution.

Look up the ATTRS Function, which will enable you to pull the relevant attributes data into the cube.

Have a go at writing the Rule, and post back your efforts should it not work as expected.

[amritha.tm1]

Here is the rule i am trying:

['value'] = S: IF (ATTRS('Geo', !Geo, 'Geo_code') @ = SUBST(!Dim4, 1,4) & ATTRS('Entity, !Entity, 'Entity_code') @ = SUBST(!Dim4, 5, 9), ! Dim4, CONTINUE);

But getting error...Might be syntax wrong.

Thank You! Msidat

[amritha.tm1]

Its okay...even if can populate the value by concatention of Attr from dim1 + attr from dim2 without referring dim4.

Thanks in Advance.

[qml]

You have a few basic syntax errors there:
- spaces in the "@=" operator;
- unclosed single quotes;
- a space between the exclamation mark and the dimension name (not sure, this may work).

[anote]

Amritha.tm1

You can try this way

['value'] = S: IF(DIMIX('Dim4',ATTRS('GEO',!000_Geo,'Geo_code')|ATTRS('Entity',!Entity,'Entity_code'))>0,ATTRS('GEO',!Geo,'Geo_code')|ATTRS('Entity',!Entity,'Entity_code'),continue);

Hope this might help