Discussions
Categories
- 381.9K All Categories
- 2.1K Data
- 207 Big Data Appliance
- 1.9K Data Science
- 447.5K Databases
- 220.8K General Database Discussions
- 3.7K Java and JavaScript in the Database
- 24 Multilingual Engine
- 516 MySQL Community Space
- 464 NoSQL Database
- 7.8K Oracle Database Express Edition (XE)
- 2.9K ORDS, SODA & JSON in the Database
- 472 SQLcl
- 3.9K SQL Developer Data Modeler
- 186K SQL & PL/SQL
- 20.9K SQL Developer
- 292.7K Development
- 7 Developer Projects
- 125 Programming Languages
- 289.4K Development Tools
- 95 DevOps
- 3K QA/Testing
- 645.5K Java
- 23 Java Learning Subscription
- 36.9K Database Connectivity
- 150 Java Community Process
- 104 Java 25
- 22.1K Java APIs
- 137.8K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 16 Java Essentials
- 143 Java 8 Questions
- 85.9K Java Programming
- 79 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.2K Java SE
- 13.8K Java Security
- 197 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 243 LiveLabs
- 35 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.8K Other Languages
- 2.3K Chinese
- 166 Deutsche Oracle Community
- 1.2K Español
- 1.9K Japanese
- 225 Portuguese
Reporting Schema
jflack
Member Posts: 1,516 Bronze Trophy
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.
Tagged:
Best Answer
-
they are in "datamodeler\datamodeler\reports\Reporting Schema diagrams" directory of your DM installation - Diagrams.pdf for that case.
Philip
Answers
-
they are in "datamodeler\datamodeler\reports\Reporting Schema diagrams" directory of your DM installation - Diagrams.pdf for that case.
Philip
This discussion has been closed.