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
Documentation tool to doco rule and data flows
-
- 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
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
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
-
- 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
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 ...
-
- 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
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
Has anyone got a bit of code o pick up the attribute cubes as well?
Cheers
Shock