Analytics Publisher Report Configuration

This section describes the steps required to configure Oracle Utilities Meter Data Management and Oracle Analytics Publisher to support a reporting solution that uses Oracle Analytics Publisher.

This release of Oracle Utilities Market Settlements Management has a separate bundle with a sample Analytics Publisher 11g report.

Unzip Oracle Utilities Meter Data Management Report Files

1. Unzip the MDM-V2.5.0.0.0-Reports.zip file from the installation media into an <TEMPDIR> directory. We'll refer to this directory as the reports extract folder.

2. For both UNIX and Windows platforms, a sub-directory named AnalyticsPublisher11g is created. The contents of the installation directory are identical for both platforms.

Note: By default, the reports provided are read only. You will need to reset the permissions on the files before making any changes, for example, to configure the default data source.

Publish the Sample Reports in Oracle Analytics Publisher Enterprise

The installation media contains sample reports provided with the system. The report files are in the reports extract folder under < TEMPDIR >\AnalyticsPublisher11g\reportFiles.

Install Oracle Analytics Publisher Enterprise. This section assumes that you have already installed Oracle Analytics Publisher Enterprise.

To configure the Analytics Publisher reports:

1. Create a folder named D2_VEEEME in the <Analytics_Repository_Path>\Reports folder.

2. Copy D2_VEEEME.xdo and D2_VEEEME.xdm folders to <Analytics_Repository_Path>\Reports\D2_VEEEME folder.

Note: To check the location of the <Analytics_Repository_Path>, login to the Analytics console as an Administrator and navigate to Administration > Server Configuration. If the repository type is File System, the path will be seen in the Catalog region. If the repository type is not File System you cannot load the sample reports.

3. Login as Administrator to Analytics Publisher server.

4. Navigate to the Administration tab.

a. In the JDBC Connection section under Data Sources, add a new data source using Add Data Source.

b. Create a new Data Source named D2 201 Dev with connection details pointing to the D2 201 Dev database.

c. Test Connection to make sure the Database connection is successful and save changes using Apply.

Note: Make sure the Data Source Name (D2 201 Dev) is created with the same name else the reports won't show up.

5. Navigate to the Catalog Tab.

a. Click New > Report from the drop-down list. Select Use Existing Data Model to create new reports using existing data model and then select Data Model from the Shared folders Catalog.

For example: ./Shared Folders/D2_VEEEME/D2_VEEEME.xdm).

b. Click Next and select Use Report Editor. Click Finish.

c. Select My Folder and save report name as D2_VEEEME.

6. Navigate to the Catalog tab, select D2_VEEEME Report under My folders and click Open.

Once the report is open, click Actions and Export Data as XML. Save it.

7. Navigate to the Catalog tab, select My Folders, click Edit Report (D2_VEEEME) and then click Data Model D2_VEEEME. Under Attachment, click Upload Sample data, browse to the xml file saved (in step 6) and upload it. Click Save and return.

8. Click Add New Layout. Under Upload or Generate Layout, click Upload and enter the Layout Name as “D2_VEEEME.rtf”.

Browse Template File to <BI_Repository_Path>\Reports\D2_VEEEME\D2_VEEEME.xdo folder and select D2_VEEEME.rtf file. In the Type field, select RTF template and Locale as English and click Upload.

9. Click View Report to see the reports.

Note: Follow the same steps to configure other reports except step 4.