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 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.
Need Help with Dimensions?
Like all things TM1, we get dimensions, and hierarchies, and elements, attributes and cubes. If you need any advice on any of these please get in touch. We’d be delighted to help.