Skip to Main Content

Reporting Schema

jflackFeb 27 2018 — edited Feb 28 2018

Is there a database diagram for the SDDM Reporting Repository?  I'm having trouble finding the relationships, and there don't seem to be many FKs defined.

My immediate problem is finding the intersection table between DMRS_ENTITIES and DMRS_MODEL_SUBVIEWS - I want to list the entities by subview.

But generally, it would help me to write some custom reports in SQL Developer, it I knew what tables to join.

This post has been answered by Philip Stoyanov-Oracle on Feb 28 2018
Jump to Answer
Comments
Post Details
Added on Feb 27 2018
1 comment
73 views