Skip Headers
Oracle® Retail Predictive Application Server Administration Guide for the Classic Client
Release 14.1
E59120-01
Next
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