TM1 Forum

should work.

IF 3 will solve the issue.

many thanks Gabor.

regards
Michael

Found the issue.

If you copy a value in, the cursor will jump some cells to the right. Is this cell a hidden cell, the error message is triggert.

Dear all, I get an error message in TM1 Web 10.2 (latest fixpack) if I click in an input cell or try to copy a value in. --- "nodeType" is null or not an object --- I have to use Internet Explorer 8 maybe thats the cause. It happens only in some of the cells on the websheet. Its an ordinar...

It should be a double Expand. The inner one to get the name and the outer one to get the value.

RDP = remote desktop connection

There is a Excel 4 macro function called "DBPROPORTIONALSPREAD(Number;String;String;....)".

maybe you can try this one.

David Usherwood wrote: Also....
Why would you _not_ want calculated values to be cached?!?! What would the point of easy updates if all calculations took ages, every time?

In a planning system every time you change data - the cache becomes invalid. Sometimes (many CPU cores) it can be faster to calculate every time.

We have the same situation. were is a new parameter: InfiniteThresholdForSingleCellStorage. The idea is to turn off the cache so reads and writes can happen at the same time. I can not test it, because we are still using 9.1 SP3 but it should work with TM1 9.0 SP3 U9, 9.4.1 FP3 and 9.5. Hotfix 4 for...

hi dan, try something like this: ['dimTier':'Non Tier Item', 'dimCSRPeriod':'07 CTD'] = N: IF(DB('cbmCSRWBS', !dimProject, !dimCSRWBS, '07', !dimYear) = 0, ['dimTier':'Non Cost Centre Item', 'dimCSRPeriod':'07 CTD'], IF(ATTRS('dimCSRWBS', !dimCSRWBS, 'Dummy') @= 'True' , DB('CubeName', ELPAR('dimCSR...

I did something in the past. I checked the number of cubes on the server. If I got an answer the server is still up. I had to do the check asynchronous (ActiveX.exe is your friend), because if the server is hanging you are not able to react. This is my check: vhCubeCount = TM1ObjectListCountGet(hPoo...