Go to primary content
Oracle® Retail Predictive Application Server Cloud Edition Administration Guide
Release 23.1.201.0
F80305-03
Next
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
Segments and Workspaces
RPASCE Client
Administrative Workspaces and Wizards
Online Administration Tools
Dashboard Settings
2
User Administration
Atomic User Management
Setting Up Users and Groups
AUM Utilities
OCI IAM Migration Tool
Synchronize Users from OCI IAM
User Maintenance
3
Planning Data Schema Administration
Introduction
Configuration
Partitioning
Building PDS
Patch PDS
Post Build Steps
Check PDS
List PDS Status
Create Reporting Views in PDS
Load Dimension Data
Loading Dimension Data
Load Fact Data
PDS Manager
Planning Data Schema Default Web Services (through ORDS)
Apex User Creation
Default Web Services
Web Services URL
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
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
Security Overview
User and Group Security
Position Level Security
Workbook Security
Security Administration Workbook
Workbook Template 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
Using the Security Administration Workbook
Accessing Security Administration
Setting or Modifying Users' Access to Workbook Templates
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
Measure Analysis Workbook
Measure Analysis View
Accessing Measure Analysis
Reviewing and Editing Sales or Other Registered Measure Data
XML Schema for Importing Users and Groups
List Logged-In Users
Schedule Dashboard Build
5
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
General Submission Workflow
Select a Task Group
Select a Task
Setting Parameters
Setting the Schedule
Confirmation
Task Status Dashboard
Email Notification for OAT Tasks
System Administration Tasks
Manage Dimensions Task
Load Alternate Rollup Data Task
Oracle Support Administration
List/Set/Unset PDS Integration Variables
Load Interface Mappings
Export Hierarchy Data Task
Export Measure Data Task
Manage Hierarchies Task
Expressions, Rules, and Rule Groups Information Task
Manage Informal Positions Task
Create Informal Positions in Bulk
Data Slice Copying
Measure Information Task
Purge Tasks from Task Status Dashboard Task
Rename Positions Task
Segment/Workspace Batch Operation Task
Enable/Disable Toggleable Features Task
Manage Workspaces Task
Service Request Administration Tasks
Package Logs Task
Bootstrap Administration Tasks
Build Application Task
Template Status Task
Unregister Application
Retail Home Seeding
Retail Home Configuration
Updating Retail Home
Application Administration Tasks
Task Status Dashboard
Dashboard Columns
Active Users
Other Active User Options
6
Data Administration
CSV File Format
Hierarchy Management
Modifying Hierarchies
Managing Dimension Data
Managing Informal Positions
Exporting Hierarchy Data
Loading Measure/Fact Data
Exporting Measure Data
7
Batch Administration
Application-Specific Batch Tasks
Run Batch Task Group
Run Batch Measure Load Group
Run Batch Measure Export Group
Run Batch Calc Group
Uploading and Downloading Data Files
8
RPASCE Batch Schedule with POM
RPASCE Batch Schedule
POM Batch Monitoring
POM System Administration
POM Batch Administration
Controlling POM Batch Execution Using Retail Home Customer Module Management
POM Batch Scheduling
Batch Integration through Restful Endpoints
Custom Batch Schedule
9
Internationalization
Translation in RPASCE
Browser Setup
Translation Administration Workspaces
Translation Administration Workspace
Dimension
Hierarchy
Measure
Message
Rule Group
Template
Template Group
User Group
Position Translation Administration Workspace
Building a Position Translation Administration Workspace
Loading Internal Translation Measures
Position Translation
Template-Based Override for Measures
Translation Tasks
Upload Custom Translations Task
Remove Custom Translations Task
Other Translation Tasks
Supported Translation Measures
Miscellaneous
Taskflow Components Translation
10
Resource Bundle Customization
Editing Resource Strings
Roles
Editing Process
Application
Bundles
Languages
Resource
Text
Add or Edit
Remove Customization
Settings for the RPASCE UI
Settings for Retail Home
Resource Keywords
11
Informational Utilities
Printing Measure Information
Submitting a Measure Information Task
12
Operational Utilities
Setting Miscellaneous PDS Properties
Submit Online Admin Task for the PDS Property Service
Display the Current Value of the Named PDS Property
Update PDS 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
Print the Specified Rule
Print the Specified Rule Group
Print All the Rules and Rule Groups
Managing Segments Using wbbatch
Managing Workbooks Using wbmgr
13
Planning Data Schema Diagnostic Tool (PDS Explorer)
Interface
Registered Applications
Facts
Fact Data
Dimensions
Levels
Batch Control Tags
Downloads
14
RPASCE Test Automation
Introduction
RPAC in Batch Framework
Writing Test Cases
Example
Output
Schema
RPAC Attributes, Values, and Variables
1. RPAC Structure Tag
1.1 testscript
1.2 testsuite
1.3 testcase
1.4 once
1.5 finalize
1.6 setup
1.7 teardown
2. Application Measure Tags
2.1 assert-application-measure-exists
2.2 assert-application-measure-intx
2.3 assert-application-measure-value-eq
2.4 assert-application-measure-value-ge
2.5 assert-application-measure-value-gt
2.6 assert-application-measure-value-le
2.7 assert-application-measure-value-lt
2.8 assert-application-measure-value-ne
2.9 assert-application-measures-match
2.10 assert-application-popcount-value-eq
2.11 assert-application-popcount-value-ge
2.12 assert-application-popcount-value-gt
2.13 assert-application-popcount-value-le
2.14 assert-application-popcount-value-lt
2.15 assert-application-popcount-value-ne
2.16 set-application-measure
2.17 register-measure
2.18 unregister-measure
2.19 unregister-measures
2.20 get-measure-property
2.21 clear-application-measure-list
2.22 clear-application-measure
2.23 backup-appl-measure
2.24 dump-appl-measure
2.25 load-appl-measure
2.26 restore-all-appl-measure
3. Dimension Tags
3.1 assert-hier-exists
3.2 assert-dimension-contain
3.3 assert-dimension-exists
3.4 assert-dimension-size
4. Directory and File Tags
4.1 assert-directory-does-not-exists
4.2 assert-directory-exists
4.3 assert-directory-is-empty
4.4 assert-directory-structure
4.5 assert-file-contains
4.6 assert-file-does-not-exists
4.7 assert-file-exists
4.8 assert-file-is-empty
4.9 assert-file-is-read-lock
4.10 assert-file-is-write-lock
4.11 compare-file-content
4.12 compare-files
4.13 copy-directory
4.14 copy-file
4.15 create-directory
4.16 create-file
4.17 erase-file
4.18 rename-file
4.19 remove-directory
4.20 read-lock-file
4.21 write-lock-file
4.22 unlock-file
4.23 assert-file-size-eq
4.24 assert-file-size-ge
4.25 assert-file-size-gt
4.26 assert-file-size-le
4.27 assert-file-size-lt
4.28 assert-file-size-ne
5. Sql Query Tags
5.1 assert-sql-query-eq
5.2 assert-sql-query-ge
5.3 assert-sql-query-gt
5.4 assert-sql-query-le
5.5 assert-sql-query-lt
5.6 assert-sql-query-ne
5.7 call-rule-group
5.8 call-special-expression
5.9 dump-database-tables
5.10 execute-bdi-extractor
5.11 execute-bdi-importer
5.12 execute-sql-query
5.13 load-database-tables
5.14 set-database-role
5.15 sql-start-trace
5.16 sql-stop-trace
5.17 truncate-database-tables
6. Workbook Measures Tags
6.1 assert-workbook-measure-exists
6.2 assert-workbook-measure-intx
6.3 assert-workbook-measure-value-eq
6.4 assert-workbook-measure-value-ge
6.5 assert-workbook-measure-value-gt
6.6 assert-workbook-measure-value-le
6.7 assert-workbook-measure-value-lt
6.8 assert-workbook-measure-value-ne
6.9 assert-workbook-measures-match
6.10 assert-workbook-popcount-value-eq
6.11 assert-workbook-popcount-value-ge
6.12 assert-workbook-popcount-value-gt
6.13 assert-workbook-popcount-value-le
6.14 assert-workbook-popcount-value-lt
6.15 assert-workbook-popcount-value-ne
6.16 set-workbook-measure
6.17 edit-workbook-measure
6.18 clear-workbook-measure-list
6.19 clear-workbook-measure
6.20 assert-measure-is-not-protected
6.21 assert-measure-is-protected
7. Workbook Operations Tags
7.1 assert-window-contain-measure
7.2 assert-window-exists
7.3 assert-window-intersection
7.4 assert-window-not-exists
7.5 build
7.6 calc
7.7 close
7.8 commit
7.9 custom-menu
7.10 set-hier-selection
7.11 set-selected
7.12 set-selection
7.13 set-selections
7.14 set-text
7.15 set-tree-selections
7.16 wizard-page-settings
7.17 workbook-operations
7.18 open
7.19 rebuild
7.20 refresh
7.21 delete-informal-position
7.22 update-dpm
7.23 update-informal-positions
7.24 dpmposentry
7.25 dpmposinfo
8. Workbook Execute Expression Tag
8.1 workbook-execute-expression
8.2 rule-debug-log
8.3 rule-debug-start
8.4 rule-debug-stop
9. Processes, Tasks, Environment Variables, and DateTime Tags
9.1 task-log
9.2 task-start
9.3 task-wait
9.4 sleep
9.5 shell
9.6 set-date-format
9.7 set-environment-variable
9.8 rpas-today
9.9 process-stop
9.10 process-wait
9.11 get-unique-file-path
9.12 assert-numeric-value-eq
9.13 assert-numeric-value-ge
9.14 assert-numeric-value-gt
9.15 assert-numeric-value-le
9.16 assert-numeric-value-lt
9.17 assert-numeric-value-ne
9.18 assert-string-value-contains
9.19 assert-string-value-does-not-contain
9.20 assert-string-value-equal
9.21 assert-string-value-not-equal
9.22 if-numeric-value-eq-then-set
9.23 if-numeric-value-ge-then-set
9.24 if-numeric-value-gt-then-set
9.25 if-numeric-value-le-then-set
9.26 if-numeric-value-lt-then-set
9.27 if-numeric-value-ne-then-set
9.28 if-string-value-contains-then-set
9.29 if-string-value-does-not-contain-then-set
9.30 if-string-value-equal-then-set
9.30 if-string-value-not-equal-then-set
10. Misc Tags
10.1 clear-all-measures
10.2 fail
10.3 log
10.4 reset-seq-generator
15
Performance Diagnostic Tool
Overview
Collecting and Managing Performance Metrics
Analyzing Workbook Performance
16
Service Administration
System Configuration
17
RPASCE Health Check Tasks
18
Maintenance Tasks
19
Logging Framework
Log File and Format
Access to Logs
logAggregator Utility
Json Log Format
20
Best Practices
Measure to Fact Mapping and Optimal Fact Grouping
Measure to Fact Mapping
Optimal Fact Grouping
Data Loading
Free Expressions in Batch Control File
A
Appendix: Troubleshooting