TM1 Forum

Before I start hunting round the visio forums, thought I'd ask here incase someone has done this before.

Basically, I'm trying to create a Data Flow Diagram of a pretty big TM1 system in Visio. All I'm trying to map at the minute is the cube/rule dependencies. I've got the raw data in a spreadsheet in the following kind of format with the name of the cube in the first column followed by 14 columns detailing the other cubes in the models refereneced in the rules of the cube in column A -

Cube Rule 1 Rule 2 Rule x

Cube A Cube B
Cube B Cube A Cube C
Cube x


There's around 40 cubes with up to 14 other cubes referenced by some of them so a hell of a lot of data and I don't fancy trying to draw it all up manually.

So basically, anyone managed to do this previously or come across some freeware that does the same job? Been hunting round the net / visio help for a couple of hours now.

TIA

You may want to check out http://www.bihints.com/graphing_tm1_data_flow

garry cook wrote: Basically, I'm trying to create a Data Flow Diagram of a pretty big TM1 system in Visio.

TIA

Garry,
Dont you just go back to the original system design flowcharts and documentation and update with the minor changes applied since it was first implemented?

I was tempted to try and change the original but sadly, there was two slight issues with the theory of changing the initial flow diagrams -

1) It was drawn on a roll of lining paper using my kid's felt tip pens

2) The 372 change requests that were put into the system during the nine month build changed it ever so slightly too much to keep on top of with the ever looming deadlines

Apart from these two flaws in the otherwise flawless plan, it's what I would normally do