TM1 Object Auditor and Chore Schedule

[Gareth Soo]

Hi all, this is a follow up post about the TM1 auditor that I put together earlier. It identifies the relationships between cubes, dimension, processes and rules to help identify impacted and redundent objects as well as document your server.

I have added a front-end for multiple servers and integrated a chore scheduler to identify when they run and their parameters.

It takes about 5-10mins to run each of our servers, results may vary but let me know if anyone has any issues running it.

https://www.dropbox.com/s/2zybi4gf9ciu2 ... audit.xlsm

[ioscat]

is it possible to connect it to server that is not deployed in contributor?

[Gareth Soo]

I developed it for our TM1 enterprise system so i'm not sure if it works with contributor sorry. If it has a data directory with cub, dim, rux and pro files then it should work though.

[ioscat]

yep, we have the data folder, but we didn't find way to make it work. could you please provide any instruction steps?

[Gareth Soo]

Did you receive a VB error when you click 'Run'? You might be prompted to enable macros when you open the worksheet

Try these 5 steps:
1 - Save and open the worksheet in a location that has access to your server data directory
2 - Type in the server name as seen on server explorer in Column B (replace planning sample as it is an example)
3 - Type in the directory of the data folder in Column C including the network address if applicable and also include a \ at the end as VB gets confused otherwise
4 - Tick the audit reports you want to create and press 'Run'
5 - Spend 10 minutes to make a coffee and marvel at the report on your return

Let me know what error you receive if it still doesn't work

[gdbanks]

Hi Gareth,

I am getting the below error on the dimension and chore steps. But, the errors are random in that we only get them on some of the servers but not all.

Dimension:
Run time error 9: subscript out of range
strDimArray(j, i + 1) = dimension

Chores:
If StrCubesArray(i, 3, j) = "" Then

[Gareth Soo]

It could be that you have lots of cubes or cubes with lots of dimenisons. I've upped the limits so give the new version ago:

https://www.dropbox.com/s/2zybi4gf9ciu2 ... audit.xlsm

[jcr55]

I would like to try this out, but our web security blocks access to the dropbox site.
Can you email me the .xlsm file?
My email address is

Jeff.Rice@Genworth.com

Thanks in advance.

Jeff Rice
TM1 Administrator
Genworth Financial

[cramejia_09]

Hi Gareth, the file is no longer available. pls help

[lotsaram]

Are you aware of Pulse for TM1? It has very good features for model audit and traceability of what impacts what in a TM1 model.

Usual disclaimers and admission of being associated with the product.