TM1 BI Interop Files: How to Deploy to Cognos Analytics
A complete guide to deploying and configuring the TM1 BI Interop files to Cognos, so that TM1 and Cognos can communicate properly.
What Folders to Use for TM1 Models
What folder structure should you use for a TM1 model? Here we go through a really simple structure and give you a bonus zip file with it all set up for you.
ConsolidatedAvg TM1 Function: How to Use, Example, and Syntax
ConsolidatedAvg is used to calculate the average of rolled up values at the consolidated level. Here it’s explained in detail with a worked rule example.
Resolving TM1 Maximum Login Attempts Exceeded
Here is how to resolve the TM1 error message “The maximum number of login attempts has been exceeded”. We cover it for both users and Admins.
How to Create Virtual Dimensions in TM1/Planning Analytics
Virtual Dimensions in TM1 and Planning Analytics allow you to use Attributes to create additional analytic capability. Here we explain how to create them with code examples.
Persistent Feeders in TM1 – Speed-Up Model Restarts
Persistent Feeders can dramatically decrease the time required to restart a TM1 model. Here is an explanation of what Persistent Feeders are and instructions on how to implement them in your TM1 model.
How to Set TM1 to use Cognos Security (CAM)
This is a comprehensive guide to configuring TM1 to use Cognos CAM security. It includes why you might connect Cognos security to TM1, TM1 environment changes and how to deploy and configure the BI Interop files to your BI application and gateway servers.
How to Use Excel Dates as Serial Dates in TM1
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.