TM1 Forum

In one of my cube

suppose Cube name is "A" and dim name is "measure" and the element name is "ASP_CY"

Iam doing the calucation and bring thevalue of ASP_CY from cube B only the n level element.

and doing some calculation on i.e Val_QTY=[ASP_CY'] * ['Val_Plan'];

and after that I want the value at consolidation of ASP_CY should be 0. so after the above rule I have written ['ASP_CY']=C:0;

But at consolidation value 0 is not coming...any reason why?

Have you read the RULES GUIDE? Especially order of TM1 calculations?

P.S.

bring thevalue of ASP_CY from cube B only the n level element ..... Val_QTY=[ASP_CY'] * ['Val_Plan'];

Looking at this syntax [ASP_CY] is not being derived from Cube B....

bring thevalue of ASP_CY from cube B only the n level element ..... Val_QTY=[ASP_CY'] * ['Val_Plan'];

the value of [ASP_CY] is coming from cube B in the previous rule which I have not written because value is coming correctly from cube B.

After value has come from Cube B then there is a rule above quoted.

but now I want to put the consolidation of ASP_CY to 0 so I have put [ASP_CY]=C:0;

Full Rule is here below
['ASP_CY' ] =n:IF
(
DB('ASP_BranchWise','ASP SPSA Idea', !Version, !sub_product, !Branches, 'ASP_CY(User)')<> 0,
DB('ASP_BranchWise','ASP SPSA Idea', !Version, !sub_product, !Branches, 'ASP_CY(User)'),
DB('ASP_BranchWise','ASP SPSA Idea', !Version, !sub_product, !Branches, 'ASP_CY(System)')
);

['Val_Plan_CY' ] =
['Qty_Plan_Final' ] * ['ASP_CY' ] \1000000;

['ASP_CY']=C:0;

In my last step value at consolidation 0 value is not coming.

dilip wrote:

bring thevalue of ASP_CY from cube B only the n level element ..... Val_QTY=[ASP_CY'] * ['Val_Plan'];

the value of [ASP_CY] is coming from cube B in the previous rule which I have not written because value is coming correctly from cube B.

After value has come from Cube B then there is a rule above quoted.

but now I want to put the consolidation of ASP_CY to 0 so I have put [ASP_CY]=C:0;

Full Rule is here below
['ASP_CY' ] =n:IF
(
DB('ASP_BranchWise','ASP SPSA Idea', !Version, !sub_product, !Branches, 'ASP_CY(User)')<> 0,
DB('ASP_BranchWise','ASP SPSA Idea', !Version, !sub_product, !Branches, 'ASP_CY(User)'),
DB('ASP_BranchWise','ASP SPSA Idea', !Version, !sub_product, !Branches, 'ASP_CY(System)')
);

['Val_Plan_CY' ] =
['Qty_Plan_Final' ] * ['ASP_CY' ] \1000000;

['ASP_CY']=C:0;

In my last step value at consolidation 0 value is not coming.

My 2c:
1. I would move the ['ASP_CY']=C:0; above the ['Val_Plan_CY' ] rule (so directly underneath the ['ASP_CY']=N: rule).
2. Make sure the AllowSeparateNandCRules=T config setting is added to your tm1s.cfg file.

As others already pointed out I also would like to advise you to follow a training course or at least spend some time working through the Rules Guide.

Michel

I think I have to explain you the Full issue..........

Because I want to fetch only N:level cells value from 'ASP Branchwise' cube and when it got fetched and calculation happens for for ['Val_Plan CY'] then I want the consolidation for The scenario is that after calculation happened for ['ASP_CY'] for n level then I want the consolidation to become zero;

MY Apologies..................

Thank you very much Michel........The issue is resolved.

I saw in the tm1s.cfg file the value of "ALLOw separate N and C rules=F" which I have done true and uncommented.

My issue is solved............