Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.
Chapter 5 · DatasourceASCIIHeaderRecords : It specifies the number of records to be skipped before processing the data source. Two additional variables to be aware of are: · OnMinorErrorDoItemSkip : This TI local variable instructs TI to skip to the next record when a minor error is encountered while processing a record. This variable is useful in scenarios where a single bad field/value in a record causes multiple minor errors. MinorErrorLogMax : This TI local variable defines the number of minor errors that will be written to the TM1ProcessError.log file during process · execution. If this variable is not defined in the process, the default number of minor errors written to the log file is 1000. 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 );