Oracle Public Sector Revenue Management Analytics Quick Install Guide

Release 2.1.0.0

E55561-01

September 2014

Copyright © 2014, Oracle and/or its affiliates. All rights reserved.

Documentation build: 9.27.2014 16:54:40 [OTA_1411862080000]

This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.

The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.

If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, the following notice is applicable:

U.S. GOVERNMENT END USERS: Oracle programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, delivered to U.S. Government end users are "commercial computer software" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of the programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, shall be subject to license terms and license restrictions applicable to the programs. No other rights are granted to the U.S. Government.

This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group.

This software or hardware and documentation may provide access to or information on content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services.

Preface

The Oracle Public Sector Revenue Management Analytics Installation Guide describes the requirements and steps necessary to install Oracle Public Sector Revenue Management Analytics.

Audience

The Oracle Public Sector Revenue Management Analytics Installation Guide is intended for system administrators installing Oracle Public Sector Revenue Management Analytics. To use this document you should have:

- Experience installing and configuring application servers and other software

- Administrative privileges on the host where you are installing the software

Documentation and Related Resources

Oracle Public Sector Revenue Management Analytics Documentation Set

The Oracle Public Sector Revenue Management Analytics documentation set includes the following documents:

- Oracle Public Sector Revenue Management Analytics Release Notes

- Oracle Public Sector Revenue Management Analytics Quick Install Guide

- Oracle Public Sector Revenue Management Analytics Installation Guide

- Oracle Public Sector Revenue Management Analytics Implementation Guide

- Oracle Public Sector Revenue Management Analytics Reference Guides

- Introduction to Reference Materials

- ETL Reference Guide

- Data Mining Reference Guide

- Data Model Reference Guide

- Metrics Reference Guide

- Reporting Reference Guide

Note: All Reference Guides are restricted to Oracle Public Sector Revenue Management Analytics customers. In order to download these documents, please contact Oracle Support to request access to bug number 16876111.

Oracle Technology Network

Visit the Oracle Technology Network (OTN) to access demos, whitepapers, Oracle By Example (OBE) tutorials, updated Oracle documentation, and other collateral.

Registering on OTN

You must register online before using OTN, Registration is free and can be done at www.oracle.com/technetwork/index.html

Oracle Documentation on OTN

The Oracle Documentation site on OTN provides access to Oracle documentation. After you have a user name and password for OTN, you can go directly to the documentation section of the OTN Web site at http://www.oracle.com/technetwork/indexes/documentation/index.html.

Oracle Support

Oracle customers have access to electronic support through My Oracle Support.

Document Conventions

The following text conventions are used in this document:

Table 1. Documentation Conventions

Convention

Meaning

boldface

Boldface type indicates graphical user interface elements associated with an action, or terms defined in text or the glossary.

italic

Italic type indicates book titles, emphasis, or placeholder variables for which you supply particular values.

monospace

Monospace type indicates commands within a paragraph, URLs, code in examples, text that appears on the screen, or text that you enter.

Oracle Public Sector Revenue Management Analytics Installation Overview

This guide provides a high-level overview of the installation steps for Oracle Public Sector Revenue Management Analytics version 2.1.0.0.0 and selected additional software. For more information, see the Oracle Public Sector Revenue Management Analytics Installation Guide.

Contacting Oracle Support

Visit My Oracle Support (http://support.oracle.com) for the most recent service packs and patches for this release.

Media Pack Contents

The Oracle Public Sector Revenue Management Analytics Media Pack contains the following documents:

- Oracle Public Sector Revenue Management Analytics Release 2.1.0.0 Release Notes

- Oracle Public Sector Revenue Management Analytics Release 2.1.0.0 Quick Install Guide

- Oracle Public Sector Revenue Management Analytics Release 2.1.0.0 Installation Guide

- Oracle Public Sector Revenue Management Analytics Release 2.1.0.0 Implementation Guide

- Oracle Public Sector Revenue Management Analytics V2.1.0.0.0 Installation Package

Additional Software Requirements

The following software products are required to run Oracle Public Sector Revenue Management Analytics, but are not included in the media pack:

- Oracle Business Intelligence Enterprise Edition 11.1.1.7.0 (with 11.1.1.7.140114 bundle patch - MOS Patch#17886497).

- Oracle Data Integrator 11.1.1.7.0.

- Oracle Database Server Enterprise Edition 11.2.0.2+ or 12c (12.1.0.1.0).

You must separately license and install the software listed above. For more information on the content of each licensed Oracle Public Sector Revenue Management Analytics product, see the Licensing and Packaging Guide section of the Oracle Public Sector Revenue Management Analytics Release Notes.

Components for Oracle Public Sector Revenue Management Analytics

The Oracle Public Sector Revenue Management Analytics V2.1.0.0.0 Installation Package includes the following components:

- Oracle Data Integrator master repository

- Oracle Data Integrator work repository

- Foundation schema

- Star Schema

- Data Mining schema

- System data

- OBIEE RPD file

- OBIEE Web catalog

- OBIEE Writeback file

- Documentation

Architecture Overview

This section describes the recommended architecture of an Oracle Public Sector Revenue Management Analytics environment.

Tier 1: Browser-Based Client/Oracle Data Integrator Java-Based Client

Oracle Public Sector Revenue Management Analytics has a Web browser-based client and standalone Java client. The client that you choose depends on the user role or activity.

Business users can use a browser-based client to access Oracle Public Sector Revenue Management Analytics. Oracle Public Sector Revenue Management Analytics is deployed on Oracle Business Intelligence Enterprise Edition 11g, which supports various operating system and Web browser combinations.

Administrators and developers can use the browser-based client for managing Oracle Business Intelligence Enterprise Edition. To manage the Oracle Data Integrator, a standalone Java client is available in addition to the browser-based client.

Oracle Business Intelligence Enterprise Edition and Oracle Data Integrator support various operating systems and Java Development Kit combinations.

Note: For complete and up-to-date information on Oracle Business Intelligence Enterprise Edition 11g and Oracle Data Integrator 11g supported platforms, visit the Oracle Technology Network at http://www.oracle.com/technetwork/middleware/ias/downloads/fusion-certification-100350.html

Tier 2: Middle Tier/Application Server

Oracle Public Sector Revenue Management Analytics uses Oracle Data Integrator for EL-T and to build facts and dimensions. Please refer to Oracle Data Integrator 11g documentation for additional details.

Oracle Public Sector Revenue Management Analytics uses Oracle Business Intelligence Enterprise Edition for dashboards and reports. Please refer to Oracle Business Intelligence Enterprise Edition 11g documentation for additional details.

Tier 3: Database Server

Oracle Public Sector Revenue Management Analytics uses Oracle Database to store the Analytics Data. It supports Oracle Database Server Enterprise Edition 11gR2 (11.2.0.2).

Recommended Architecture for Oracle Public Sector Revenue Management Analytics

Per the Oracle Data Integrator recommendation, the ODI Master and Work repositories to be created in the same database as Oracle Public Sector Revenue Management Analytics warehouse.

The following diagram shows the recommended architecture for Oracle Public Sector Revenue Management Analytics:

Supported Platforms

This section describes the supported environments under which Oracle Public Sector Revenue Management Analytics operates, as well as information about hardware and software requirements.

Oracle Business Intelligence Enterprise Edition Requirements

Oracle Public Sector Revenue Management Analytics supports Oracle Business Intelligence Enterprise Edition version 11.1.1.7.0. It supports the operating systems on which Oracle Business Intelligence Enterprise Edition is certified.

For complete and up-to-date information on Oracle Business Intelligence Enterprise Edition 11g supported platforms, visit the Oracle Technology Network at http://www.oracle.com/technetwork/middleware/ias/downloads/fusion-certification-100350.html

Oracle Data Integrator Requirements

Oracle Public Sector Revenue Management Analytics supports Oracle Data Integrator 11.1.1.7.0. It supports the operating systems on which Oracle Data Integrator is certified.

For complete and up-to-date information on Oracle Data Integrator 11g supported platforms, visit the Oracle Technology Network at http://www.oracle.com/technetwork/middleware/ias/downloads/fusion-certification-100350.html

Oracle Database Requirements

Oracle Public Sector Revenue Management Analytics supports Oracle Database Server Enterprise Edition 11gR2 (11.2.0.2+) or 12c (12.1.0.1.0). It supports the operating systems on which Oracle Database is certified.

For complete and up-to-date information on Oracle Database11g supported platforms, visit the Oracle Support website at https://support.oracle.com/ and click the Certifications tab.

XBRL Extension

Oracle Public Sector Revenue Management Analytics leverages the XBRL Extension to the Oracle XML Database features to load, store, and query XBRL Taxonomies and instance documents into its data model.

The XBRL Extension must be installed if the implementation is to perform analysis of financial statement data submitted in XBRL format.

Download the following patch (18354629) from mysupport.oracle.com, and install the XBRL extension in the database:

- Patch 18354629: XBRL EXTENSION TO ORACLE XMLDB 12.1.0.1.0 RELEASE & 11.2.0.4.0 RELEASE

Oracle Public Sector Revenue Management Analytics Installer Requirements

The Oracle Public Sector Revenue Management Analytics installer will run on any platform which is certified to run Java Runtime Environment (JRE) 1.6 or above. The JRE 1.6 or above must be installed on the same machine where the installer will be running. The installer also requires Oracle Data Integrator 11.1.1.7.0 Software Development Kit (SDK), which must be installed on the same machine where installer will be running.

Hardware Requirements

This section describes minimum Oracle Public Sector Revenue Management Analytics hardware requirements.

Description

Requirements

Oracle Public Sector Revenue Management Analytics Installer

- 1 or more 2GHZ CPUs

- 1 GB of RAM

- 500 MB of disk space

Oracle Data Integrator Java-Based Client

- 1 or more 2GHZ CPUs

- 1 GB or RAM

- 300 MB of disk space

Oracle Data Integrator Agent

- 2 or more 2GHZ CPUs

- 4 GB of RAM

- 300 MB disk space

Oracle Business Intelligence EE

- 2 or more 2GHZ CPUs

- 4 GB of RAM

- 10 GB disk space

Oracle Database Enterprise Edition

- 2 or more 2GHZ CPUs

- 4 GB of RAM

- 10 GB disk space

See the Oracle Database Enterprise Edition, Oracle Data Integrator and OBIEE documentation for detailed hardware requirements.

Client Requirements

Oracle Public Sector Revenue Management Analytics administrators and developers must have either a Windows or Linux machine to run the Oracle Data Integrator Java client and a browser-based client for managing Oracle Business Intelligence Enterprise Edition environments. Though it is not mandatory to have Oracle client connectivity software for administrators and developers, Oracle 11g Client is the minimum required version to connect to the databases.

Business analysts accessing the Oracle Public Sector Revenue Management Analytics presentation layer must have a browser-based client. This is typically a Windows XP or higher machine with a supported Web browser. Please refer to the following table for details:

Client Type

Requirement

Oracle Public Sector Revenue Management Analytics Installer

Windows or Linux/Unix OS with JRE 1.6 or above and ODI 11.1.1.7.0 SDK installed

Oracle Data Integrator Java-based client

Refer to Oracle support site for complete list of supported platforms*

Oracle Data Integrator Meta Data Navigator

Refer to Oracle support site for complete list of supported platforms*

Oracle Business Intelligence Enterprise Edition

Refer to Oracle support site for complete list of supported platforms*

Oracle Client Software (optional)

Oracle 11g Client

* http://www.oracle.com/technetwork/middleware/ias/downloads/fusion-certification-100350.html

Support for Virtualization and Virtual Machines

Oracle Public Sector Revenue Management Analytics may be used with VMware virtualized environments consistent with the policy for other Oracle products as stated in Support Note 475484.1 available on My Oracle Support (http://support.oracle.com). For information on Oracle VM, see Support Notes 464756.1 and 464754.1 on My Oracle Support.

Supported Databases for Oracle Public Sector Revenue Management Analytics

Oracle Public Sector Revenue Management Analytics supports only Oracle Database Enterprise Edition 11.2.0.2+ or 12c (12.1.0.1.0). The database may be hosted on any platform on which it is certified. For more detail on Oracle Database Enterprise Edition, visit the Oracle Technology Network at http://www.oracle.com/technetwork/database/enterprise-edition/ downloads/index.html.

The supported database character set is AL32UTF8.

Supported Databases for Oracle Data Integrator Repositories

Oracle Public Sector Revenue Management Analytics supports ODI repositories on Oracle Database Enterprise Edition 11.2.0.2. For more detail on Oracle Data Integrator supported platforms, visit the Oracle Technology Network at http://www.oracle.com/technetwork/middleware/ias/downloads/fusion-certification-100350.html.

The supported database character set is AL32UTF8.

Installing Oracle Public Sector Revenue Management Analytics

This section provides high level steps for installing Oracle Public Sector Revenue Management Analytics. For detailed installation information, see the Oracle Public Sector Revenue Management Analytics Installation Guide.

To install Oracle Public Sector Revenue Management Analytics V2.1.0.0.0:

1. Install database server software.

2. Create a database for Oracle Public Sector Revenue Management Data Model Schema, Data Mining Schema and Oracle Data Integrator repositories.

3. Setup database users for Oracle Public Sector Revenue Management Data Model Schema, Data Mining Schema and Oracle Data Integrator repositories.

4. Create Oracle Data Integrator Master Repository using Oracle Public Sector Revenue Management Analytics Installer.

5. Import the Oracle Data Integrator Work repository using the Oracle Public Sector Revenue Management Analytics installer.

6. Install Oracle Public Sector Revenue Management Data Model and Data Mining schema objects using the Oracle Public Sector Revenue Management Analytics installer.

7. Install System data using the Oracle Public Sector Revenue Management Analytics installer.

8. Install Oracle Business Intelligence Enterprise Edition software.

9. Deploy OBIEE RPD into OBIEE environment.

10. Deploy OBIEE Web catalog into OBIEE environment.

11. Deploy Oracle Public Sector Revenue Management Analytics Writeback file into OBIEE environment.

12. Setup OBIEE users.

13. Configure Map Viewer to support map views in OBIEE.

14. Install Oracle Data Integrator software on the ODI Agent server.

15. Configure agent.

The following diagram provides an overview of the steps that need to be taken to install and configure Oracle Public Sector Revenue Management Analytics:

Table of Contents

Cover Page

Legal Notices

Preface

Oracle Public Sector Revenue Management Analytics Installation Overview

Media Pack Contents

Additional Software Requirements

Components for Oracle Public Sector Revenue Management Analytics

Architecture Overview

Supported Platforms

Installing Oracle Public Sector Revenue Management Analytics