Dimension Maintenance Methods

There are four ways to maintain a dimension within TM1:

  1. Backend Editor
  2. Dimension Worksheets
  3. TI Process
  4. 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
Quick
No Audit Trail
Formatting Capabilities
Possibly Needs to be on Public Drive
No/Little Maintenance
No/Little Consistency Checks
Easy
Change Controlled
Unfamiliar Structure
Scripted
Can Manage Attributes
Archived

Please let me know if I’ve missed anything. I’ll likely be posting Individual Tutorials on each of the Methods tonight.

If you like this post, please spread the love…

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.