Tag Archives: Development

Modifying a Dimension – Backend Editor

There are a few ways to update a dimension within TM1, the first is the simplest and most commonly used. To update a Dimension using the Dimension Editor: Right Click on the Dimension Click “Edit Dimension Structure”   Right Click any where and click “Insert Element”   Type the name of the element Check the settings are as expected (Element Type)   Click ‘Add’ to insert the Element into the … Continue Reading

Turbo Integrator Troubleshooting

Turbo Integrator Overview Turbo Integrator (TI) Processes are scripts that execute within the TM1 server to perform data manipulation. Most TI Processes use a data source which is processed line by line. There are 7 major sections to a Process: Data source Settings Data source Variables Parameters Prolog Metadata Data Epilog Data source Settings Here you can change the file/query that is being imported. It’s important when sourcing data from … Continue Reading

TM1 Security (Pre 9.4)

Overview Security within TM1 is limited to assigning a client to a group then a group to one or many levels and selections of objects. The levels of objects are: Tier 1: Cubes Applications Processes Chores Tier 2 – Dimensions Tier 3 – Elements Tier 4 – Cube Cells/Intersections of Elements The level based security is reciprocated up the tiers meaning in example that if the ‘Final Budget’ Element within … Continue Reading

Clear Cube Process

It is good practice to create and destroy a view for clearing rather then leaving a large clear view sitting under the cube waiting for a user to click on it. The code below creates a view and assigns subsets to that view, zero’s the view out then destroys the view and subsets.