Documentation tool to doco rule and data flows

Post Reply
shockwave
Posts: 88
Joined: Mon Dec 15, 2008 10:45 am
OLAP Product: TM1
Version: 9.1.3
Excel Version: 2003 SP3

Documentation tool to doco rule and data flows

Post by shockwave »

Hi All,

Just wondering whether anyone has a tool that can document all my rules and dataflows one of my cubes I have recently built. I have a heap of rule lookups and wanted to nicely present it all in some sort of flow chart. Ideas that come to mine are visio but are there others that work well for specifically tm1?

Cheers

Shock
shockwave
Posts: 88
Joined: Mon Dec 15, 2008 10:45 am
OLAP Product: TM1
Version: 9.1.3
Excel Version: 2003 SP3

Re: Documentation tool to doco rule and data flows

Post by shockwave »

Hi All,

Searched and found this:

http://www.bihints.com/graphing_tm1_data_flow

Had a quick play with it. It aint that pretty but works well. Is there something more perty than this?

Cheers

Shock
lotsaram
MVP
Posts: 3703
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: Documentation tool to doco rule and data flows

Post by lotsaram »

I haven't ever played with this but it looks like it will work provided that it can pick out object names as literal strings. If the processes have parameterised data sources and target objects (which is likely for a mature well written TI project) then my guess is the quality and accuracy of the output is going to suffer ...
shockwave
Posts: 88
Joined: Mon Dec 15, 2008 10:45 am
OLAP Product: TM1
Version: 9.1.3
Excel Version: 2003 SP3

Re: Documentation tool to doco rule and data flows

Post by shockwave »

thanks for the reply lotsofram. Yeah, you need to specify in the script what your looking at. I couldn't change the script to pick up cube names with "}" em. I have a couple of attribute cubes that have rules hanging of em so I can perform some of my feeders mapping via this attiribute cubes. My vb skills only go so far. Get a the gist of what its trying to do, but actually writing the code to get to work is another thing.

Has anyone got a bit of code o pick up the attribute cubes as well?

Cheers

Shock
Post Reply