Adding Custom Tables/Views to Data Sources

To add a custom table or view to a data source in order for it to be used in dashboards, the CMIC_BI_RUNTIME and CMIC_USER_DEFINED_VIEWS schemas must be granted a SELECT or READ privilege for that custom table or view, otherwise, dashboards that use the corresponding folder will not function or some BI functionality may be not available.

For example, to grant the CMIC_BI_RUNTIME and CMIC_USER_DEFINED_VIEWS schemas the SELECT privilege for a custom table/view, such as CUSTOM_SCHEMA.CUSTOM_TABLE, the following GRANT statement must be issued in the database:

grant SELECT on CUSTOM_SCHEMA.CUSTOM_TABLE to CMIC_BI_RUNTIME, CMIC_USER_DEFINED_VIEWS

NOTE: CMiC automatically grants SELECT privilege on all views and tables located in DA and CMIC_BI schemas during patch installations. In order to access tables/views from other schemas, users need to grant SELECT privilege or READ privilege on those tables/views to CMIC_BI_ RUNTIME and CMIC_USER_DEFINED_VIEWS schemas manually.

Steps for Adding a Custom Table/View to a Data Source

To add a custom table/view to a data source:

1. Grant the SELECT or READ privilege to CMIC_BI_RUNTIME and CMIC_USER_DEFINED_VIEWS schemas for the custom table/view, as described above.

2. Add the custom table/view to the data source by right-clicking on the data source and selecting “Edit Available Tables/Views” from the drop-down menu. For more details, please refer to Edit Available Tables/Views (Data Sources).

3. Add the custom view/table into the business area by right-clicking on the business area and selecting “Edit Business Area” from the drop-down menu. For more details, please refer to Edit Business Area (Business Areas, Folders).

NOTE: Custom tables/views and their columns must have basic Oracle names not enclosed in quotation marks.