TM1 Forum

Morning all! I'm getting this message in the message log at the end of a sequence of data load TIs. TM1.Comm.SSL SSL read error Error: 5 The TI process has previously been working correctly but it now seems to be behaving oddly. Obviously I'm going to take a hard look at the TI but has anyone seen t...

Mike L, isn't What I really want is some control flow scripting statements at the chore level, instead of just a primitive sequence of processes, but I am not holding my breath. available to you via the ExecuteProcess command? This also passes the error code back to the calling process which gives y...

First of all Ultimately the full TM1 documentation should be turned into a wiki. I talked to some Applix managers about that but they didn't really appreciate the idea claiming docs must be accurate, ROFL, I would say wiki docs are likely to be more accurate.... and I sitckyed this, which I'm pretty...

Alain. I'm no MDX expert so I can't offer you any direct advice. A couple of things you can do though. 1. Make sure you raise it with Cognos support so they can fix the issue in future releases. 2. Post your MDX in case one of the experts can suggest a more efficient approach. Were you on 64 bit 844...

Sounds like you already have an event that handles the hide and unhide event. How about in the VBA When the row is hidden cell.value=0 'i.e. remove the DBRW from the cell When the row is unhidden copy formula from another section onto the recently unhidden stuff..'Put the DBRw back Provided the rela...

Not sure, I think if you have to produce the summary cube you are going to be calculating the same data anyway so in theory there should not be much difference. Actually this doesn't really hold since if you retrieveing a high level value and then changing the data in the cube then the high level va...

Blimey! Whats worked for me instead of looping through subsets looking for a particular set of elelements is to set up MDX subsets based on a particular set of conditions that I'm looking for. If I can't get to the exact element I need then I can least produce a much shorter subset to loop through. ...

Rodrigo, It's difficult to give general advice on conditional feeders. They need to be considered on a case by case basis. It's possible to make the performance of your system worse using conditional feeders, especially if you have re-evaluate conditional feeder flag on. Perhaps if you post your rul...

Any progress on this Jim?
If you having a 'mare with stability then your best bet is to downgrade to the latest 9.0 before they "improved" the object locking....
Cheers,

Also just to be really anal about the if test in the security rules. You don't need it at all since you can't override the security permissions of the admin user group. :ugeek: That said it would be interesting to understand how TM1 works once the rule is compiled... Is there any difference between ...

Another good tip here is to add some VBA to the close / deactivate events of the work book that set the load flag to false. This avoids data being sent when the workbook is first opened and calculation is set to automatic.

Sorry for posting on old posts, my first time on for a while..
Cheers,

A complete guess, did you try Shell "perfmon",0 ?