TM1 Forum

We tried the persistent feeders feature and found it reduced our server load time from 35 mins to about 5 mins but that it frequently failed for obscure reasons. When it failed we would be back to waiting 35 mins (whilst dodging flak from users) to get it up and running again. The reasons for the f...

I have a couple scenarios where I think sandboxing might be helpful within our model and some future projects. I did not see a general sandbox discussion so I thought I would throw it out there. What are the thoughts from people that have used sandboxes in a large scale environment. My main concerns...

I tried to use it just for the object migration options that are available through it and even those were very unpredictable. Moving a dimension that was not attached to anything triggered a recalc of all the feeders in one environment, but in an identical model it did not. We had other weird instan...

This type of stuff is generally put out in the new features guide with every release. The specific one about parallel interaction is mentioned in the third link down in the doc. http://pic.dhe.ibm.com/infocenter/ctm1/v10r1m0/index.jsp?topic=%2Fcom.ibm.swg.ba.cognos.tm1_nfg.10.1.1.doc%2Fc_whats_new_t...

The service was written in .NET (with the classic API for the login part). If starting from scratch it may be easier to use the .NET API since it is out of the box more friendly and since all it does is login the limitations of the .NET API don't come into play. You can probably do it through batch ...

For unplanned outages we have the following. A custom service written on the server the does a scheduled check of if the service is running? If yes it tries to login to TM1. If the service is down or the application cannot login to the server then it automates the use of the APP_OFFLINE.htm (google ...

You would only want to use .NET API for certain function. If you are planning to use it entirely to replace the whole interface, then it really defeat the purpose of using TM1. You would be better off coding the interface and use a normal back end database eg MS SQL server. I have been through the ...

Hello Hugh, With "No!" resounding in your ears, I think it would be churlish of me to do the same, even though we know each other well. If you permit me to be assumptive, we did once tackle a similar issue together where users needed some permission to the underlying files, but it was a T...

It is a long shot but does there happen to be a TM1S.LOG in your log directory during start up? There is generally a gap between the cube/feeder loading and the server is ready but even on much larger models this is nowhere near 12 minutes. Once thing that might be helpful is to turn up your logging...

I have tried decomposing the DLL for the C API looking for a function that mimics the Disconnect Clients option under Server Manager window of Architect, but I have not found anything that looks similar. There are functions that seem API specific to kill the current user session in the API, but not ...

Thanks for your help.Currently i don't have any rules defined on the cube.Any other way around or i have to have write a rule? That depends on how this data is used or updated. You could write a process that populates that measure with the same abs logic. But this would not be realtime. If your ent...

As far as an automated method of killing a user, we have created a windows service using the C/C++ API that will consume TM1TOP and kill locking processes after a threshold is met. We did it as a windows service because the the processes starts a TM1TOP instance and there are times that locks will p...

From their docs they were specifically designed to work with the hard break between data and security. This was their reaction to SOX segregation (though not a very good one) and giving you a way to break it does not fit with the controls they were putting in place. *** I have not tested any of this...

I cannot give you a definitive answer but what seemed to work for us was turning off the check boxes on the application pool to recycle the worker processes. This seemed to take care of some of these issues, but I still think there is some strange session mixing that is going on within IIS. We have ...

I was wondering if anyone has come up with any other work arounds then the delete and reupload that IBM has on this one? We only have this happening on 2 sheets in our environment but one of them is one I am actively prototyping with our users. I dont know of any real differences between this sheet ...

To be fair Yeon I think relational drill-through is a fairly uncommonly used feature in TM1Web so probably no one has been too fussed about it. But maybe if the output didn't look so shoddy then more people would be enthusiastic about using it? This is the only reason my old employer used Executive...

I have used Whitej_d's method with a little variation to get around the refiring issue. I use an accompanying string feeder. For the numerical values on the input template I have a corresponding DBSS that will populate a string value if the numeric is not zero or blank it out if the numeric entry is...

you as developer can provide form where user will set up new hierarchy and then run process that will build new hierarchy (additional to base or replacing base). this solution is not nice for complicated hierarchy. We have used this method with pretty decent results. A simple form with the new hier...

That rings a bell from a very old post, but I can't find it at the moment. There is a variable held in TM1 that defines the maximum number of rows currently available in Excel. I think the only way to update that variable is to re-install TM1 on top of the new Excel. That would be interesting to me...

Some of the members that work for the consulting companies can chime in on specifics, but my former company engaged a consultant that tailored the class to our specific needs. This turned into a much more helpful experience then the stock training since it was customized and also not stuck to a spec...