TM1 Object Auditor and Chore Schedule

Ideas and tips for enhancing your TM1 application
Post Reply
Gareth Soo
Posts: 14
Joined: Fri Nov 23, 2012 3:25 am
OLAP Product: TM1
Version: 9.52
Excel Version: 07

TM1 Object Auditor and Chore Schedule

Post by Gareth Soo » Fri Feb 22, 2013 1:37 am

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

User avatar
ioscat
Regular Participant
Posts: 209
Joined: Tue Jul 10, 2012 8:26 am
OLAP Product: Contributor
Version: 9.5.2 10.1.1 10.2
Excel Version: 07+10+13
Contact:

Re: TM1 Object Auditor and Chore Schedule

Post by ioscat » Fri Feb 22, 2013 8:14 am

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

Gareth Soo
Posts: 14
Joined: Fri Nov 23, 2012 3:25 am
OLAP Product: TM1
Version: 9.52
Excel Version: 07

Re: TM1 Object Auditor and Chore Schedule

Post by Gareth Soo » Sun Feb 24, 2013 9:49 pm

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.

User avatar
ioscat
Regular Participant
Posts: 209
Joined: Tue Jul 10, 2012 8:26 am
OLAP Product: Contributor
Version: 9.5.2 10.1.1 10.2
Excel Version: 07+10+13
Contact:

Re: TM1 Object Auditor and Chore Schedule

Post by ioscat » Mon Feb 25, 2013 7:29 am

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
Posts: 14
Joined: Fri Nov 23, 2012 3:25 am
OLAP Product: TM1
Version: 9.52
Excel Version: 07

Re: TM1 Object Auditor and Chore Schedule

Post by Gareth Soo » Mon Feb 25, 2013 10:36 pm

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
Posts: 1
Joined: Tue Mar 19, 2013 5:02 pm
OLAP Product: TM1
Version: 10.1
Excel Version: 2010

Re: TM1 Object Auditor and Chore Schedule

Post by gdbanks » Tue Mar 19, 2013 8:11 pm

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
Posts: 14
Joined: Fri Nov 23, 2012 3:25 am
OLAP Product: TM1
Version: 9.52
Excel Version: 07

Re: TM1 Object Auditor and Chore Schedule

Post by Gareth Soo » Wed Mar 20, 2013 3:20 am

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
Posts: 44
Joined: Tue May 08, 2012 3:58 pm
OLAP Product: TM1
Version: 9.5.2 FP2
Excel Version: Excel 2007

Re: TM1 Object Auditor and Chore Schedule

Post by jcr55 » Fri May 24, 2013 2:16 pm

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
Posts: 7
Joined: Tue Oct 06, 2009 3:32 am
OLAP Product: IBM COGNOS TM1
Version: 9.4
Excel Version: 2007

Re: TM1 Object Auditor and Chore Schedule

Post by cramejia_09 » Wed Jul 22, 2015 3:16 am

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

lotsaram
MVP
Posts: 3006
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TM1, CX
Version: TM1 10.2.2 PA 2.0x
Excel Version: 2010 2013 365
Location: Switzerland

Re: TM1 Object Auditor and Chore Schedule

Post by lotsaram » Thu Jul 23, 2015 7:20 am

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.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.

Post Reply