Reports and Queries

Reports and queries can be run using Analytics Publisher, which is included with the cloud service deployment. Analytics Publisher deployment includes a JDBC data source configured with credentials that allow access to read-only synonyms in the production schema. Note that there are several output formats, and we have found that PDF performs best for larger reports.

In order to configure reports within cloud services via Analytics Publisher, implementations are required to configure the Reporting Options and relevant reporting Algorithms (refer to Application / Environment Access and URL Tokens for parameter values for base algorithms types).

Reporting options with default configuration includes the following:

• Reporting Server from App Server = @BI_PUBLISHER_ADMIN_INT@

• Reporting Engine User ID = <use the user name having Analytics Publisher role assigned>

• Reporting Engine Password = <use the password for above mentioned user>

• Reporting folder = ccs <default reporting folder in Analytics Publisher but implementations can change it, if needed.>

• Reporting Server from Browser= @BI_PUBLISHER_ADMIN@

Oracle Utilities cloud services also offer the option of using Oracle Database Actions and Oracle Utilities Analytics Visualization for reports and queries.