Collapsing of parent not working after C level rules.

[hello123]

Requirement:
Header Dimensions:
Dimension 3
Dimension 4
Dimension 5
Dimension 6
Dimension 7

		Amount
Dimension 1	Dimension 2	Jan
Primary Code	CNT	45
Primary Code	N	34
Code 1	CNT	45
Code 2	N	34

Header Dimensions:
Dimension 3
Dimension 4
Dimension 5
Dimension 6
Dimension 7

		Amount
Dimension 1	Dimension 2	Jan
Primary Code	CNT	79
Primary Code	N
Code 1	CNT	45
Code 2	N	34

In Cube 2, Primary Code should have sum of Code 1 & Code 2, but in element ‘CNT’ of dimension 2.
The element ‘CNT’ will be attribute of Primary Code, hence populate in it and not in ‘N’.

I have achieved this using an intermediate Cube which has same dimension as in above cases except that Dimension 1 has ‘Primary Code’ as N level ( and not C- level as in above cases).
I used TI to populate the desired result in the intermediate cube.
However while writing the data from intermediate cube to the above cube, I used Rules.

Rules give the desired output, but TM1 behaves weird!
Issue 1: In the final output, Primary Code with ‘N’ data is populating ‘0’ and still displays on the screen even after suppressing zeroes.
Ideally, it doesn’t affect the final result but the client don’t want this to be on screen.

Issue 2: When I compress & collapse any dimension with hierarchy, after collapsing, children of the corresponding parent are not visible. Only + sign changes to – after collapsing.

Both the issues disappear when I save the rule file again. But when I reopen this cube, the issues come up again.
Please let me know where I am going wrong.
Rules I have written is:
[‘Amount’] = C: IF(ELLEV(‘Dimension 1’, !Dimension 1)=1, DB(Intermediate Cube, !Dimension 1, !Dimension 2, !Dimension 3, !Dimension 4, !Dimension 5, !Dimension 6, !Dimension 7, !Dimension 8, ‘Amount’), CONTINUE);

Feeders in Intermediate Cube:
[‘Amount’] => C: DB(IF ELLEV(‘Dimension 1’, !Dimension 1)=1, ‘Source Cube’, ‘’), !Dimension 1, !Dimension 2, !Dimension 3, !Dimension 4, !Dimension 5, !Dimension 6, !Dimension 7, !Dimension 8, ‘Amount’);

[Wim Gielis]

Question: Does this compile at all ?

Feeders in Intermediate Cube:

Code: Select all

[‘Amount’] => C: DB(IF ELLEV(‘Dimension 1’, !Dimension 1)=1, ‘Source Cube’, ‘’), !Dimension 1, !Dimension 2, !Dimension 3, !Dimension 4, !Dimension 5, !Dimension 6, !Dimension 7, !Dimension 8, ‘Amount’);