Your relational models can get big. Bigger than the human mind can easily consume. So instead of generating a report of 2,500 objects, you might want to break down your model to smaller chunks, AKA SubViews.
So let’s open the reports, which you’ll find on the main File menu.
First, we don’t want the main diagram in the report, that’ll give us EVERYTHING. I just want the subview diagram.
So after un-checking ‘include main diagram,’ we need to go look at the ‘Objects’ page.
Now we can define a reporting configuration that defines which objects we want included.
With our configuration saved and now available, we can go back and select it from the Objects panel.
And Our Report!
Note I generated this using 4.2.0.17 of SQL Developer. Also note I noticed there’s a bug where the Subview Diagram links in the navigation bar to the left don’t work. Thankfully the object links work for the data dictionary bits, and you can just scroll down to the diagram.
If we had included the main diagram (remember when we unchecked that box?), our report would have two diagrams instead of just the one here for the SubView.
6 Comments
Realicé paso a paso este tutorial, y aún asi en los diagramas se me generan todos los diagramas que tengo de todas las subvistas, quisiera saber como hacer que funcione bien en la version Oracle Data Modeler 19.2
Hi Jeff,
The SDDM reports are great and we would like to automate the production and embed them in our system documentation (Atlassian Confluence) by an overnight job. We have a large data warehouse model with 4000 tables and the number of reports/models is too high to make this as regular, manual task.
So – with the reporting schema as a source for the SDDM reports – could it be possible to call the pl/sql procedure PKG_OSDM_UTILS.Generate_Report to produce the standard table reports in batch (just setting up a scheduled job producing reports from the db server)?
I am using SQL Developer 4.0.0.13, the options are completely different. There is no place to uncheck “Include All Objects”. Can you please clarify how to do this for this version ?
Your software is quite out of date. You could upgrade faster than I could answer this question.
Ok, will do, but how to access it in the new version ?
In the new version, just read this blog post, I showed how do to it step by step.