VBA TM1 Audit Tool

[iansdigby]

Attached is an (updated) Excel/VBA tool for analysing references to cubes in rules, processes and feeders. You need:
- local Windows Explorer access to your TM1 data folder
- Excel 2007 or greater (might work on 2003 but haven't tested it).

I find it useful for locating intercube feeders, processes that use views etc.
This version addresses a number of bugs, adds a few features and works faster.

[iansdigby]

Note that, because the tool works by analysing textstreams, it will not identify an intercube feeder where "=>" and "DB(" are on separate lines, e.g.

['BI_ExpenseCodes':{'160','165','167','170','178'},'Total PL','N','£']=>
DB('BI_ACC_PL', !BI_Cal_P&L, !BI_Version, 'Cut1', 'Proposed', 'EX' | !BI_ExpenseCodes, 'Indirect', 'N', '£');

I will try to find a solution for this if I get time amongst the thousand other things...

Ian