Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

TM1 TurboIntergrator review > Using TurboIntegrator Variables

Using TurboIntegrator Variables

Using TurboIntegrator Variables To the point, an example of using these variables would be to read the input file name and the location of that file from a TM1 cube defined for this purpose. An information cube may be defined with two dimensions—application name and application measure. These two dimensions can be used to define a data point in a cube for specific applications to store and retrieve specific information, such as in the following example. Therefore, a TI process would read a file name to be loaded and the location of that file to be loaded: datasourcePath = CellGetS(NameOfInformationCubeName, MeasureNameForCategoryMeasureNameForFilePathName ); dataFileName = CellGetS( InformationCubeName, MeasureNameForCategory, MeasureNameForFileName) ; Additionally, the process may also read a location to write exceptions or errors that may occur during the processing: exceptionFilePath = CellGetS( systemVariableCubeName, systemVariableCategory , systemVariableLogsFileName ) ; Then, we can build our exception variable: exceptionFileName = exceptionFilePath | 'my process name' |_Exceptions.txt'; Of course, it is always a good practice to make sure that exception files are cleaned up before this process begins. So, in the process' prolog we code: # --- Delete the exception file for this run so that it may be created fresh ASCIIDelete(exceptionFileName); Finally, we use some of the previously mentioned process variables to actually set up our data source (and in this example we are using an ASCII text file as a data source): # --- set the datasource info for this process DatasourceNameForServer = datasourcePath | dataFileName; DataSourceType = 'CHARACTERDELIMITED'; DatasourceASCIIDelimiter = ','; Using the above technique, a process can run without any changes required in any TM1 environment of instance, assuming of course that the same cube is defined in all environments and is loaded with the appropriate file names, directory paths, and locations.

  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint