To keep you from re-inventing the wheel I have attached the PDM Reverse Engineered Visio file that I have for EPDM 2010 SP2. If you need the 1 for 2009 I have that as well.
HI Mike -
In addition to what Hugh said, I have found the best method of creating an ER (entity relationship diagram aka: table map) is to use Visio (2003 SP3 or better) - it has a reverse engineer feature that will create the database diagram for you.)
Here are some links with more info:
p.s. Just so you know, you don't have to buy Crystal Reports to get reports. You can use SQL Server Business Intelligence Development Studio which comes free with SQL Server. (you need to install and configure Reporting Services)
Is there any chance you have one for 2012 SP1?
Hi Ryan -
Attached are the 2012 through 2014 ER Diagrams.
I know this is slightly off your topic, but im wondering what version of Syteline you use? We are still operating back on 6 and i am looking to see if anyone else has tried to combine these two systems.
This may sound like a dumb question, what can I get with reorts that I can't get with the normal searching in EPDM, with the SQL queries search?
Folks like to use reporting services to get reports via a webpage that are very specific to their needs.
Some folks want aging reports of files pending approval, others want overall project statistics, etc.
The plus side is that you can get a report with one button click and it can contain nice graphics, calculations and etc. (see image).
I see there are "collapse" buttons and tabs. Is this in the template? Any code or out of the box?
What is the end filetype?
The ability to collapse is part of the report setup. This is all included with SQL Server Business Intelligence Development Studio Reporting Services.
The tool (which is included with SQL Server) allows users to save reports in multiple formats including, PDF, Excel, Word and others.
I suggest you learn about Reporting Services via the Microsoft website - here is a link to a video:
Also, there are numerous videos on YouTube...
I use the same philosophy for business intelligence from #epdm. Leadership loves it...and they are also the stakeholders who appreciate knowing there is a return on their investment. Real-time status of the project so they can focus their resources more accurately and deliberately. And it all comes directly from live data from within #epdm.
Great approach Joy.
Below is my approach to creating real-time project status directly from data card info in #epdm so leadership can focus their resources more accurately and deliberately.
These charts start from the #epdm data card, goes to report server and the viewer drills down from there. See the images below that proceed in order from 1, 2, 3, & 4.
Your image number one reminds me of what I recently just saw.... http://epdmblackbelt.blogspot.com/2012/04/adding-workflow-images-to-data-cards.html
I am also trying to give workflow information right on the data card. The data card seems like a logical place for folks to look at information pertaining to the current road map for a document. It looks as if you click on project status in this data card and it shows an image to the right of where the document is in its process. Is that correct?
No, the button takes the viewer to the report server. The datacard workflow image is automatically updated as the files transition through the workflow and these are what I refer to as a user's roadmap. Always tells the user which roads are available for them to take from where they are so they don't feel like they are flying blind.
This setup gives your users the ability to see where they are and what roads they can take and who is next.
NOTE: As a leader, one core philosophy is to always ensure communication with your teams. It is the number one reason for retention risk and turnover.
Also, on image #1, there is a "work instructions" tab. This is intended to give the user a reader's digest version of "here are the things you need to do while the file is in this state. Such as "1) create p/n folder in epdm 2) attach certs to the drawing with paste as reference 3) contact supply chain with preferred supplier 4) run tests with instrument xyz 5) etc, etc. etc."
This methodology is a quick way of reducing support but more importantly reducing tribal knowledge. If the work instruction is on the face of the data card, the user really has no excuse not to follow procedure. Especially in an ISO9001 or AS9100 environment. It pushes a lot of onus back to the user so they have skin in the game.
Hope this helps,
Got it Tim. Thanks for the clarification. Looks like I will be messing around with variable tab control.
Retrieving data ...