TM1 Forum

Brilliant thanks team, this saves a lot of code. superb jstrygner, really appreciate that. I scored with: vValue = StringToNumber(Expand ( '%' | vElement | '%' ));

Surely it must be possible.. it's all possible in TM1 right..?

The structure works - the only thing I struggle to do is get the Value for the relevant variable.. it's in the record, I just don't know how to pick it out..

Close but no cigar.. any ideas how to get the value in the source file? I had too many measures to define so decided to loop it.. it works except for what's highlighted below: iMeasure = DIMSIZ('ABM Measures'); i=1; While (i<=iMeasure); vElement = DIMNM('ABM Measures',i); vValue = ?the value matchin...

that would be reasonable wouldn't it? Your contributor (non admin) users should only be working with pre-set views/layout.

yeap - me also, conditional formatting with background fills etc works, conditional formatting number format e.g. number to % of total gives me that error.. TM1web log errors: 2012-02-21 19:51:21,323 [15] ERROR Applix.TM1.Web.WebControls.TM1WebUtils - <Cannot connect to TM1 ExcelServices : > not loc...

Cognos Insight has 32bit TM1 server embedded in it. The .cdd file contains the tm1 server files if any and some xml etc. for the app to render things for you. The .cdd's on analyticszone.com have been pre-loaded with TM1 models/accelerators. So when you use the Cognos Insight you are either using it...

Most definitely a rich TM1 contribution client. Benefits of centralised, managed data model under workflow with the capabilities of the client. Cognos Insight allows you to open the model in distributed mode which means the number crunching is done client side - fantastic on server load if you have ...

oh I wish I could use control objects in my applications e.g. control cube views of Time attributes, or Version security settings..

and how it jumps to the top of the rule page on save

Followed by auto-expanding of rule regions..

performance modeler rules editor, hit return and it automatically terminates it with ; when I have oh so much more to type.

Calculation tips

It installs under Local System (get the error above), changed it to run under my personal Admin account and it WORKS. Thanks for the tip MR W.

But my preference would be to run it under Local System..

ok who else is getting this error? I know of a few others.

Yes the rich client install after an install when all on one laptop.. But this way any client can pull down Cognos Insight/DESKTOP or Performance Modeller via the Java app server (a web browser) without IT having to install something. I would have thought the installer could do the un-install but no...

I guess prototyping gets easier/faster and can now involve Joe Analyst but no replacement for skills in a larger production environment. e.g. the documentation suggests you should check all feeders (comment out and re-write if need) and re-order rules appropriately. Interesting new concepts/rule syn...

Did you check (in task manager on the server) whether there's an Excel session hanging in the background, potentially locking the file? No rogue sessions running Did you try to open the file directly with Excel to see whether you get an error message if you try? Yes I can open the same file in exce...

TM1 10.1 problem with TM1web worksheets.. Anyone come across this? First I had to http://www-01.ibm.com/support/docview.wss?uid=swg21503942 Then I get this and I can assure you those files do exist and no other application is using them. Shouldn't the path be a fully qualified web path rather than C...

multi-node edit - yes
multi threaded/concurrent write back - yes
http://publib.boulder.ibm.com/infocente ... 28194.html

The all in one 68,000 source cube records x 3,500 target dim 1 elements x 50 target dim 2 elements = 11,900,000,000 proved to be too many permutations on a single thread. Pretty clearly it is not sensible to attempt the allocation across two or more alloc target dimensions at once, but to split it i...