TM1 Forum

This should work too:

Being able to use temporary views and subsets as source is a good fix.
Graphs in TM1Web are still buggy though..

Any fans of the Performance Modeler transfer in/transfer out functions? Do you have experiences to share? From my experience they work well on very simple changes, but often crash or give non helpful errors when things get too complex, especially when TM1Applications is involved. This is why we refr...

Is the port number that is specified in tm1s.cfg also open in the firewall?

Does the instance show when you fire up Architect on the server itself? In that case, the problem may be in the firewall configuration between the server and your PC.

We use a mix of standard pieces of code that we use as a base for any new model and building code on the go. While reinventing the wheel might not be the best idea, sometimes it is better to build the wheel that you need in a specific situation instead of using a full and overblown generic wheel as ...

I frequently use this, as in the following: This makes for easy variable setting, requiring less lines of code.

Makes sense, you have my upvote!

The key solution is to not use the TI command ODBCOUPUT, but write the output to a csv file instead using ASCIIOUTPUT. This way you ensure that all data is being exported from TM1. Now read the generated csv file to the database and keep track of any errors on the DB-side. In addition, this will giv...

Another option would be to create all subsets in the second dimension based on each element in your first dimension. By using a picklist cube you are now able to use the subset in the second dimension based on your selection in the first dimension. Although it may not be the best option (especially ...

Based on my reply in this thread here is the same post again, ready to be moved to the appropriate forum. For some more elaborate and dynamic find/replace functions in TI, I was forced to do some cool stuff a while ago: regular expressions . While not being exactly regular expressions as per definit...

For some more elaborate and dynamic find/replace functions in TI, I was forced to do some cool stuff a while ago: regular expressions . While not being exactly regular expressions as per definition, they offer a lot of flexibility and have become my golden hammer in many situations. It works like th...

Is anyone using that operationally? I recall that my initial tests of it "did not end well", but I can't recall the specifics. We use it from time to time to move stuff over from development to accept, or from accept to production. Main advantage is that no restart of the target instance ...

I am confused. We are using Cognos BI (10.2.2) with TM1. Is this the same thing? Did they just rename Cognos BI to Cognos Analytics and give it a new version number? IBM needs to stop renaming their products all the time. I am having a hard time keeping track of what is what. :| No, this is an enti...

Try adding it to your trusted sites

As far as I know the only option you have is to manually adjust the JavaScript files that render the web. By removing the options from the necessary arrays, the export options will no longer show.
I once managed to do so in a test-environment, but decided to not roll this forward to production.

Are you sure there is no 64-bit version of Excel installed? Cognos Express does not like 64-bit, only 32-bit is accepted.

Modify the query in such a way that there is a 'WHERE 1 = ?pRun?'.
Store the process with parameter pRun with 0 as default value. Upon executing the process set the pRun to 1 in order to correctly execute the query.

This is stored in the file tm1p.ini.
Locate the file via %appdata%/Applix/TM1/

Close Architect.
In this file change (or add) the line:
Language = EN
Start Architect.

There are multiple ways to get this information. Either way, the data should come from the date last modified attribute of the files in the }Externals folder in your TM1Data folder. You can get this information by: - Manually checking the files in the }External folder and see if any files have been ...