Analytics Publisher
Oracle Utilities Analytics Visualization is included in the cloud service subscription, available via a separate URL for each environment.
Analytics Publisher is available and included in the service as a reporting/query tool only.
Note: Analytics Publisher and Oracle Utilities Analytics Visualization extract and display data from the primary database only.
SQL Developer Web is also available and included in the service for querying the database (see SQL Developer Web in the Oracle Utilities Cloud Services Implementation Guide for more information).
Data extraction is supported via the Generalized Data Extract and Specialized Data Extract functionality, and/or DataConnect (CCS & MSCS only) may be a starting point for extraction of data for a BI/reporting tool such as Cognos.
Analytics Publisher can only access the primary database that is provisioned with the associated cloud service (such as CCS, MSCS, WACS, BCS, and so on). External data sources (such as xml data models, and so on) are currently NOT supported.
Analytics Publisher, as part of your cloud service, is not intended to be used directly as a bill/letter print system, however, it can be used to create reports based on extracted data. Billing/letter data can be extracted from Customer Cloud Service, Customer Care and Billing Cloud Service, and Billing Cloud Service via batch processing with target output files to be stored in Cloud Object Storage. The output file can then be uploaded into Analytics Publisher via an API for bill/letter data reporting. Once the report is generated within the Analytics Publisher database, it can be downloaded via the Analytics Publisher API and moved to Cloud Object Storage for further use.
The following diagram outlines this process:
Diagram outlining process of exporting bill data to Oracle Utilities Analytics for reporting.