TM1 Forum

Thumbs up to Steve... Moved the block of code from 2/3 the way down the file to the very top. Interestingly, all the code that had been above it was written by QueBit. So it would seem that somewhere in there, their code nullifies the ability to have separate N- & C- level calcs. Appreciate the ...

Thanks Martin. I also neglected to mention earlier that up until a few weeks ago, the file was taking only a few seconds to process. When it started to take longer, we were sometimes getting disconnected from the server while Excel seemingly went into radio silence. Now, we haven't been getting the ...

Found and changed the setting. Made no difference. Wasn't sold that it would, given that the test cube successfully handles the different N- & C- level formulae.

BTW, when you trace the calc, it indeed appears that it is looking to sum the subsidiaries as opposed to multiplying the 3 terms.

We have a KPI that has to be weighted both by ownership & time -- both intra- & inter-month. In excel, it's relatively straightforward to calculate using sumproduct, but without that at our disposal we decided we'd better test the calc it in it's own cube. BUT...after getting it worked out, ...

Here's what happens when we save a particular cube's rules file, about 500 lines long... 1) You receive the standard "Rule [cube name] already exists in server [server name]. Overwrite?" dialog. (Seemingly nothing unusual;) Click OK... 2) Excel goes out into space. If you click on the wind...