Page 1 of 1

TM1 Object Auditor and Chore Schedule

Posted: Fri Feb 22, 2013 1:37 am
by 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

Re: TM1 Object Auditor and Chore Schedule

Posted: Fri Feb 22, 2013 8:14 am
by ioscat
is it possible to connect it to server that is not deployed in contributor?

Re: TM1 Object Auditor and Chore Schedule

Posted: Sun Feb 24, 2013 9:49 pm
by 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.

Re: TM1 Object Auditor and Chore Schedule

Posted: Mon Feb 25, 2013 7:29 am
by ioscat
yep, we have the data folder, but we didn't find way to make it work. could you please provide any instruction steps?

Re: TM1 Object Auditor and Chore Schedule

Posted: Mon Feb 25, 2013 10:36 pm
by 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

Re: TM1 Object Auditor and Chore Schedule

Posted: Tue Mar 19, 2013 8:11 pm
by 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

Re: TM1 Object Auditor and Chore Schedule

Posted: Wed Mar 20, 2013 3:20 am
by 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

Re: TM1 Object Auditor and Chore Schedule

Posted: Fri May 24, 2013 2:16 pm
by 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

Re: TM1 Object Auditor and Chore Schedule

Posted: Wed Jul 22, 2015 3:16 am
by cramejia_09
Hi Gareth, the file is no longer available. pls help

Re: TM1 Object Auditor and Chore Schedule

Posted: Thu Jul 23, 2015 7:20 am
by 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.