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
|
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.