Skip navigation.
spilling the beans

tracing TM1 references

users
| |

Homemade TM1 reports can get quite convoluted and users might get a hard time updating them as it is difficult to tell where some TM1 formulas are pointing to.
The excel formula auditing toolbar can be useful in such situations.

.right click next to the top bar to bring up the bars menu
.select auditing bar
auditing

.tracing arrows to highlight precedents
precedents
or dependents
dependents
example:
arrows

Quite useful to get the scope of a cube or dimension reference in a report or to see which elements a DBRW formula is made of.


Average rating
(0 votes)