Contents

Title and Copyright Information

Send Us Your Comments

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Customer Support
• Review Patch Documentation
• Improved Process for Oracle Retail Documentation Corrections
• Oracle Retail Documentation on the Oracle Technology Network
• Conventions

1 Introduction

• Administrator Overview
• Basic Concepts of RPAS
  • Multidimensionality
  • Hierarchies
  • Measures
  • Domains and Workbooks
    • Measure Data
• Administrative Workbooks and Wizards
• Hybrid Storage Architecture
• A Note about RPAS Configurability and Extensibility

2 Building and Upgrading Domains

• Building a Domain
  • Prerequisites
  • Client-Side Procedures
    • Zip the Configuration Project Folder
  • Server-Side Procedures
    • Unzip the Configuration File
    • Verify the Environment Variable Settings
    • Get the Input Files Ready
• Building the Domain Manually or Through a Command-Line Interface
  • rpasInstall
    • rpasInstall Usage
  • Validate Domain Build Results
• After Building the Domain
  • Upgrading and Patching Domains
  • Upgrading From Any Release of RPAS Prior to 13.3
  • Domain Conversion
    • Domain Preparation Before Conversion
    • Setting up Domain Conversion Parameters
    • Running the Domain Conversion
    • Post-Conversion Processing
  • Upgrading From RPAS 13.3 or Later
  • Updating Domain Content
    • Hierarchies
    • Measure Properties
    • Rule Groups
    • Workbooks
  • RPAS 14.0 Cryptography Upgrades
  • Upgrade Configurations
    • Command-Line Support for Configuration Upgrading
    • Upgrade Application Configurations
  • convertDomain
    • convertDomain Usage
  • convertDomain -suggestDimBitSize
    • Usage for -suggestDimBitSize
  • upgradeDomain
    • upgradeDomain Usage
• fixDomain
  • fixDomain Usage

3 Domain Administration

• Configuring the Classic Client Using eConfigure
  • The eConfigure Menu Bar
  • The eConfigure Main View
    • Advanced Settings Dialog
• DomainDaemon
  • DomainDaemon Usage
  • Starting the DomainDaemon
  • Monitoring the DomainDaemon
  • Stopping the DomainDaemon
• Losing a Client-Server Connection
  • Graceful Termination of the Existing Session
  • Autosave of Workbooks

4 SSL

• Introduction
• One-Way SSL
  • Creating a Self-Signed Root Certificate
  • Configuring the RPAS Server
    • Setting Up the Key Store
    • Starting the Domain Daemon
  • Configuring the Classic Client
  • Script for Creating Self-Signed Wallets
    • Usage for createSSLWallets.sh
    • User Input
    • Output
    • Error Handling
  • RPAS Web Launch
• SSL Without Authentication
  • RPAS Server Configuration

5 User Maintenance

• Access the User Administration Tab
• Add User
• Add User Group
• Delete User
• Delete User Group
• Edit User
• Managing Users Using usermgr
  • usermgr Usage
  • XML Schema
  • Use Cases
    • Exporting from an Existing Domain
    • Importing into a Domain
    • Converting Between XML and Database

6 System Administration

• Auto Workbook Maintenance Wizard
  • Add a Workbook to the Auto Build Queue
  • Delete a Workbook from the Auto Build Queue
  • Edit Workbook Settings
• Workbook Batch Category Management
  • Workbook Batch Category Management Wizard
  • Adding a Category
  • Deleting a Category
  • Changing a Category Label
• Hierarchy Maintenance Workbook
  • Hierarchy Maintenance Example
  • Hierarchy Maintenance Wizard
  • Hierarchy Maintenance Worksheet
  • Access Hierarchy Maintenance
  • Maintain a User-Defined Dimension Within a Hierarchy
• Password Policy Administration Workbook
• Security Administration Workbook
  • Security Overview
    • User Logon Security
    • Measure Level Security
    • Position Level Security
    • Workbook Security
  • Security Administration Workbook
    • Workbook Template Rights Worksheet
    • Workbook Template Measure Rights Worksheet
    • Measure Rights Worksheet
    • Dimension Modification Rights Worksheet
    • Position-Level Security Worksheets
    • Workbook Template Limits Worksheets
    • Max Domain Session Limit Worksheet
    • Max User Session Limit Worksheet
  • Using the Security Administration Workbook
    • Access Security Administration
    • Set or Modify User Access to Workbook Templates
    • Set Measure Availability for Workbook Templates
    • Assign or Restrict User Access to Measures
    • Change User Ability to Modify Dimensions
    • Set or Modify Access to Positions
    • Limit the Number of Workbooks that a User Can Save
    • Set or Modify the Maximum Domain Session Limit
    • Set or Modify the Maximum User Session Limit
• Measure Analysis Workbook
  • Building a Measure Analysis Workbook
  • Measure Analysis Worksheet
  • Review and Edit Sales or Other Registered Measure Data

7 Hierarchy Management

• Loading Hierarchies Using loadHier
  • loadHier Usage
  • loadHier Notes
  • Position Label Translation
• Integer Indexing
  • Changing the Bit Size
• Reindexing Domains Using reindexDomain
  • reindexDomain Usage
    • ReindexDomain Option: Reindex
    • ReindexDomain Option: Analysis
    • ReindexDomain Option: Domain Properties
  • When to Reindex
    • Run Reports
  • How to Reindex a Dimension
    • Reindex Entire Domain as Needed
    • Reindex Entire Domain with Force Option
    • Reindex Dimensions
    • Prepending Calendar Dimensions
  • Reindex Domain Examples
    • Condition 1: Change of Bit Size
    • Condition 2: Using the -force Option
    • Condition 3: Fragmentation Checks
• Optimizing Domains Using optimizeDomain
  • optimizeDomain Usage
    • Usage Examples
• Adding New Dimensions to Hierarchies
  • Exporting Measure Data
  • Exporting Hierarchy Data
  • Purging Hierarchy Data
  • Adding New Dimensions
  • Reloading Formal Hierarchy Data
  • Informalizing DPM Positions
  • Reloading Measure Data
  • Adding New Hierarchy Dimensions Sample Script
  • Transferring Data
    • Masks
    • transferData Usage
    • Scenarios
• FilterHier Utility
  • filterHier Usage
  • filterHier Notes
  • Error Conditions
• Position Repartitioning
  • Loading RDF and Curve Parameters after Repartitioning
    • Syntax
• Reconfiguring Partitions of a Global Domain Using reconfigGlobalDomainPartitions
  • reconfigGlobalDomainPartitions Usage
  • Using an Input File
  • Notes, Assumptions, and Limitations
• Renaming Positions Using renamePositions
  • renamePositions Usage
• Managing Dimension Attributes Using dattrmgr
  • dattrmgr Usage
  • dattrmgr -report Examples
• Setting Properties for Dimensions Using dimensionMgr
  • dimensionMgr Usage
  • Changing the Label of a Dimension
• Exporting Hierarchy Data Using exportHier
  • exportHier Usage
• Informal Position Manager
  • InformalPositionMgr Usage
  • Basic Operations: Informalize, Formalize, Remove, and Load
    • Error Handling
  • Create Informal Positions in Bulk
    • Example 1: Creating Informal Positions on the STYL Dimension
    • Example 2: Creating Informal Positions on the SZ12 Dimension
    • Position Naming Convention
  • Data Slice Copying
    • Merging Informal Positions to Formal Positions
• Managing Position Lists as PQDs Using pqdMgr
  • pqdMgr Usage
  • pqdMgr Notes

8 Data Management

• Loading Measure Data Using loadmeasure
  • Load File Names and Load Behavior
  • Loading Multiple Measures from One File
    • CSV Files
    • Fixed Width Files
  • Loading Data from Below the Base Intersection of the Measures
  • Staging Measure Loads
  • Running Pre-Load or Post-Load Scripts
  • Purging Old Measure Data
  • Behavior in an Integrated Environment
  • Behavior in a Global Domain Environment
  • loadmeasure Usage
  • Loading Image Paths for Positions
• Exporting Measure Data Using exportMeasure
  • exportMeasure Usage
• Exporting Measure Data Using exportData
  • exportData Usage
    • The -useLoadFormat Parameter
• Mapping Data Between Domains Using mapData
  • mapdata Usage
• Moving Data Between Arrays Using updateArray
  • updateArray Usage
• Scan Domain Data Using scanDomain
  • scanDomain Usage
• Repair Domain Metadata Using fixDomain
• Sync Measure NA Value with Array NA Value Using syncNAValue
  • syncNAValue Usage

9 Operational Utilities

• Finding Alerts Using alertmgr
  • alertmgr Usage
• Copying Domains Using copyDomain
  • copyDomain Usage
    • copyDomain: Format of the XML Configuration File
• Moving a Domain Using moveDomain
  • moveDomain Usage
    • moveDomain: Format of the XML Configuration File
    • Assumptions and Requirements
    • Minimum Space Requirement
• Setting Miscellaneous Domain Properties Using domainprop
  • domainprop Usage
    • Available Properties
• Using the mace Calculation Engine
  • mace Usage
  • mace Restrictions in Global Domains
  • Executing mace in an Integrated Environment
• Managing the Workbook Batch Queue Using wbbatch
  • wbbatch Usage
• Managing Workbooks Using wbmgr
  • wbmgr Usage
• Registering Measures Using regmeasure
  • regmeasure Usage
• Registering Token Measures Using regTokenMeasure
  • regTokenMeasure Usage
• Batch Plug-In Tasks: execPluginTask.sh
  • execPluginTask.sh usage

10 Informational Utilities

• Retrieving Domain Information Using domaininfo
  • domaininfo Usage
• Checking the Validity of a Domain Using checkDomain
  • checkDomain Usage
• Determining RPAS Server Version Using rpasversion
  • rpasversion Usage
• Listing Contents of a Database Using listDb
  • listDb Usage
• Printing Data from Arrays Using printArray
  • printArray Usage
• Printing Data from Measures Using printmeasure
  • printmeasure Usage

11 Internationalization

• Translation
• Translation Administration
  • Translation Administration Workbook
    • Hierarchy Labels Worksheet
    • Dimension Labels Worksheet
    • Workbook Template Group Labels Worksheet
    • Workbook Template Labels Worksheet
    • Measure Labels Worksheet
    • Measure Descriptions Worksheet
    • User Group Labels Worksheet
    • Message Labels Worksheet
    • RGRP Labels Worksheet

12 Commit as Soon as Possible

• Using Commit ASAP
• Managing the Workbook Queue Using showWorkbookQueues
  • showWorkbookQueue Usage
• Commit ASAP Settings Using configCommitAsap
  • configCommitAsap Usage
  • Logging and Technical Information

13 Batch Processes and RPAS Utilities

• CSV File Format
• RPAS Utilities Logging Options
  • Log Levels
  • Utilities with Standard Logging
    • Scripts
  • Utilities with Multi-Process Logging
  • Utilities with Special Logging
  • Utilities and Database Locks
• Using Shell Scripts to Run Batch Processes
  • A Sample Shell Script
• Common Information and Parameters for RPAS Utilities
  • Configuration Tools Log Files
• RPAS Intraday Enabler
  • ride Usage
  • Scenarios
    • Scenario 1
    • Scenario 2
    • Scenario 3
    • Scenario 4
    • Scenario 5
    • Scenario 6
  • Domain Lock Status Using domainStatus
    • domainStatus Usage

14 RPAS ODBC/JDBC Driver

• ODBC Configuration
  • Defining the ODBC Server Configuration Settings
    • Adding RPAS ODBC Manager in the Management Console
    • Configuring the Use of the ODBC Manager
    • Importing the Configuration Changes
  • Defining the ODBC Client Configuration for Windows
• Starting the RPAS ODBC Server Process
  • Testing the Connection Using Interactive SQL
• ODBC Client Configuration for UNIX
  • Client Configuration
  • Testing the Connection
• Installing and Using the RPAS JDBC Driver
  • Updating Environment Variables for the JDBC Driver on Windows
  • Updating Environment Variables for JDBC Driver on UNIX and Linux
  • Using the RPAS JDBC Driver
  • Enabling Spy for the RPAS JDBC Driver
  • Using the jdbcisql Utility Provided with the RPAS JDBC Driver
  • Using Oracle SQL Developer
  • Using Oracle JDeveloper
  • Using a Java Program
    • Running the Program
• Data Query
  • Limitations
    • Contention
    • Workbook Queries
  • Metadata
  • Fact and Dimension Tables
• Measure Security in the ODBC Driver
• Use Cases
  • Using Metadata Tables to Explore the Structure of a Domain or a Workbook
  • Querying Fact Data
  • Connecting to a Workbook
  • Requesting Additional Aggregate Tables
• Clients
  • Oracle Business Intelligence Enterprise Edition (OBIEE)
    • Configuring the ODBC Client for OBIEE
    • Connecting OBIEE to an RPAS Domain
  • Microsoft Access
  • JDeveloper
  • XML Publisher
  • Interactive SQL (ISQL) Utility
• Supported and Unsupported SQL Functions
  • Supported SQL Functions
    • Numeric Functions
    • String Functions
    • Time and Date Functions
    • System Functions
    • Aggregate Functions
    • Other Functions
  • Unsupported SQL Functions
    • Handling of NULLS
    • Schema Information
    • Data Definition Language (DDL)
    • Insert
    • SELECT Syntax
    • Value Expressions
    • Value Functions
    • Date and Time Functions
    • Advanced Value Expressions
    • Row Value Constructor
    • Predicates
    • Join Operators

15 Publishing Measure Change Events

• Configuring Subjects and Measures for Monitoring
• Configuring the RPAS JMS Publisher
  • Command Line
  • Configuration Settings
    • General Settings
    • Vendor-Specific Settings
    • File-Based JNDI Object Store
    • LDAP-Based JNDI Object Store
• Configuring the RPAS JMS Subscriber
  • Command Line
  • Configuration Settings

16 In-Context Launch

• Launching RPAS
  • Issuing a Launch Request from a Web Page
    • Embedding an RWL Applet on a Web Page
    • Using JavaScript with the RWL Applet
    • User Authentication
    • Deploying In-Context Launch
    • Use Cases
  • RPAS Launch Context Format
    • Client Settings
    • Server Settings
    • Domain Settings
    • Workbook Settings
    • XML Schema
  • Open Workbook
    • Specifications
    • Examples
  • Build Workbook
    • Specifications
    • Example
  • The buildWorkbookContext Utility
    • buildWorkbookContext Usage

17 Hybrid Storage Architecture

• Data Model
  • Naming Convention
  • Dimension-Fact Entity Relationship Diagram
    • Sample Integration Configuration
    • Sample ERD for Dimension and Fact Tables
  • Table Descriptions
    • RPAS Metadata Tables
    • Commit Metadata Tables
    • Dimension-Based Tables
    • Translation Table
    • Index Translation Table
    • Fact Tables
    • Temporary and Logging Tables
  • Schema Partitioning
    • Dimension and Fact Table Partitioning
    • ITT Table Partitioning
  • Sequence Descriptions
  • Package Descriptions
  • Access Schema Descriptions
  • Security Considerations
  • External Integration
    • Setup
    • Execution
• Configuring the RPAS Data Mart
  • RDM Repository
    • Directory Structure
  • RDM Properties in a Domain
  • Schema Information
  • Integration Configuration
    • Shared Hierarchies
    • Shared Facts
    • Integration Map
    • Domain and Configuration Map
    • Example
  • Partition Information
  • RDM SSL Connection
    • SSL Overview
    • Set Up SSL on Oracle Server
• RPAS HSA Build Process
  • RPAS Installation Utilities
    • RDM Preparation Script
    • RPAS Installer
    • RDM Manager
  • Pre-Installation – Preparing the Integration Environment
  • Installation – Building the RDM Schemas
  • Post-Installation – Initialization and Registration
    • Load Dimension Data
    • Register Participating Domains
    • Load Shared Fact Data
• Operating and Maintaining the RPAS Data Mart
  • upgradeRDM
    • Usage
  • patchRDM
    • Usage
  • loadDimData
    • Flat File Format
    • Filtered Shared Levels
    • Validation of Input Data
    • Usage
  • loadFactData
    • Input File Format
    • Input Files Location
    • Input File Naming
    • Input Data Validation
    • Data Loading Modes
    • Logging
    • Usage
  • transferFactData
    • Usage
  • checkRdm
    • Usage
• RDM Partitioning and RDM Partition Manager
  • Determining the RDM Partition Level
  • Mapping Local Domains to RDM Partitions
  • RDM Schema Partitioning
  • RDM Partition Manager
    • Usage
    • The Format of RDM Partition Configuration
  • Initial RDM Partitioning
  • Patching RDM and Integrating One or More New Domains
  • Hierarchy Operations Affecting RDM Partitioning
    • Dimension Data Loading in RDM and Domain
    • Domain Reclassification
    • Dynamic Position Maintenance
  • Coordinating RDM Partitioning Using the RDM Status Table
    • Status: loadHier in Progress
    • Status: reconfigGlobalDomainPartitions in Progress
    • Status: loadDimData in Progress
    • Status: Repartition in Progress
    • Status: Repartition Recommended
• Coordination of Domain Processes in an Integrated Environment
  • Recommended Process Sequencing
  • Parallel Execution of Processes
  • RDM Status Tables
  • RDM Status Messages
    • RDM is Missing Positions
    • Repartition Recommended
  • RDM Status Utility
    • Usage of rdmStatus Utility
• RPAS HSA Translation
  • Flat File Requirements
    • Dimension Label Flat File
    • Level Label Flat File
    • Fact Label and Description Flat Files
    • Position Label Flat Files
  • Source Language
  • loadTranslation
    • Input Files
    • loadTranslation Utility

A Appendix: Curve Administration Guide

• curvevalidate
  • curvevalidate Usage
• curvebatch
  • curvebatch Usage

B Appendix: RPAS Test Driver

• Support
• Introduction
  • Audience
  • Finding Required Information
  • Compatibility
• Interface
• XML Requests
  • Connection Messages
    • <Logon>
    • <Logoff>
  • Wizard Messages
    • <WizardInitialize>
    • <GetNextWizardDialog>
    • <GetWizardLayout>
    • <SelectPositions>
    • <SetWizardData>
    • <WizardFinish>
  • Workbook Messages
    • <OpenWorkbook>
    • <Fetch>
    • <SetValues>
    • <CommitWorkbook>
    • <RefreshWorkbook>
    • <MenuEvent>
    • <CreatePOPMeasure>
    • <SaveWorkbook>
    • <CloseWorkbook>
• RTD Use with HP LoadRunner
• Prerequisites
• Header File
  • lr_rtd.h
• LoadRunner Scripting
  • Script Settings
  • Script Sections
  • Script Implementation
    • Script Section: vuser_init
    • Script Section: Action (simple test)
    • Script Section: Action (real-world)
  • Considerations for Scenario Use

C Appendix: RPAS Test Automation

• Introduction
• Usage
• Writing Test Cases
• Example
• Output
• Schema
  • 1. Top-Level Parent Tag
    • 1.1 testscript
    • 1.2 testsuite
    • 1.3 testcase
    • 1.4 once
    • 1.5 finalize
    • 1.6 setup
    • 1.7 teardown
    • 1.8 log
    • Sample Usage
  • 2. Generic Tags
    • 2.1 Attribute
    • 2.2 Description
    • 2.3 Fail
    • 2.4 key
    • 2.5 rpas-today
    • 2.6 shell
    • 2.7 register-measure
    • 2.8 unregister-measure
  • 3. Domain Operation Tags
    • 3.1 Assertions
    • 3.2 Domain Data Edit Operations
  • 4. Workbook Operation Tags
    • 4.1 Workbook Wizard Operations
    • 4.2 Workbook Operations
    • 4.3 Workbook Assertions
    • 4.4 Workbook Data Edit Operations
  • 5. Dynamic Position Maintenance (DPM) Tags
    • 5.1 Assertions
    • 5.2 Update Informal Position Operation
    • 5.3 Delete Informal Position Operation
  • 6. HSA Tags
    • 6.1 assert-fact-group
    • 6.2 assert-fact-table
    • 6.3 assert-fact-value-eq
    • 6.4 assert-fact-value-ge
    • 6.5 assert-fact-value-gt
    • 6.6 assert-fact-value-le
    • 6.7 assert-fact-value-lt
    • 6.8 assert-fact-value-ne
    • 6.9 assert-level-contain
    • 6.10 clear-rdm-status
    • 6.11 set-rdm-status
    • 6.12 set-fact-value
    • 6.13 reset-seq-generator
    • 6.14 assert-rdm-hier-exists
    • 6.15 assert-level-exists

D Appendix: Environment Variables

• Required Settings
• Database Settings
  • RPAS_ARRAY_TAG
  • RPAS_CACHE
  • RPAS_PAGE_SIZE
  • RPAS_PAGE_SPLIT_PERCENTAGE
  • RPAS_LOCK_TIMEOUT
  • RPAS_REQUEST_TIMEOUT
  • RPAS_USER_MODE
• Java Special Expression Settings
  • RPAS_JAVA_CLASSPATH
  • RPAS_JAVA_DEBUG_PORT
  • RPAS_JAVA_MAXHEAPSIZE
• Log Settings
  • RPAS_CACHE_LM_MULTIPILER / RPAS_DISABLE_LM_DIRECT
  • RPAS_CLIENT_TIMEOUT / RPAS_SERVER_TIMEOUT
  • RPAS_COMMIT_FAILED_MAX / RPAS_COMMIT_SUCCESS_MAX
  • RPAS_JAVA_MAXHEAPSIZE
  • RPAS_LOCK_DETAIL_PATH
  • RPAS_LOCK_LOGGING
  • RPAS_LOCK_LOG_PATH
  • RPAS_LOCK_TRACK_DATABASES
  • RPAS_LOCK_ACCESS_LIMIT
  • RPAS_LOG_BACKUPS
  • RPAS_LOG_FD
  • RPAS_LOG_FLUSH
  • RPAS_LOG_LEVEL
  • RPAS_LOG_PATH
  • RPAS_REQUEST_TIMEOUT
  • RPAS_SHELL
  • RPAS_SPLIT_BUF_MB
  • RPAS_STATS_PATH
  • RPAS_TCPNODELAY
  • RPAS_TRACE_SSL
  • TMPDIR
  • TODAY_RETEK
• Parallelization Settings
  • RPAS_EXPORT_MEASURES_MAX
  • RPAS_MIN_MEAS_PER_PROC
  • RPAS_PROCESSES
• Profiling Logging
  • RPAS_PROFILING_ENABLE
  • RPAS_PROFILING_PATH
• Date and Time Setting
  • RPAS_TODAY
  • RPAS_TODAY_STATIC
• Numeric Precision
  • RPAS_INCAGGPRC
  • epsilon
• RPAS_SSL_WALLET
• LDR_CNTRL=NAMEDSHLIB=RPASZONE
• Nagle's Algorithm