Issues Regarding TI CellPut

Post Reply
bmrizzuti
Posts: 9
Joined: Fri May 11, 2012 1:38 pm
OLAP Product: TM1
Version: 10.1
Excel Version: 2007

Issues Regarding TI CellPut

Post by bmrizzuti »

Hi everyone, again I'm asking for your help again so you can drive away our shadows with your light of wisdom.

When we have a user to select paramaters that are used in a TI to generate a Temporal Dinamic View of a cube, and we run a process using this dinamic view, and the process executes a Cellget - CellPut… if we do not go to the cell and write down at list one a number or something, the process does not write the output. However, if we do it the first time, then it works fine every time we run it. Also, If we run the same process with a diferent View that is not dinamically generated by parameters inputed by the user, the process run perfectly without needing to first write anything down.

So to summarize, the process needs to have at least some data in the cube before writting down stuff for the first time.

Do you know anything about this?

Thanks a lot ppl! hope you can help us on this time too!!

Have a nice day =)

Bruno
User avatar
rkaif
Community Contributor
Posts: 328
Joined: Fri Sep 05, 2008 6:58 pm
OLAP Product: IBM Cognos TM1
Version: 9.1 or later
Excel Version: 2003 or later

Re: Issues Regarding TI CellPut

Post by rkaif »

bmrizzuti wrote:When we have a user to select paramaters that are used in a TI to generate a Temporal Dinamic View of a cube, and we run a process using this dinamic view, and the process executes a Cellget - CellPut… if we do not go to the cell and write down at list one a number or something, the process does not write the output. However, if we do it the first time, then it works fine every time we run it. Also, If we run the same process with a diferent View that is not dinamically generated by parameters inputed by the user, the process run perfectly without needing to first write anything down.

So to summarize, the process needs to have at least some data in the cube before writting down stuff for the first time.
As you said you are doing some CellGet and CellPut within the TI. Are you doing the CellGet and CellPut on the same cube? If thats the case then if there is no data then you will not be able to put anything.

It would be helpful if you can share the TI code here.
Cheers!
Rizwan Kaif
Post Reply