TM1 Forum

Hi, If you just want them to run sequentially, there is the synchronized function that can be added to your TI scripts. It has a lot less features than a queueing process, but it is a simple way to force multiple user run processes to run sequentially. https://www.ibm.com/docs/en/planning-analytics/...

I found this thread while looking at similar errors. In another location I was directed to the following IBM documentation that states they increased the logging of messages coming from ODBC drivers. https://www.ibm.com/docs/en/planning-analytics/2.0.0?topic=pa2d12-enhanced-sql-error-logging-in-tm1s...

I do use ODBC multi-threaded and have seen it work great and not so great. It really depends on how you are hitting the indexes on your target like was mentioned earlier. Do all the sub processes finish at the same time or do they finish in sequence with a large gap between? If you cut it to two thr...

Hi,
We had a user experience the same thing. We found out that if you resize the box, then the objects show up and you can select one before it goes blank again. So the work around is resizing the box after each selection. Did IBM indicate what the network issue was with the user?

We are also having this issue, but with a twist. It works using HTTP, but when we try to use HTTPS we get this error. One thing our tech recommened was turning on the logging on the client and see if that allows the process to start. C:\Users\<username>\AppData\Roaming\IBM\Cognos Performance Modeler...

A co-worker of mine came across an updated version of your document. Would you be willing to put it on the forum?

You are welcome.

In our case it was related to this tech note:
http://www-01.ibm.com/support/docview.w ... wg21446996

The AD server was saying that the name was invalid. We had to change the service to start with a domain account instead of local system.

Thanks,
ScottB

Hi,

Do you have a PMR? I think I have a similar issue and wanted to give my IBM tech the number.

Thanks,
ScottB

Would adding this work?

Cube B - Rules
['Budget', '2011', 'Input'] => DB('Cube B', !Version, !Year, !Period, ElComp('Dept', !Dept-Flat Structure, 1), !COA, !Measures);

This would cause the already fed values in Cube B to feed their parents.

Hi, Does anyone know the lifecycle of tm1s.log files for Sandboxes? Does a Commit or Submit in Planner/Contributor change them from tm1s.log to tm1s(date).log? Does it happen when a user logs out? What cleans out the log files? I have seen them disappear, but I do not know the cause. Thanks, ScottB

Check }CubeProperties to see if logging is set to YES for the cube. If not, the transactions are not sent to tm1s.log.

Thank you for this information.

I was on the phone with IBM and asked about hot fixes for 9.5.2. They said that Hotfix 2 is out and is recommended for all clients because of a data integrity issue.

They are now on hot fix 17 for TM1 9.5.1.
In hotfix 12, there is a fix for a bug where MDX views on dimensions with security were not working in TM1 web.
You need to set the following parameter in TM1s.cfg:
PersistSecurityFilteringOfDynamicSubsets=T

The technical name of your problem is slowly changing dimensions. When a user looks at the data they want to see the lookup values as they were at the time of the transaction. Here are some random thoughts: -- For changing hierarchies, have a seperate hierarchy for each partition. The lowest level e...