TM1 Forum

I did some Essbase not so long ago and I don't think you'll get to what exactly you are after with TM1. You can run a TI from within a COM (OLE) wrapper. Applix/Cognos/IBM don't provide it (only a nasty, low level API) but there are routines floating around to do this (we have one). But there is no ...

Good that Martin E could help. But I would be looking for this kind of inner technical detail to be supplied by Cognos, either directly (if you are a direct client) or via your partner (if not). When you worked for a partner I'm sure that's what you would have said!
Were they no help?

Steve, did you get anything sensible from Cognos? This is a pretty crucial issue for the community and they had better come up with something.

I think this is on the right track (and is consistent with Scottw's comments) however I don't think it will work with microcubes which are ruled into a central cube. This is because the feeders would fire and cause the central cube to be invalidated. My belief is that a TI is required to transfer th...

Weighting is a possibility, but I would argue that it's rather inflexible.

Best way is a rule on the lines of: ['Count'] = n:abs(sign( ['Value'])); ['Average'] = ['Value'] \ ['Count']; #(Notice N on the count, to get it to add up, but not on the average, to get it to work at all levels) (Don't forget the feeders...) ['Value'] => ['Count'],['Average']; As you are finding, i...

In your place I would raise a formal SR for this. It is a very reasonable request, indeed crucial. If you do and you get something, try to get clearance to make it available here. There has been so much flying around about the locking model the community really needs something solid to get its teeth...

Steve, I'm away in the Middle East (Colin says hi). We were getting this at a UK client using Citrix. Cognos recommended some changes to the CFG and I applied them but I don't recall what they were and don't know how much they helped. When I'm back I'll find out. Let's meet for a much needed beer an...

I wish! It has been requested many times. At present, Asciioutput is the only tool you have. You can, of course, write several files out at once and put all the logic you like on them. But it's pretty *(&*&%^ primitive.

That's interesting (and I stand corrected). The risk, I suspect, is that if the objects/methods/properties you have unearthed are not 'official', then Applix/Cognos/IBM can change them when they please. And if they drop the feature altogether, I think that qualifies as 'changing them when they pleas...

I'll be interested to see if any forumers actually use Planning Manager in anger. However, what you are seeing is probably a result of how TM1 handles spreadsheets stored in application folders. When you create/update a spreadsheet into an application folder, it puts a timestamp on the name (NB the ...

I'd be interested what forumers thought about this.
http://forums.olapforums.com/viewtopic.php?f=5&t=637

http://www.olapreport.com/Comment_Bizdemise.htm
Haven't seen anything directly from MS, but the OLAP Report is probably right about this. And an Oracle salesman told a client of ours the other day that this was upcoming.

Guillaume, if you have done a report using 'Browse in Excel' you must be using the In Spreadsheet Browser. This is quite a venerable piece of code, and Cognos have said they plan to discontinue it. That said, it has its moments and I do use it myself from time to time. However I _never_ heard that i...

There's got to be a way of explaining this simply. Feeders are a notorious barrier for TM1 users climbing the learning curve - Stephen Waters suggests the climbing term 'overhang' as a term for a major barrier which puts people off. I suspect many of us are over the overhang, but we mustn't let it b...

I think (and hope) that server to server communication is going to come up the priority list as I heard a rumour of a pricing change which would step away from the per server cost in favour of a pure named user basis. Inter server comms has been a bee in my bonnet for quite a few years. Replication ...

Nice one. Cubelockoverride is in the list of reserved words but is _not_ (from a brief check) documented in the (9.1) help. Which version are using, and is it documented in that version? Update - found it in the 9.0 documentation. Think it disappeared when they tore up the locking model for 9.1+. Ho...

I don't believe this is available - wish it were.
I use rules in cell security cubes, driven by (normal) control cubes. I've read suggestions that cell security gives a performance hit but I think this is manageable if the rules therein are kept simple.

Scott, that's a very useful, considered response. I will admit hardly any of our clients use spreading so data input is quite granular, and we do encourage them to manage input via macros etc, or even macro generated flat files which are read in via TI. When I have time I will return to this area fo...

I'm glad we're so obviously making progress then. En contraire Monsieur Obson, ... admittedly the backend engine may have lost some pure raw speed (in a single user environment) but what of the gains in multi-user performance, x64, granular object locks, user interface (action buttons, active forms...