TM1 Forum

Hi,
Please find the attached, i have tried to fill the comment like if corporate title is not present in the look up cube then give comment as not available if it is false.
If it is true give as it is like corporate title, but I am getting error.Please suggest me
this is the rule I have written.I am getting an error

['Comment']=S:IF(DB('Detail_cube',!UBR_CC,!SlNo,'CorporateTitle')@=DB('lu_cube',!SlNo,'CorporateTitle'),['CorporateTitle'],'NotAvialable');



TM1 9.5.2
Excel 2003.

charan wrote:Hi,
Please find the attached, i have tried to fill the comment like if corporate title is not present in the look up cube then give comment as not available if it is false.
If it is true give as it is like corporate title, but I am getting error.Please suggest me
this is the rule I have written.I am getting an error

['Comment']=S:IF(DB('Detail_cube',!UBR_CC,!SlNo,'CorporateTitle')@=DB('lu_cube',!SlNo,'CorporateTitle'),['CorporateTitle'],'NotAvialable');

TM1 9.5.2
Excel 2003.

HTH:
['Comment']=S:IF(DB('Detail_cube',!UBR_CC,!SlNo,'CorporateTitle')@=DB('lu_cube',!SlNo,'CorporateTitle'),DB('lu_cube',!SlNo,'CorporateTitle'),'NotAvialable');

kpk wrote:

charan wrote:Hi,
Please find the attached, i have tried to fill the comment like if corporate title is not present in the look up cube then give comment as not available if it is false.
If it is true give as it is like corporate title, but I am getting error.Please suggest me
this is the rule I have written.I am getting an error

['Comment']=S:IF(DB('Detail_cube',!UBR_CC,!SlNo,'CorporateTitle')@=DB('lu_cube',!SlNo,'CorporateTitle'),['CorporateTitle'],'NotAvialable');

TM1 9.5.2
Excel 2003.

HTH:
['Comment']=S:IF(DB('Detail_cube',!UBR_CC,!SlNo,'CorporateTitle')@=DB('lu_cube',!SlNo,'CorporateTitle'),DB('lu_cube',!SlNo,'CorporateTitle'),'NotAvialable');

Sorry:
['Comment']=S:IF(DB('Detail_cube',!UBR_CC,!SlNo,'CorporateTitle')@=DB('lu_cube',!SlNo,'CorporateTitle'),DB('Detail_cube',!UBR_CC,!SlNo,'CorporateTitle'),'NotAvialable');

Peter thank you very much,
So for string elements we should not use element alone, we have to take DB function along is it?
One more request after following you,

1) the rule is working but when I alter the data entry values in the look up cube it is not matching,I will give the screen shot for this.
2)If I enter same data in both the cubes then this rule working.

Please find the screen shots respectively for 1 and 2

Any suggestion to make this adjustment to make it more dynamic.

Thank you

charan wrote: So for string elements we should not use element alone, we have to take DB function along is it?

Yes

charan wrote: 1) the rule is working but when I alter the data entry values in the look up cube it is not matching,I will give the screen shot for this.
2)If I enter same data in both the cubes then this rule working.

It seems to me that the rule works as you defined the condition.
What is your intention?

my intention was in the look up what ever data was entered should match with the data in detail cube;
Here in the rule it was working by matching the cells both in detail and look up cubes when both are same it is giving the title when the cells are not matching it is giving false condition like not available.
So i want the title whatever like not in the same cells but same titles should match and give it in the comment.For that i am requesting for dynamic if tomorrow I add few more it should give.
Like if you see in the first screen after rule working it is giving false condition like not available tough the corporate title is in the look up, because cells are not matching so it is giving as not available. But when the cells are matching it is giving corporate title.

charan wrote:my intention was in the look up what ever data was entered should match with the data in detail cube;
Here in the rule it was working by matching the cells both in detail and look up cubes when both are same it is giving the title when the cells are not matching it is giving false condition like not available.
So i want the title whatever like not in the same cells but same titles should match and give it in the comment.For that i am requesting for dynamic if tomorrow I add few more it should give.
Like if you see in the first screen after rule working it is giving false condition like not available tough the corporate title is in the look up, because cells are not matching so it is giving as not available. But when the cells are matching it is giving corporate title.

Like KPK has said; the rule is doing exactly what the IF statement specifies.

What do you want the ['Comment'] measure to state when ['Corporate Title'] in the "Detail Cube" is "SSE" but "MD" in the equivalent cell for the lookup cube?