TM1 Forum

HI,
i would apprciate for your help here.
I have build some calculations using TI process, and also i passed the parameters(in TI under Parameters TAB ,there are three paramaeters)
so once the Processes completes with error warnings and iam not entirley sure what is mean of. Could you please help me to understand why these are occuring. Listed below are just a few examples coming from log file.
and also i have taken the Maps TAB and under Cube TAB i have enabled the NO Action,Accumulate Values ..

Error;TM1ProcessError_20120119195548_manupulation_ascm.log;"stationary_elem_com","Abdabi","entrie","satity","central","EN","PAK",Data Source line (268) Error: Data procedure line (108): Cell type is consolidated
Error;TM1ProcessError_20120119195548_manupulation_ascm.log;Error: Data procedure line (108): error repeats 39 times
Error;TM1ProcessError_20120120121901_manupulation_ascm.log;"stationary.elem.com","Abdabi","entrie","satity","central","EN","PAK",Data Source line (268) Error: Data procedure line (108): Cell type is consolidated
Error;TM1ProcessError_20120120121901_manupulation_ascm.log;Error: Data procedure line (108): error repeats 39 times

You can't write to a consolidated value, try adding in a IFCELLISUPDATEABLE condition,

Sorry for short reply am in a hurry!

Edd

and/or look at how you are building your data source and restrict the processing to leaf cells only.

Edward Stuart wrote:You can't write to a consolidated value, try adding in a IFCELLISUPDATEABLE condition,

Sorry for short reply am in a hurry!

Edd

Hi,
Thanks for your valuable reply.
COuld you please explain little elabratly still i am trying to understand.Thanks in advance.

Error;TM1ProcessError_20120119195548_manupulation_ascm.log;"stationary_elem_com","Abdabi","entrie","satity","central","EN","PAK",Data Source line (268) Error: Data procedure line (108): Cell type is consolidated

One or more of the elements listed above is a Consolidation, which in the Subset Editor will look something like this;

∑ Consolidation
N Child
N Child

Go to the cube in question, and build a view which consists of all of the elements listed in the error log statement above. There you will see which element(s) is a consolidation - which you cannot write data into. You can only write data into an N or S type of element.

Then, rewrite your TI process so that before you load data (CellPutN), you check if the CellIsUpdateable. Read the documentation on how this TI function works, and then implement it.

If you can't rewrite it yourself, post the code from the Data tab in here and we will try and help.

Hi Christopher Kernahan,
Thanks lot for your reply.

the below is the condition that i am getting the error please help me how we should escape the consolidate cell before putting the numberi value.

IF( cal_costs <> 0);

CellPutN( Total_amount,cname,location,area,streat,vardu,'Total_hours',
department,GroupName,accounts,Type of cost,EPPI );
above condition i got it from the Data tab.and also the above the (108) line that we are getting the error in logs.

i am expecting the soon thanks lot in advance.

Christopher Kernahan wrote:

Error;TM1ProcessError_20120119195548_manupulation_ascm.log;"stationary_elem_com","Abdabi","entrie","satity","central","EN","PAK",Data Source line (268) Error: Data procedure line (108): Cell type is consolidated

One or more of the elements listed above is a Consolidation, which in the Subset Editor will look something like this;

∑ Consolidation
N Child
N Child

Go to the cube in question, and build a view which consists of all of the elements listed in the error log statement above. There you will see which element(s) is a consolidation - which you cannot write data into. You can only write data into an N or S type of element.

Then, rewrite your TI process so that before you load data (CellPutN), you check if the CellIsUpdateable. Read the documentation on how this TI function works, and then implement it.

If you can't rewrite it yourself, post the code from the Data tab in here and we will try and help.

mincharug.shulft wrote:please help me how we should escape the consolidate cell before putting the numberi value

Chris has already pointed you in the right direction. You need to use the CellIsUpdateable TI function with an IF clause.

Hi,
i have written the script like that ....kindly please help me whether correct or thanks in adavance to all gemtle mans

IF(cal_costs <> 0);

ActiveCell=CellIsUpdateable(measured_cube,location,area,streat,vardu,'Total_hours',
department,GroupName,accounts,Type of cost,EPPI );

IF( ActiveCell = 1);

CellPutN(Total_amount,location,area,streat,vardu,'Total_hours',
department,GroupName,accounts,Type of cost,EPPI );
ENDIF;
ENDIF;

Hi mincharug,

the idea ist correct, unfotunately i cannot check the syntax.

The logic is correct, but the variable "Type of cost" you are using seems odd as it has spaces in the name. Are you sure you have a variable with this name in your TI? There might also be a typo in the "streat" variable's name.

Most of all, have you made the effort to actually run this and check if it works?

You also miss cube reference in CellPutN.
In CellIsUpdateable you refer to the measured_cube cube, so you should also have:

CellPutN(Total_amount,measured_cube,location,area,streat,vardu,'Total_hours',
department,GroupName,accounts,Type of cost,EPPI );

I assume the Total_amount variable is numeric type.

Hi All,

its really mindblowing replies i got it and i chaged all and its working fine
incase of any issues i wil get back to you.

handsup to olap formum