Hi all,
I have a requirement to create some data flow diagrams for a few models and have used Performance Modeler to do a reasonable job. I am able to get the cubes into the layout and track feeders and cube rules without a problem. I cannot however get the TI processes into the layout so I can't track the process links at all. I see the Model and application views and I can see all the TM1 objects in a tree view on the left hand margin.... but I can only drag cubes into the diagram layout, I can't drag TI's into this layout, without which the "Process Links" won't work as there are no objects to link to. I'm running PM from IE11. The server is 2008 R2 Enterprise. The TM1 version is 10.2 with fixpack 3.
Any feedback would be great.
In the meantime I'm looking at graphviz as an alternative.
Data Flow Diagram
-
- Posts: 141
- Joined: Wed Nov 14, 2012 10:37 am
- OLAP Product: TM1
- Version: 2.0
- Excel Version: Office 365
- jim wood
- Site Admin
- Posts: 3951
- Joined: Wed May 14, 2008 1:51 pm
- OLAP Product: TM1
- Version: PA 2.0.7
- Excel Version: Office 365
- Location: 37 East 18th Street New York
- Contact:
Re: Data Flow Diagram
After a pointer form a colleague I've started using http://www.draw.io
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
-
- Posts: 141
- Joined: Wed Nov 14, 2012 10:37 am
- OLAP Product: TM1
- Version: 2.0
- Excel Version: Office 365
Re: Data Flow Diagram
thanks Jim. I see it's like an online version of Visio (from what I can see) which is great - except I was actually after the linking logic that is provided by virtue of PM knowing which cubes are linked to other cubes via feeders, rules and TI's etc. This would need to be manually done which would consume a lot of my time. I was hoping for something that would interrogate the model and do the linking without me having to put in the time to read rules and TI's to make the same 'mind map'.jim wood wrote:After a pointer form a colleague I've started using http://www.draw.io
Appreciate the info though.
I'll post back here to see how much effort is involved in feeding the .rux and .pro files into the perl parser which then feeds into graphviz. The advantage being that the linking of all objects would be automatic and I can choose what objects to include in the final diagram.
Thanks again.
-
- Regular Participant
- Posts: 424
- Joined: Sat Mar 10, 2012 1:03 pm
- OLAP Product: IBM TM1, Planning Analytics, P
- Version: PAW 2.0.8
- Excel Version: 2019
Re: Data Flow Diagram
Hi JamiseBondi,I am not sure much it is useful to you,It is not a graphing tool per se ,But actually a Perl script. Please have a look at it,Graphing TM1 data flow:
http://www.bihints.com/graphing_tm1_data_flow Thanks.
http://www.bihints.com/graphing_tm1_data_flow Thanks.
"You Never Fail Until You Stop Trying......"
-
- Posts: 141
- Joined: Wed Nov 14, 2012 10:37 am
- OLAP Product: TM1
- Version: 2.0
- Excel Version: Office 365
Re: Data Flow Diagram
I BariAbdul,BariAbdul wrote:Hi JamiseBondi,I am not sure much it is useful to you,It is not a graphing tool per se ,But actually a Perl script. Please have a look at it,Graphing TM1 data flow:
http://www.bihints.com/graphing_tm1_data_flow Thanks.
I understand the 'solution' to be as follows:
Install perl and graphviz. Then you would open the perl script and point it to the data folder of the TM1 instance that you wanted to create a diagram for.... the perl script would then (using the .rux and .pro files contained in the location you pointed the perl script to) create the necessary files that graphviz uses to generate two files: flow.dot and flow.gif
The gif file can then be opened in any picture editor and is similar to the image shown in the URL you posted above.
Is this not correct? what am I missing?
Many thanks.
-
- Community Contributor
- Posts: 248
- Joined: Tue Nov 01, 2011 10:31 am
- OLAP Product: TM1
- Version: All
- Excel Version: All
- Location: Manchester
- Contact:
Re: Data Flow Diagram
That is correct, get's a bit unwieldy when you have a lot of objects I find though.
Keep meaning to have another look and get it to parse out details for a particular data source/ cube/ process but I've not used it for years
Find it quicker to search for "DB(" in Agent Ransack/ FileLocator Lite/Pro and manually draw/ input into Visio/ drawing tool of choice
Keep meaning to have another look and get it to parse out details for a particular data source/ cube/ process but I've not used it for years
Find it quicker to search for "DB(" in Agent Ransack/ FileLocator Lite/Pro and manually draw/ input into Visio/ drawing tool of choice
Re: Data Flow Diagram
Totally agree. The problem with automated documentation, while it may look great on the surface, all it does really is present to you what is already there, and quite often, easier to read by just looking at the scripts/rules. Having lines drawn from every cube to every cube doesn't provide much value.That is correct, get's a bit unwieldy when you have a lot of objects I find though.
What I would surmise most people are after is more about how things logically flow with respect to a particular segment of data/business process. For example, show how actuals flow into the system, which is rarely the same as forecast. Or show how headcount changes flow through the cubes and then impact the financial P&L reports.
If anyone can figure out how to generate that kind of documentation automagically, sign me up!
Ah well...back to Visio.
-
- Posts: 62
- Joined: Mon Aug 15, 2016 8:48 am
- OLAP Product: TM1 (Windows) & SSAS 2014 Ent.
- Version: 10.2.0 FP3
- Excel Version: Excel 2013
- Location: Hamburg, DE, EU
- Contact:
Re: Data Flow Diagram
The topic is a little older, but just to share another possible solution to this: I solved it for my own purposes using yED: https://www.yworks.com/products/yed
You can prepare a adjacence matrix in Excel, open this Excel file with the yED editor and point it to the matrix. It will build a .graphml-file from that. You have now inside the editor a feature called neighborhood, looks like this: yED neighborhood example. If you click on an item, the neighborhood vie shows the precessors and the successors.
Just make a matrix: then open it with the yED editor and import it as a adjacence matrix and determine the rough style of the graph Result? Watch the next post, as I could only pots max. 3 images per post, as it seems...
You can prepare a adjacence matrix in Excel, open this Excel file with the yED editor and point it to the matrix. It will build a .graphml-file from that. You have now inside the editor a feature called neighborhood, looks like this: yED neighborhood example. If you click on an item, the neighborhood vie shows the precessors and the successors.
Just make a matrix: then open it with the yED editor and import it as a adjacence matrix and determine the rough style of the graph Result? Watch the next post, as I could only pots max. 3 images per post, as it seems...
-----------------------------------
Best regards,
Stefan
Best regards,
Stefan
-
- Posts: 62
- Joined: Mon Aug 15, 2016 8:48 am
- OLAP Product: TM1 (Windows) & SSAS 2014 Ent.
- Version: 10.2.0 FP3
- Excel Version: Excel 2013
- Location: Hamburg, DE, EU
- Contact:
Re: Data Flow Diagram
Here it comes:
Obviously it's not a kind of automatic analysis of metadata, but as I document my own framework continously, it helps tremendous to indicate, which Processes are dependent from whose others. Before I change them and create side effects for later...
(graph below neighbourhood above: In the graph "proc2" was clicked, which leads to the extracted view above)Obviously it's not a kind of automatic analysis of metadata, but as I document my own framework continously, it helps tremendous to indicate, which Processes are dependent from whose others. Before I change them and create side effects for later...
-----------------------------------
Best regards,
Stefan
Best regards,
Stefan