Category Archives: TM1 Admin
Here is a chance to win 1 of 5 fab ExploringTM1 t-shirts. Just tell us your top 3 tips for managing a TM1 environment and you’ll go in the draw!
Here is a collection of useful TM1 and Planning Analytics related URL’s. They include TM1Web, PAW, Ops Console, the Cognos Dispatcher and Gateway
Here is how to use TM1 Architect or Perspectives with both a new and old server environment, so with both older TM1 10.2.2 server and Planning Analytics.
TM1Web allows browser based access to TM1 with writeback capability. The TM1 Web URL is http://servername:port/tm1web/, where usually the port is 9510.
Have you ever had an inexplicable change to TM1 data? You know, when a user comes to you and says, John (in my case), the data in TM1 has changed since I looked at it last month? Well, if you have, here is the solution. And it is really easy!
Here we present a fully worked example of how to create element level security for an organisation that requires complete lockdown for entire branches of a dimension. It uses element level security down to the N level, applied via a TI.
TM1 and Excel can now share the same serial date system by the use of UseExcelSerialDate=T in your tm1s.cfg file. Here is the details on this development in Planning Analytics. This means that day number 1 is 1-Jan-1900 in both systems.
There are a few settings in Cognos BI that can dramatically improve performance in Cognos BI when using TM1 as a data source. The first of these is to stop Cognos from using the old Bluenose method of querying TM1 and force it to use the native TM1 engine. The next setting that we need to configure is the Java Virtual Machine, or JVM. Wikipedia defines a Java Virtual Machine … Continue Reading
Cognos Business Intelligence and TM1 now work well together, however performance can be dramatically improved by changing the out of the box settings. These tuning changes are not difficult and can significantly enhance both the speed and usability of both tools. How can BI and TM1 be Integrated When used together we can use Framework Manager to prepare data from a database before it is loaded into TM1, we can … Continue Reading
There are a few settings in Cognos BI that can dramatically improve performance in Cognos BI when using TM1 as a data source. The first of these is to stop Cognos from using the old Bluenose method of querying TM1 and force it to use the native TM1 engine. Bluenose is the default and it is extremely slow on large queries. Anecdotally it appears to want TM1 to return the … Continue Reading