TM1 Forum

hi kangkc, For item 1, if you want the DBRW formulas to persist when you type data in them: 1. Goto the C:\Users\<userID>\AppData\Local\Cognos\Office Connection directory and open up the CognosOfficeReportingSettings.xml file 2. Change the line "<setting name="AllowFormulaWriteBack">F...

Hello, I'm currently in the process of creating a pretty large dimension (approx 1.9 million elements). I'm sourcing the dimension from an Oracle database (using an Oracle 11g 32 bit client). The behavoir occuring is a larger than normal (in my opinion) swell in memory as the recordset iterated over...

Hi Ardi, Have you considered that maybe your processes are both updating a shared control cube? I once tried to write some processes that would run in parallel and came into locking issue. The issue ended up being that I was disabling cube logging (in different cubes) in both processes. Because both...

Hello, We've encountered an issue and are experiencing some strange behavior with how Tm1 looks to be resolving directories on the server. Let me provide some details: This particular situation appears to arise when we perform a SaveDataAll while having a large amount of users in the system/trying t...

I agree, I would think it's probably the transaction log being a decent size and getting reloaded at startup.

Hello, We've recently experienced some very strange intermittant login ability when using Cognos 10/CAM Security to loging into TM1 9.5.2. Basically, sometimes we are able to login without issue (using Perspective in Citrix or RDP onto the server) as well as TM1Web (accessed through Tm1Web login pag...

Hello, I’ve been experiencing some strangebehavior with the Tm1 configuration parameter AllowReadOnlyChore. We have a group of users that are setup to perform administrative tasks on behalf of the development team. These tasks include being able to run a handful of TI processes as well as turn chore...

I have seen this scenario, albiet very rare (twice over 1.75 years) were this occured. As you mentioned the transaction appears in the transaction log, however was not reflected in the cube viewer. Never quite got to the bottom of the issue, however a reboot "fixed" the problem when the in...

Hi, I too have faced a similiar issue as well (after months of running without issue). Additionally, while this affects batch file execution I've come to find it also(this being an educated guess) has to do with how TM1 (and/or the server) is resolving directories. What also seems weird it that once...

Hi AmbPin, In looking at your post I have one suggestion regarding the way you are approaching your asychronus processing. Now, I'm on 9.5.1 and this very well may no longer be an issue in 9.5.2 however I thought it was worth mentioning. Specifically, I'm refereing this section in your Data tab: nIn...

Hi Steve, They were data records. When you said you wrote your own replication, from a technical perspective could you provide a little insight into how/what exactly you mean? We've been running in a high volume production environment for about a year now. This is the first time we've experienced th...

Matt, I agree with your assement. Opening a case is more of an exercise in futility.

Hello, We recently had some odd behavoir during a sync between two instances. Basically, a sync process ran to move 4 records and only 3 came across. We are on 9.5.1 and opened a ticket with IBM about it as well. I was just curious to see if anyone else had experienced something similiar. Here are t...

Hi, Have you had success using the EnableBulkLoad call? I'm currently using 9.5.1 and if I recall correctly if it's executed while a view is running or a chore is running it ended up hanging our instance. I certainly didn't test it very throughly and it was quite some time ago, so I could very well ...

Hi lotsaram, With regard to your thoughts on IT management, as you would guess, I completely agree with you. However, this is the hand that was dealt and it is what it is. I'm most certainly not going change anything and it's something we need to live around. With that said, this goes back to my mai...

Tomok, I don't believe you correct with regard to the "Commit" and WRITES and READS. We've been watching TM1Top closely for months and while the "Commits" occur at the conclusion of a WRITE, they also most certainly occur at the end of a READ query. I think Duncan P's hypothesis ...

Hello, As I would imagine many of you know, when a query is completing referencing cells previously not cached, TM1 "commits" these cells at the conclusion of the query (what is displayed if you are watching TM1Top). During which TM1 becomes single threaded, or in other words, no one can d...

Thanks Jim. I hadn't thought of that and that a good idea. However, client infastructure doesn't allow me to connect to application metadata databases/tables......

Hi, Currently in our environment we use Cognos for authentication within TM1. Up until recently, all user creation, authentication and user-to-group assignement was handled automatically by Cognos and TM1 interacting with each other. This also automatically handled user/client metadata population, s...

Hi, I recently received an error when one of my TI processes tried to update a security cube without the "Security Access" set. This led me to updating the process and the it worked as expected. One thing I did note, is that upon updating this setting the actual timestamp on the server for...