A tool for database design without reporting functionalities would be worth nothing! You need reporting for auditing, quality control, sharing information, …
In Data Modeler you can generate reports either from open designs or from a Reporting Repository.
If you want to create a report based on open designs there are three possibilities:
- File | Reports
- File | Print Diagram
Depends on what you need which one is the best.
The reports can be generated into different formats:
- The format selections depends on the way of reporting and the templates used.
The Preferences you should look into:
A Reporting Repository can be any Oracle database. I recommend you create a new user in a database as the schema owner of the Reporting Repository. After you have created the user, edit the file datamodeler\datamodeler\reports\Reporting_Schema_Permissions.sql and run it in the repository to grant privileged needed. The first time you export a design to the reporting repository, the reporting schema structure is created automatically (log in as the schema owner). In datamodeler\datamodeler\reports\Reporting Schema diagrams, you can find the descriptions of the reporting repository structures.
To export to the Reporting Repository select File | Export | To Reporting Schema. You can also maintain the reporsitory (drop/enable/disable indexes, delete designs from repository) from File | Export | To Reporting Schema and add/remove glossaries to/from the Reporting Repository.
To run reports from the Reporting Repository select File | Reports or connect to the database and use SQL.
Is it Possible to query ‘Source Target mapping information’ used in Transformation tasks in Process model from reporting repository , is it something supported?
I would look at Advanced Search first but looks like it does not support Object Types of a transformation yet. I will make some enquieries and come back to this.
That information is not imported to the Reporting Repository so in this version the answer is no, it is not supported. Hopefully the version after 4.1 will include this feature… The developers for Data Modeler are aware of your request.
Hi Heli, just bought your book and enjoying it very much! Thanks!
I decided to start modeling processes using the DFDs in Modeler, and was very disappointed to find that I can’t report on them. Am I missing something? It just doesn’t make sense to have this module and to be able to present/review and report/document the processes. Again, maybe I am missing something.
Hi! First of all thank you for buying the book and I am so happy you like it! Secondly to your question. In Browser right-click the DFD diagram and select Search. Then search whatever you are looking for. Then select the element type wanted in Filter. Now you see Report button is activated. Press that and you will have your report. BTW the entity report includes info about usage in data flows and processes.
Thank you very much! Just learned something new! However, I am not getting what I am looking for. In the target Information Store I have couple Entities listed and Attributes flowing through the process to the target Information Store. I am not getting a report to show these. I must be missing something again ….
Please describe more detailed what the report should look like. It seems this reporting functionality is not there so I must talk to the developers.
Hi Heli. I was wondering if you had a chance to look at my last question. Thank you for your feedback!
Hi. I am sorry for the delay but I am on vacation and try not to touch the computer… I will see it now but I cannot quarantee any fast response on replying on questions on this blog. Sorry.