Rules at Attribute Control Cube

[Goatship]

Hi All,

We have two cubes.
At Cube A (data is ‘Grades’), ‘DB’ rule goes as follows;
[‘USA’] = DB(‘B’, ATTRS(‘Name’, !Name, ‘ID_attribute’), !Year, ‘USA’);
Note: ‘Name’ dimension has an attribute 'ID_attribute' with attribute elements matching to ID dimension.

At Cube B, ‘ID’ is a dimension.
Feeders;
[‘USA’]=> DB(‘A’, ATTRS(‘ID’, !ID, ‘Name’), !Year, ‘USA’);
In order to feed this rule, we need to create an attribute on the ‘ID’ dimension which has attribute elements as ‘Name’.

Any idea on how to write a rule at the control cube of attribute of ‘ID’ dimension to populate the ‘Name’ attribute element ?
Suppose the ‘Name’ attribute on ‘ID’ dimension is the ‘NameFeed’
[NameFeed] = (IF ( !ID @= ATTRS(‘Name’, ‘Sara’, ‘ID_attribute’), ‘Sara’, stet);
We can only refer to ‘Name’ dimension by element, not the ‘!Name’.
Since the attribute control cube has only one dimension, it seems impossible to write one rule referring to every element on a dimension in another cube.

If not rules, any other alternatives you recommend, apart from filling out the cube manually?


Thank you very much.

[mce]

If elements in your Name and ID dimensions are one-to-one, why do not you combine them in one dimension and use ID and Name as alieses of each other?
This would simplify your problem considerably.

[Goatship]

Unfortunately, they are not one-to-one, and their matching has no pattern too.
Thanks for your answer anyway.