Tag Archives: Dimension

Using the DimensionCreate Function to Create a Dimension in TM1

To create a dimension in a TM1 model use the DimensionCreate function in Turbo Integrator processes. Combine with IF and DimensionExists.

This entry was posted in Dimensions, TI Functions and tagged Dimension, DimensionCreate, DimensionExists, IF, TI Process, Turbo Integrator. Bookmark the permalink. | Tagged Dimension, DimensionCreate, DimensionExists, IF, TI Process, Turbo Integrator | Leave a comment

Checking if a DimensionExists in a TM1 Model

To check if a dimension already exists in a TM1 model use the DimensionExists function in Turbo Integrator processes. Combine with IF and DimensionCreate.

This entry was posted in Dimensions, TI Functions and tagged Dimension, DimensionCreate, DimensionExists, IF, TI Process, Turbo Integrator. Bookmark the permalink. | Tagged Dimension, DimensionCreate, DimensionExists, IF, TI Process, Turbo Integrator | Leave a comment

“Joining” Text Files in a TM1 Turbo Integrator Process

How do you join text files in a TI when loading into TM1? In this post we discuss a method to emulate an SQL join in a TI where a csv or text file is the source for the Turbo Integrator process.

This entry was posted in Attributes, Data Connection, TI Data Sources, TI Processes and tagged Attribute, Dimension, TI Process, Turbo Integrator. Bookmark the permalink. | Tagged Attribute, Dimension, TI Process, Turbo Integrator | Leave a comment

Generating a Time Dimension in Performance Modeller

Almost all TM1/Cognos Express applications will require a time dimension, and creating a time dimension has never been easier, with Time Dimension Tool provided in performance modeller. Here are a few simple steps:

This entry was posted in Cognos Express, IBM Cognos TM1, Performance Modeller, TM1 10.1, Training Material and tagged Dimension, Dimension Editor, Hierarchies, IBM Cognos Express, IBM Cognos TM1, Performance Modeler. Bookmark the permalink. | Tagged Dimension, Dimension Editor, Hierarchies, IBM Cognos Express, IBM Cognos TM1, Performance Modeler | 1 Comment

Use Case: Removing the Structure from a Dimension

The Problem: Often when writing dimension update processes from a datasource which is updated automatically we use a standard procedure. Delete all the Elements Add Top Level Consolidations Cycle through (Metadata) Adding Elements and Element Components Cycle through (Data) Adding Aliases But in some cases we are only given a partial data feed.  For example we may be reporting off 3 years sales but the datasource for the Product dimension is broken … Continue Reading

This entry was posted in IBM Cognos TM1 and tagged Bedrock, Chores, Consolidation, Dimension, DIMENSIONELEMENTCOMPONENTDELETE, DIMNM, DIMSIZ, ELCOMPN, Element, IBM Cognos TM1, Maintenance, TI Process. Bookmark the permalink. | Tagged Bedrock, Chores, Consolidation, Dimension, DIMENSIONELEMENTCOMPONENTDELETE, DIMNM, DIMSIZ, ELCOMPN, Element, IBM Cognos TM1, Maintenance, TI Process | 3 Comments

Dimension Maintenance Methods

There are four ways to maintain a dimension within TM1: Backend Editor Dimension Worksheets TI Process TM1 API (Possibly via 3rd Party tools) Most consultants previously recommended using Dimension and Rule Worksheets prior to recent releases of TM1 (9.1 +) where the User Interface has been updated, presently there is no defined best practice and opinions are divided. Backend Dimension Editor Dimension Worksheets TI Process Pro Con Pro Con Pro Con … Continue Reading

This entry was posted in Cognos Express, IBM Cognos TM1 and tagged Dimension, Dimension Editor, Dimension Worksheet, TM1. Bookmark the permalink. | Tagged Dimension, Dimension Editor, Dimension Worksheet, TM1 | Leave a comment

Dimension Worksheets

Dimension Worksheets are a great way to manage medium sized dimensions and attributes/aliases. All Worksheets (Dimension and Rule) are held in the local data directory set in the ‘Options’ form found in Server Explorer under ‘File’.     To create a new Dimension via Dimension Worksheets

This entry was posted in Cognos Express, IBM Cognos TM1 and tagged Dimension, Dimension Worksheet, TM1Development. Bookmark the permalink. | Tagged Dimension, Dimension Worksheet, TM1Development | Leave a comment