We recommend the use of the QUBEdocs solution to review the data flow within models. QUBEdocs provides an interactive solution visually show how data flows though the solution. Visit the QUBEdocs website to find out more: http://www.qubedocs.com/
In order to trace data in TM1, a cube view should be created in the Server Explorer.
This can be done by knowing the cube and element names involved.
The next step in tracing is to find the 'lowest level'.
This can be done by selecting the lowest (leaf) level of each dimension.
If you need to select multiple leaf elements this can be done by aligning them on the rows or columns of the view.
How to identify if you are at the lowest level?
Right-Click on a cell and select 'Edit Status'
Results will be:
1. Cell is not editable: Element '???' is Consolidated.
This indicates that you are NOT at the lowest level.
2. Cell is editable
This is a cell with white background. This indicates that the cell can have data entered directly into it. This may be done via either a process, or by a user input form.
3. Cell is not editable: Cell is Rule-derived.
This indicates that the cell is derived by a TM1 rule. You can trace the rule by right-clicking and selecting "Trace Calculation..."
4. Cell is not editable: No write access to element '*'.
This indicates that one of the elements used to define this cell is currently locked.