TM1 Forum

hi! guys,
just wanna know how i will do this.

" ['sales']=if(trim(subst(trim(!version),6,9))@<>'submitted', ['adt']*['at']*['opdays'],STET); "

I need to write data into a measure sales element, this measure element is ruled. but i use STET. So data can be written then if the STET falls on a certain condition for that element. But somehow, this I dont know, my TI still prompts an error: 'Rule Applies to Cell'. but when I look at my cube, the cell is filled with data both from the TI and from the rule. how come it prompts an error then? thanks!



bunchukokoy

I use similar rules and TI processes, and get no error message. One thing to check is your TI data only filling the cells that fit the "Stet" criteria or is it also filling data that fits the ['adt']*['at']*['opdays'] criteria. This will produce the error message as the TI process cannot overright a rule populated cell. The error log should point you to the cell with the problem.

bunchukokoy wrote:hi! guys,
just wanna know how i will do this.

" ['sales']=if(trim(subst(trim(!version),6,9))@<>'submitted', ['adt']*['at']*['opdays'],STET); "

I need to write data into a measure sales element, this measure element is ruled. but i use STET. So data can be written then if the STET falls on a certain condition for that element. But somehow, this I dont know, my TI still prompts an error: 'Rule Applies to Cell'. but when I look at my cube, the cell is filled with data both from the TI and from the rule. how come it prompts an error then? thanks!
bunchukokoy

Your script is take from the cube rules, NOT TI, right?

Hence, if you want to insert data into those STET cells, you should use a TI function called CellIsUpdateable to check if data can be inserted into the cell. you should not even need to duplicate the above rule in TI since rule already applies to the area.