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

String Rules

I went to create a rule to calculate some string rules today and I kept getting a rule error saying that I had an invalid expression. Thankfully the solution was pretty easy! Situation I have a cube where I have an element that indicates if a set of days are to be included in a forecast inventory calculation or not. I could have combined all of this into a complex rule, however … Continue Reading

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

Deriving an Element from an Alias in TM1

Today I needed to look up an element name from an alias. The solution involved combining the use of Dimix and DimNm. Problem The situation was that I have a System Settings cube which derives the date and subsequently the year, month and day from the date. The month is string and in the form “03”. I wanted to add an element that is also string that shows the month … Continue Reading

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

Refresh TM1 Contributor Approval Hierarchy

I was just updating the approval hierarchy on a TM1 Contributor model and could not see the changes through on the web app.  Odd, I thought. So I did some digging around and found that the solution to that specific problem is to re-save the Rights in Performance Modeller even if you have no rights in there in the first place.  Some what counter-intuitive I reckon! So the whole process … Continue Reading

This entry was posted in Performance Modeller, TM1 Admin, TM1 Administration. Bookmark the permalink. | Leave a comment

Migrating TM1 from Development to Production

TM1 migration isn’t the strongest point of this great tool. Pretty well all TM1 installations should have a Dev, Test and Production server or TM1 instance. This allows us to build and experiment in Dev, test our changes and then migrate what we want to Production – without breaking Production with an error during development! This will guide you through the important steps for migrating TM1 from development to production. … Continue Reading

This entry was posted in Administration, TM1 Admin, TM1 Administration and tagged Deployment, Migration. Bookmark the permalink. | Tagged Deployment, Migration | Leave a comment

DayNo TM1 Function: Use and Syntax

Yesterday I was doing some work on an inventory forecasting system.  I had Year, Month and Day dimensions and needed to bring through Actuals for all days up until yesterday. I have a System Settings cube with Current Day defined in it using a rule. To bring through the Actuals I created a rule that uses the DayNo function. Syntax of DayNo DAYNO(‘DateString’) So here if you insert a string in … Continue Reading

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

IF() TM1 Rule Function: Use and Syntax

IF() is a function that can be used to test if an expression is true so that you can then differentially execute a rule based on the outcome of the IF statement. It is able to be used in both Turbo Integrator processes and Rules, however this post is about the use of it in Rules only.  For TI based IF statements, please see this post. Syntax of IF() in Rules The syntax … Continue Reading

This entry was posted in Rule Functions. Bookmark the permalink. | 1 Comment