TM1 Forum

Hi

We are using v10.1.1 FP1

Some of our processes update both main cube data with CellPutN and attributes with AttrPutS. We have found extremely slow run times - you can see the record counter going up 1 or 2 records at a time. The only solution so far appears to be add an IF text to check the current value of the Attribute and to only do the attrputs if this is different from the new value. However, in v9 this was unnecessary. Has anyone else encountered this issue?

Regards

Paul Simon

I haven't experienced anything like that. Do you have rules and feeders, either on the attributes cube itself, or other cubes based on the attribute values you are updating? It could be related to something related to that.

Three questions :-

1. Is there a rule defined on the attribute cube?
2. Is at least one of the attributes an alias?
3. Which exact version of v9 were you on?

We don't have this problem. Try to put values into attribute cubes and check the performance again?

Hi

It appears that the issue with the attrputs was a red-herring. With some more detailed investigation we have narrowed the problem down to the CellPutS. Unfortunately we are getting some very erratic results. In some cases restarting the server cures the problem in other cases it does not. The same code on the Dev box does not give the problem but on Prd it does even though the cube files were copied and the CFG is the same etc.

I will keep investigating and let you know. The problem has been referred to IBM.

Regards

Paul Simon