Ever needed to create a text file from a data source and you have no tools available to interrogate it? We are doing a cloud Planning Analytics project for a
There are a couple of elements that must be established to make the secure gateway work. There are server side and local side requirements. This post deals with what has to
Yesterday I needed to export some data from TM1 for loading into SQL Server. I know I can connect directly and publish from TM1 to SQL Server, but I just
To delete an attribute in TM1 or Cognos Express during the execution of a Turbo Integrator process we use the AttrDelete function. Syntax of AttrDelete The syntax is: DimName – is the name of the
Sometimes we want to create a new attribute in TM1 dynamically during the execution of a TI process. This function allows us to do that and create either a string,
I was asked the other day how to concatenate some information in TM1. Joining two text fields is really easy! Just use the pipe ( ” | ” ) between two
We sometimes recommend using a Cognos BI Package and BI report as the source for TM1. We usually do this when we have both TM1 and BI deployed at a
Sometimes we want to put some custom text directly into the TM1 Message log to record why something is occurring in a TM1 Turbo Integrator process. With ItemReject, you can
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
The TODAY function returns today’s date in a text string and allows you to define the year as either 2 or 4 characters.
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
Syntax and Use of the DayNo function in TM1 Turbo Integrator processes and Rules in TM1. This converts a text date to a serial number.
If you are looking for the RIGHT function in TM1, you’ll find that it doesn’t actually exist! Instead it is a combination of SUBST and LONG functions. This post give’s a step-by-step explanation into how to achieve the same result in TM1.
The LONG function in TM1 returns the length of a string as a value. It is similar to the LEN functions available in both Excel and SQL Server. Syntax of
The LEFT function from Excel does not exist in TM1. We need to use SUBST instead. Where you have a formula in Excel in A2 that is = LEFT (
CubeClearData: TM1 and Planning Analytics command for clearing all data from a TM1 cube without deleting and recreating the cube. It does not give the flexibility of deleting the data from only a slice of a cube.
ATTRN stands for ATTRibute Number, in other words it returns the contents of a string attribute from an element in a dimension in TM1. Note this is not AttrGetN! That function
Another piece of the puzzle of setting up an AsciiOutput is to define a view and then export that view. Why would you do this? Well, you can either go through
When we are exporting from TM1 to a text file there is a set of functions we can set that modify the way the AsciiOutput process behaves. These include: Suppress Rule Calculated values or
This is one of a set of functions that define the behaviour of a Turbo Integrator AsciiOutput. The ViewColumnSuppressZeroesSet function sets the output to either extract zero values values or not,
© Copyright Exploring TM1 Pty Ltd | All rights reserved. | Privacy Policy | ABN: 98 122 867 976
© Copyright Exploring TM1 Pty Ltd | All rights reserved. | Privacy Policy | ABN: 98 122 867 976
