How can I access the data dictionary for my Oracle Service Cloud application?
Oracle Service Cloud
The data dictionary lists the database tables and fields within those tables. Accessing the data dictionary differs depending on which release of software your application is on.
The data dictionary is now included within the product and can be accessed from Analytics or from Database Administration: path: Configuration > Database > Data Dictionary. From Analytics it is shown on the report design center when you use the Design or Data Set views, and lists the available tables and fields from the database that can be used in custom reports.
When using the Data Dictionary you may find some fields or tables that do not show up in reports. From the Data Dictionary, some fields include the 'Analytics Usage' detail, as defined below, while others do not. To help illustrate this, please see Answer ID 9089: Some tables cannot be used in reports.
You may also find some fields that can only be used in the filters but not in the actual report or vice versa. The data dictionary will tell you how a field is used in reports in the Analytics Usage section, which will display in the column information section of the data dictionary if you click on the field you wish to examine. The following are some examples of Analytics Usage values you might see:
- All - This means that the field can be used anywhere in a report.
- Display - This means the field can be used in a display column.
- Exception - This means the field can be used in an exception.
- Filter – This means that the field can only be used in a filter of a report.
- No Search – This means that the fields can only be used in the data area.
- No Analytics Usage section – If there is no analytics usage section it means that this field cannot be used in a report at all.
For additional information, refer to the 'Viewing the data dictionary' section in online documentation for the version your site is currently running. To access Oracle Service Cloud manuals and documentation online, refer to the Documentation for Oracle Service Cloud Products.
Note: The full Data Dictionary is not available outside of the application. However, it is possible to copy/paste information from the Data Dictionary. This may be useful for tables you know will be of use to you to create your own abridged version of a data dictionary resource.