There is a chapter on Reporting in the Admin Guide. Have you generated the database views and are you looking at them from your reporting tool? When viewing the database objects, note that all generated views have the prefix V_. These views make it easier to get access to the data for each entity vs going directly against the DB.
If you find a need to go directly against the SD tables, you can generate a data dictionary (from pg 194 of the Admin Guide): System Settings ->Report Settings icon, Click the Generate Data Dictionary