Approach to write documentation

Post Reply
wypwong
Posts: 22
Joined: Tue Aug 13, 2013 2:35 pm
OLAP Product: TM1
Version: TM1 10.1
Excel Version: 2007

Approach to write documentation

Post by wypwong »

There is about 3 different instances in TM1, and they are all been written by different contractors who no longer worked for the company. All the instances are working fine, and they are maintained by new contractors, but there is not much documentation around. I just joined the company recently as a beginner, and like to understand them better.

What would be the best approach to understand those database, and the relationship between different cubes, processes and applications?

Is there any structural method to do that? apart from going though every single spreadsheets/applications, cubes and processes...

Thanks in advance.
Phyllis
tomok
MVP
Posts: 2832
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: Approach to write documentation

Post by tomok »

You are in a tough situation. Trying to document something someone else built is a difficult job. That's why getting documentation from your developer after the work is complete is absolutely critical. I've been working with TM1 for 20+ years and I still sometimes struggle when trying to figure out what someone else has done whenever I inherit a messed up model that has no documentation (about 80% of the time). This is not a task for beginners unless you have extreme amounts of fortitude.

That being said, there is no shortcut to figuring it out. Go through the dimensions, cubes, rules, and TIs, as well as talk to as many of the power users as you can and make copious notes. Good luck.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
declanr
MVP
Posts: 1815
Joined: Mon Dec 05, 2011 11:51 am
OLAP Product: Cognos TM1
Version: PA2.0 and most of the old ones
Excel Version: All of em
Location: Manchester, United Kingdom
Contact:

Re: Approach to write documentation

Post by declanr »

I always start with a flow chart. Put each cube on a page and then go through each process and rule 1 by 1 drawing an arrow between the cubes with a reference mark, then against that reference mark note the general concept of what data is moving etc.
Once your flow chart is fully built you still have a long way to go (detailing in-cube rules and metadata functions etc.) but I always find it to be a good reference point and a grounding to do the rest of the documentation.
Declan Rodger
nedcpatm1
Posts: 23
Joined: Mon Oct 08, 2012 3:39 pm
OLAP Product: TM1
Version: 10.1.1
Excel Version: 2010
Location: Central Minnesota, USA

Re: Approach to write documentation

Post by nedcpatm1 »

In addition to what other contributors recommended above...try using the Dataflow Diagram feature if you use 10.2 version.

http://pic.dhe.ibm.com/infocenter/ctm1/ ... mming.html
wypwong
Posts: 22
Joined: Tue Aug 13, 2013 2:35 pm
OLAP Product: TM1
Version: TM1 10.1
Excel Version: 2007

Re: Approach to write documentation

Post by wypwong »

Thanks all.. It sounds like I will have a lot of "fun" documenting them, anyway it will be good for me to understand those instances.

We are still on 10.1, not sure when we will upgrade to 10.2 yet though.
User avatar
Harvey
Community Contributor
Posts: 236
Joined: Mon Aug 04, 2008 4:43 am
OLAP Product: PA, TM1, CX, Palo
Version: TM1 8.3 onwards
Excel Version: 2003 onwards
Contact:

Re: Approach to write documentation

Post by Harvey »

There are various documentation generators for TM1 that might help you get a high level understanding before digging into the details.

I just started a new project and found generated documentation invaluable in getting my head around the cubes/dimensions/processes.

PM me if you want a few suggestions.
Take your TM1 experience to the next level - TM1Innovators.net
hyunjia
Posts: 64
Joined: Fri Jul 27, 2012 4:13 pm
OLAP Product: TM1
Version: 2010
Excel Version: Excel 2010

Re: Approach to write documentation

Post by hyunjia »

Hi ,

From my experience , it make no sense for me look at the data flow or documentation within the whole model . However , it proves very useful to generate a document targeting a specfic object , such as rule or processe .
wypwong
Posts: 22
Joined: Tue Aug 13, 2013 2:35 pm
OLAP Product: TM1
Version: TM1 10.1
Excel Version: 2007

Re: Approach to write documentation

Post by wypwong »

I think the flow chart will be useful to understand all the relationship between cubes and process.

Is there any approach that can speed up my learning curve? I guess I am kind of looking for a short cut, but I know it's impossible. I just want to hear from the experienced people and see how they approach it.

Thanks.
Phyllis
Post Reply