Error : Rules applies to cell

[kkmk]

I have seen answered this query many times. But still I have a problem. I have applied rule for a particular cell and I am trying to copy data from one element to another for the rest of the cells.

I have checked CELLISUPDATEABLE as given below:

IF(CELLISUPDATEABLE(destCubeName, vRegion, vYear, vVersion)=1);
CELLPUTN(vValue, destCubeName, vRegion, vYear, pTargetElement);
ENDIF;

When I run the TI process, I am getting the error:
"Region1","2009","Actual","1.",Data Source line (2) Error: Data procedure line (6): Rule applies to cell

What could be the reason?

KKMK.

[Steve Rowe]

~vVersion=pTargetElement

(vVersion and pTargetElement have different values)

or a bug

[Michel Zijlema]

As Steve mentioned, the reference you're testing isn't the same reference you're writing to.
You should test the destination cell:
IF(CELLISUPDATEABLE(destCubeName, vRegion, vYear, pTargetElement)=1);
CELLPUTN(vValue, destCubeName, vRegion, vYear, pTargetElement);
ENDIF;

If the calculation is the same for all versions, then a less obvious thing which could be causing your problem (depending on the TM1 version used) is the fact that if you're copying data from one version to another and the source view contains rule calculated cells that previously (before the rule was applied) contained stored data, then these cells will still contain this data and will be contained in your source view dataset - even when skip rule calculated cells has been selected.

Michel

[kkmk]

Thank you steve and Michel. It is resolved.

KKMK

[dima55]

Hi All


Please correct me if i am wrong.If i use CellIsupdateable it will only update the cell depending on the condition i.e if (CellIsupdateable=1).
That means if the cell contains data than it wont be updateable. What should be done to Update all the cells by deleting the prior entries.

Thanks
dima

[tomok]

That means if the cell contains data than it wont be updateable.

Where did you come up with that assumption? A cell is not updateable only if it is either 1) a consolidated node, or 2) has a rule applied to it. Whether there is any data in a particular cell has nothing to do with whether it can be updated.

What should be done to Update all the cells by deleting the prior entries.

Hmmmm. Maybe use the ViewZeroOut function????

[dima55]

Thanks tomok.

Sorry for the silly questions. I am new to TM1(this is first tool i am working on ). i read the manual but couldnt find answer for the above question.

Thanks
dima

[dima55]

Hi ALl

We can check skip calculated values in TI for this

Thanks
Dima

[Suharsh]

Hello All,

I require a small help on TM1 Rules. I am new in writing the rules. We have a rule that checks this condition

ELISANC('region','AP',!region)=1)

I saw that Elisanc checks if first element is ancestor of 2nd. But I dont know what the "!region" means.

What does this Exclaimation mark before the dimension name means. Can anybody help me out on this? I believe there should be an element name at this place!!!!

Early response would be greatly appreciated.

Thanks in advance

[Duncan P]

It's not that easy to find in the documentation but an explanation is here http://publib.boulder.ibm.com/infocente ... lcome.html in the blurb about the dimension arguments to the DB function.

Basically the rule applies to one or more cells. When it is calculating the value of a particular cell then !DimensionName is a string containing the name of the element on that dimension for the cell being calculated.

It will repay you to read through the rules guide and the developer's guide from start to finish, trying it out as you go along. That is how I learnt.