Connecting to Alternative TM1 Server

If you’re like most of our clients you’ll have both a production and non-production environment for Cognos Express or TM1. It is not real obvious though how you switch servers from, say Production to Development, or Development to Test etc. Well here’s how you can easily change your TM1 login to point to a development, test or production server. Open TM1 Architect or Perspectives If in Perspectives (the Excel add … Continue Reading

This entry was posted in Architect, Perspectives, TM1 Admin. Bookmark the permalink. | Leave a comment

ItemReject TM1 Function: Syntax and Use

Sometimes we want to put some text directly into the TM1 Message log to record why something is occurring in a TM1 Turbo Integrator process. This function will place the current record into the TM1 message log along side a custom message. ItemReject Syntax The syntax is simply ItemReject(ErrorString); where ErrorString is the message you want put in the TM1 Message log along side the record. Example and Usage of ItemReject … Continue Reading

This entry was posted in TI Functions and tagged message log. Bookmark the permalink. | Tagged message log | 1 Comment

IBM Planning Analytics Review

Last week on the Infocube website we reviewed IBM Planning Analytics, otherwise known as hosted TM1, or TM1 in the Cloud, or SaaS TM1.  We covered things like: What is it Using Perspectives and Guided Exploration with Planning Analytics Visualisations Uploading Data and Security Why would you use it Inclusion of Cognos BI Licencing for Existing TM1 Users Where to from here We think it is a pretty good blog … Continue Reading

This entry was posted in IBM Cognos TM1, Planning Analytics and tagged IBM Cognos TM1, Planning Analytics. Bookmark the permalink. | Tagged IBM Cognos TM1, Planning Analytics | Leave a comment

TM1 in the Cloud – Planning Analytics Review

Last week on the Infocube website we reviewed IBM Planning Analytics.  We covered things like: What is it Using Perspectives and Guided Exploration with Planning Analytics Visualisations Uploading Data and Security Why would you use it Inclusion of Cognos BI Licencing for Existing TM1 Users Where to from here We think it is a pretty good blog post and thought we should post a link to it here as well. … Continue Reading

This entry was posted in Planning Analytics and tagged Planning Analytics, TM1 Cloud. Bookmark the permalink. | Tagged Planning Analytics, TM1 Cloud | Leave a comment

ViewZeroOut TM1 Function: Syntax and Use

I came across this extremely simple method of just zapping the data from a view in a TM1 cube today, ViewZeroOut literally removes all data from a view. . Syntax The syntax is just ViewZeroOut ( cubename, viewname ); where cubename – is the name of the cube you want to remove data from, and viewname – is the name of the view Example sCube = ‘Assumption’; sView = ‘This Year’; … Continue Reading

This entry was posted in TI Functions, TM1 Admin. Bookmark the permalink. | Leave a comment

TM1 Stargate Views Explained

This is a fabulous article from our friends at Ironside in the US. The original article is available here. There are various approaches available to enhance the performance of your TM1 application. One such approach is to leverage Stargate Views. Stargate Views are different from traditional view objects and represent cached subsections of cubes that get created through user experience. As users browse cubes via the Cube Viewer or consume cube … Continue Reading

This entry was posted in Administration, Performance and tagged Stargate. Bookmark the permalink. | Tagged Stargate | Leave a comment

Ambiguous Element Name: TM1 Rule Error

I recently opened a rule and made a very minor change, then wend to save it and got a really odd error that had nothing to do with the changes I had made to the rule. The error said “Error: Element name ambiguous ‘Current Year’”. This seemed rather odd as had not made any changes that had anything to do with time. Then I remembered that I had added an … Continue Reading

This entry was posted in Errors, Rule Examples. Bookmark the permalink. | Leave a comment

TODAY TM1 Function: Syntax and Use

TODAY simply returns the current system date as a string in the form ‘yy-mm-dd’, or if you want, in the format ‘yyyy-mm-dd’. Syntax of TODAY The syntax is Today ( FourDigitYearFlag); where: FourDigitYearFlag – can be either omitted or 0 or 1, where omitted or 0 will return the 2 digit year and a 1 will return a 4 digit year. Example Assuming the current system date is 07 June … Continue Reading

This entry was posted in Rule Functions, TI Functions and tagged today. Bookmark the permalink. | Tagged today | Leave a comment

STR TM1 Function: Syntax and Use

STR is a TM1 function that converts a number to string. It is very similar to the Excel function “TEXT”, except you don’t need to specify the format of the output. If you are looking for the command to convert a string into a number, please see the Numbr function. Syntax of STR STR (number, length, decimal); where: number – the actual number you want to convert, length – the length of … Continue Reading

This entry was posted in Rule Functions, TI Functions. Bookmark the permalink. | Leave a comment

Email TI Process and Chore Results

Need to email your TM1 Admin upon a TI failure? TM1 models are usually updated from a third party data source. Sometimes those loads fail and TM1 does a great job in recording in its log files what caused the error.  What it doesn’t do out of the box is email the TM1 administrator of the failure. We have a standard method that involves having a process that executes a Windows … Continue Reading

This entry was posted in TM1 Administration. Bookmark the permalink. | Leave a comment