TM1 Forum

Hi,

just encountered the same error message and the solution was to remove conditional formatting from the worksheet.
Seems like conditional formatting is different in Excel 2007 & 2010 and doesn't play well with TM1 9.5.2 where these versions are not officially supported.

Cheers,
Dan

Alan, as always, you're right.
Changing from numeric to string elements fixed the issue.

Thanks,
Dan

Hi, I want to parametrise a query. I have a cube stating the years which looks like this: (Admin_Timescale cube) | dummy --------------+------- Current Year | 2010 Next Year | 2011 So, I want to use the cell Current Year here to determine which year should be used in another cube for calculation. Ho...

Hi rkaif,

I did it your way and I am very happy with the result.
I just wanted to elaborate further as kielmc asked for it and to explain lotsaram why his approach would not suit the process in this case.

Many thanks for the help to all of you.

\dan

So, how can I use the Repeat or equal spread from within A TI process then? Background is I am supposed to spread data equally in an empty cube. Just using CellPutProportionalSpread on an emty cube produces 191 errors, as Alan explained in his post. So my idea is to set all cells to a certain value ...

I need to spread amounts equally over all detail items, that's why I populate all cells with the same value before running CellPutProportionalSpread on it.
Coming from Cognos Planning, that's how one would do that, is there a better way in TM1 I didn't think of?

Zero suppression is disabled. But with a Matrix like this: Jan Feb Mar Article 1 100 0 0 Article 2 5 -1 0 Doing CellPutN(1, 'myCube', 'Month', 'Article); results in Jan Feb Mar Article 1 1 0 0 Article 2 1 1 0 but I want it to be Jan Feb Mar Article 1 1 1 1 Article 2 1 1 1

Hi, I try to set all cells of a cube to the value of 1 using CellPutN in a TI process. However, only cells already having values <> 0 get the value 1 set, Zero value cells stay untouched. How can I positively fill every detail cell of a cube with a value, whether the cell is already filled or empty?...