Contents

Title and Copyright Information

Send Us Your Comments

Preface

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

1 Introduction

• Basic RPASCE Concepts
  • Multidimensionality
  • Dimensions
  • Measures
  • Domains, Segments, and Workbooks
  • Measure Data
• RPASCE Client
  • Administrative Workbooks and Wizards
  • Online Administration Tools
  • Dashboard Settings

2 User Maintenance

• User Administration Activity
  • Adding a User
  • Adding a User Group
  • Deleting a User
  • Deleting a User Group
  • Editing a User
• Managing Users Using User Manager
  • User Names in Log Files
• Atomic User Management
  • IDCS or OCI IAM Migration Tool
  • User Maintenance after AUM is Enabled
  • Feature Toggle for AUM

3 Dashboard Settings

• Using the Dashboard Settings

4 System Administration

• Hierarchy Maintenance Workbook
  • Hierarchy Maintenance Example
  • Hierarchy Maintenance Wizard
  • Hierarchy Maintenance View
  • Maintaining a User-Defined Dimension Within a Hierarchy
• Security Administration Workbook
  • Security Overview
    • User and Group Security
    • Measure Level Security
    • Position Level Security
    • Workbook Security
  • Security Administration Workbook
    • Workbook Template Rights View
    • Workbook Template Measure Rights View
    • Measure Rights View
    • Dimension Modification Rights View
    • Position Level Security Views
    • Workbook Template Limits Views
    • Max Domain Session Limit View
    • Max User Session Limit View
    • Group Workbook Template Default Rights View
    • Group Measure Default Rights View
  • Using the Security Administration Workbook
    • Accessing Security Administration
    • Setting or Modifying Users' Access to Workbook Templates
    • Setting Measure Availability for Workbook Templates
    • Assigning or Restricting User Access to Measures
    • Changing a User's Ability to Modify Dimensions
    • Setting or Modifying Access to Positions (if Position Level Security has been Enabled)
    • Limiting the Number of Workbooks that a User Can Save
    • Limiting the Number of Workbooks Per Template
    • Limiting the Number of Workbooks that a Group Can Save
• Withdrawing Administrative Privileges or User Access Rights
  • Security Administration Workbook Withdrawal Scenario
    • Workbook Template
  • Administration Without Security Administration Workbook
    • User Administration
    • User Lock
• Measure Analysis Workbook
  • Measure Analysis View
  • Accessing Measure Analysis
  • Reviewing and Editing Sales or Other Registered Measure Data
• Format/Users/Security Export Task
• Formats/Users/Security Import Task
  • XML Schema for Importing Users and Groups
• List Logged-In Users
• Apply Format
• Schedule Dashboard Build
  • Troubleshooting Dashboard Issues

5 Internationalization

• Translation
• Translation Administration
  • Translation Administration Workbook
    • Hierarchy Labels View
    • Dimension Labels View
    • Workbook Template Group Labels View
    • Workbook Template Labels View
    • Measure Labels, Measure Descriptions, and Measure Picklists View
    • User Group Labels View
    • Rule Group Labels View
• Taskflow Components Translation
• Position Label Translation
• Translation by Online Administration Tools
• Troubleshooting

6 Online Administration Tools

• Online Administration Tools Templates
  • Copy from an Existing Admin Task
  • Delete a Scheduled Admin Task
  • Modify a Scheduled Admin Task
  • Submit a New Admin Task
  • System Administration Tasks
  • Service Request Administration Tasks
  • Application Administration Tasks
  • RPAS_TODAY for Online Administration Tools Tasks
• Email Notification for OAT Tasks
• System Administration Tasks
  • Blackout Window Task
  • Dimension Manager Task
  • Domain Information Task
  • Domain Property Utility Task
  • Domain Statistics Generation/Validation Task
    • Assumptions
    • Validation Process
  • Export Domain Slice
  • Export Hierarchy Data Task
  • Export Measure Data Task
  • Export Migration Data
  • Manage Hierarchies Task
  • Load Hierarchy Data Task
    • Exclusive Message
    • Load and Refresh the Specified Hierarchy
  • Load Measure Data Task
  • Mace Informational Commands Task
  • Manage Directory Contents Task
  • Manage Informal Positions Task
    • Create Informal Positions in Bulk
    • Data Slice Copying
  • Optimize Domain Task
  • Print Measure Task
  • Purge Tasks from Task Status Dashboard Task
  • Reindex Domain Task
  • Rename Positions Task
  • Scan Domain Utility Task
  • Segment/Workspace Batch Operation Task
  • Enable/Disable Toggleable Features Task
  • TarGz Create a Package Task
  • Extract an Archive Package into Domain Input Directory
  • Backup Domain
  • Change System Nightly Domain Backup Start Time
  • Workbook Manager Task
• Service Request Administration Tasks
  • Package Logs Task
  • Clone Domain Task
  • Clone PDS Task
  • Start Oracle OS Performance Profiling Task
  • Stop Oracle OS Performance Profiling Task
  • GET RPAS Environment Profile Task
• Bootstrap Administration Tasks
  • Build Customer Domain Task
  • Exporting and Restoring the Complete RPASCE Domain Using Self-Service
    • Exporting the Full Domain
    • Restoring the Full Domain
    • Triggering the Functionality through Batch
• Administration Dashboard
  • Task Status
  • Dashboard Columns
    • Other Dashboard Options
  • Disc Subscription Statistics
  • Active Users

7 Informational Utilities

• Retrieving Domain Information
  • Submitting a Domain Information Task
• Printing Measure Information
  • Submitting a Measure Information Task

8 Data Administration

• CSV File Format
• Hierarchy Management
• Adding New Dimensions to Hierarchies
• Loading Hierarchies
  • Submitting Load Hierarchy Data Task
  • Informal Position Manager
    • Input Files for the Formal Position Manager
    • File Formats
    • Submitting Manage Informal Position Task
    • Create Informal Positions in Bulk
    • Data Slice Copying
  • RPASCE-RMS Integration for Item Management - Slow Item Build
    • On-Demand Item Creation
    • DPM Operations
    • RMS Manager
  • Position Label Translation
• Exporting Hierarchy Data
• Importing Migration Data
• Loading Measure Data
  • 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
  • Submitting a Load Measure Task
• Exporting Measure Data
  • Submitting an Export Measure Data Task
• Scan Domain Data Using Scan Domain
  • Scan Domain Usage
  • Managing Scan Domain
  • Fix Domain
    • Remove Inconsistent Measure Attributes
    • Remove Partially Unregistered Measures
    • Repair Discrepancies in Hierarchy Information
    • Repair Unlinked Arrays
  • Managing Fix Domain
  • Fix Domain Usage

9 Operational Utilities

• Setting Miscellaneous Domain Properties
  • Submit Online Admin Task for Domain Property Service
    • Reset Properties to Default Value
    • Display History of Changes Made to Domain Properties
    • Display Current Value of Properties
    • Display Current Value of Property
    • Update Property to Value Provided (name=value)
• Setting Date and Time Variables
• Accessing the Calculation Engine Using mace
  • Submit Online Admin Task for Mace Service
    • Search for a Specific String
    • Validate a Specific Expression
    • Print the Specified Rule
    • Print the Specified Rule Group
    • Print All the Rules and Rule Groups
• Managing Segments Using wbbatch
• Managing Workbooks Using wbmgr

10 Taskflow Errors

11 Patch Domain

12 Batch Administration

• Application-Specific Batch Tasks
  • Run Batch Measure Load Group
  • Run Batch Measure Export Group
  • Run Batch Calc Group
  • Run Batch Task Group
  • Clean Up Task
  • Retrieve Batch Control Files
  • Upload Batch Control Files
  • Manage JSON Files
  • Patch JSE Jars
  • Remove JSE Jar
• Translation Tasks
  • Upload Custom Translations
  • Remove Custom Translations
  • Other Translation Tasks
  • Supported Translation Measures
• Download Application Domain Config
• Retail Home Seeding
  • Retail Home Configuration
  • Updating Retail Home

13 Uploading and Downloading Batch Files

• Adding Authorized Keys
• Logging In to WinSCP
• Uploading the Batch File
• File Downloads
• Download Requests

14 RPASCE Test Automation

• Introduction
• RPAC in Batch Framework
• Writing Test Cases
• Example
• Output
• Schema
  • RPAC Attributes, Values, and Variables
  • 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 Log
    • 2.2 Fail
    • 2.3 key
    • 2.4 rpas-today
    • 2.5 shell
    • 2.6 register-measure
    • 2.7 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. Array Tags
    • 6.1 assert-array-contains
    • 6.2 assert-array-match
    • 6.3 clear-array
    • 6.4 write-to-array
• RPAC Restricted Tags for Cloud Deployment

15 Additional Configuration

• Notifications
  • Selecting the Notification App Code
• Adding Images
• Images and Contextual Help
• Chart Data Points
• Alert Navigation Limits
• Local Domain Indexing
  • Design Overview
  • Domain Property
  • Plan Generation Example
  • Parallel Plan Execution Example
  • Assumptions, Constraints, Dependencies, Limitations
• Dashboard Plans
• Auto-Refresh
• Paste Error Limit
• Position Count Threshold
• Global Area Configuration
• Self-Service System Configuration
• Tomcat Proxy Settings
• Exporting Images

16 Performance Diagnostic Tool

• Overview
• Collecting and Managing Performance Metrics
• Analyzing Workbook Performance
• Analyzing Batch Performance Data
• Analyzing Disk Usage
• Monitor Disk Usage
• Analyzing Workbook Usage
• Analyze Measure Size
• Analyzing Dimension Size

17 Planning Data Store Administration

• PDS Administration Tasks
• Building a Template Planning Data Store (PDS)
• Patch PDS
• Downloading the PDS Configuration
• Post Build Steps
  • Check PDS
  • List PDS Status
  • Load Dimension Data
    • Loading Dimension Data
  • Load Fact Data
    • Loading from BDI
    • Updating Calendar Start Month
  • PDS Manager
  • Dimension and Fact Data Synchronizing between PDS and Domains
• Planning Data Store Default Web Services (through ORDS)
  • User Creation
  • Default Web Services
    • Web Services URL
    • Pagination
• IDCS or OCI IAM Authorized Access to PDS Web Services in Apex/ORDS
  • Requirements
    • Get Bearer Token
  • Perform the ORDS Rest API Calls
    • Invoke Read PDS Web Service - Read all Measures
  • Write PDS Web Service to a Fact
  • Invoke Read PDS Web Service - Retrieve Data from a Fact

18 RPASCE Batch Schedule with POM

• RPASCE Batch Schedule
• POM Batch Monitoring
• POM System Administration
• POM Batch Administration
• JOS Job Admin Console
• POM Batch Scheduling
• Batch Invocation Through Restful Endpoints
• Custom Batch Schedule

19 Blackout Window

• Ad Hoc Blackout Window
  • Scheduling a Blackout Window
  • Notification Window
  • Blackout Window
  • Stop/End Blackout Window
• Batch Notification Window
  • Configuring Batch Notification Window
  • Scheduling a Pre-Configured Batch Run with the Blackout Window
  • Batch Notification Window Warning Message
  • Normal Batch Run - Domain Exclusive Mode

20 RPASCE Health Check Tasks

21 Best Practices

• Periodic Maintenance Tasks
  • Clean Up Old Workbooks
  • Clean Up Old Administration Tasks
  • Clean Up Outgoing FTP Site
  • Remove Old or Processed Input Data Files
  • Performance Diagnostic Tool
  • Run fixDomain
  • Domain Refresh
    • Use Cases Requiring Domain Refresh
    • Domain Refresh Options

A Appendix: Troubleshooting

B Appendix: RPASCE Client Logging Configuration

• Log Files
• Log Levels
• Logging Based on Application Layers
• Performance Logging
• Latency Logging