Go to primary content
Oracle® Retail Insights Cloud Service Suite Implementation Guide
Release 17.0.004
F10061-01
Next
Contents
Title and Copyright Information
Send Us Your Comments
Preface
Audience
Documentation Accessibility
Customer Support
Review Patch Documentation
Improved Process for Oracle Retail Documentation Corrections
Oracle Retail Documentation on the Oracle Technology Network
Conventions
1
Introduction
Business Intelligence and Retail Insights
2
Setup and Configuration
Sizing Information
Factors to Consider
Data Seeding of Positional Facts
Data Migration from a Legacy Data Warehouse System
Reporting Scenarios
Data Initial Load from RDE
Inventory Position Initial Loading
Pricing Initial Loading
Net Cost Initial Loading
Base Cost Initial Loading
Competitor Pricing Initial Loading
Unavailable Inventory Initial Loading
Rendering Item Images, Item Attribute Images, Product Hierarchy Image
3
Internationalization
Translation
Multi-Language Setup
Scenario 1
Data Scenario 1a
Data Scenario 1b
Scenario 2
Data Scenario 2a
Scenario 3
4
Compression and Partitioning
Overview of Compression
What Compression Does
Mechanics of Compression
Compressed Tables and 'CURRENT' Tables
Coping with Slowly Changing Dimension Type 2
Fact Close Program (factcloseplp.ksh)
Fact Open Program (factopenplp.ksh)
Oracle Table Compression
Overview of Partitioning Strategies
Implementing Retail Insights Partitioning
Setup and Maintenance for Partitioning Retail Insights Compressed Inventory Table
Implementing Partitioning for Compressed Inventory Table
Partitioning Automation Implementation
Partitioning Automation Operation
How Oracle Implements Partitions
Summary
5
Performance
Key Factors in Performance
Purging and Archiving Strategy
Flexible Aggregates
ETL Programs Performance
Setting ETL Program Multi-threading
ODI Configuration
ETL Batch Scheduling
Additional Considerations
Report Design
Additional Factors
Partitioning Strategy
Data Base Configuration
Adequate Hardware Resources
Leading Practices
Customizations
ODI Best Practices
Oracle BI EE Best Practices
Batch Schedule Best Practices
Automation
Recoverability
Retail Insights Loading Batch Execution Catch-Up
High Availability
Batch Efficiency
Aggregates List
6
Retail Insights Aggregation Framework
Overview of Retail Insights Aggregation Framework
Aggregation Framework Initial Setup and Daily Execution
Importing ODI Components for Aggregation Framework
Importing Aggregation Framework Shell script
Initial Aggregation Framework Setup
Aggregation Framework Verification
Aggregation Framework Configuration
Creating Customized Aggregation Table
Configuring Framework in W_RTL_AGGREGATION_DAILY_TMP
Populating the Customized Aggregation Table
Batch Process
Batch Status Control
Batch Logging
Aggregation Framework Data Flow
7
Retail Insights Universal Adapter
Overview of Retail Insights Universal Adapter Framework
Benefits
Universal Adapter Installation and Configuration
Universal Adapter Execution
8
Merchandise Financial Planning Configuration
Modify the .rpd File
9
Dynamic Planning Configuration
Configure Planning Levels
Create a Wallet
Run PlanningConfigurationScript.sh
Database Mode
File Mode (f)
PlanningConfigurationScript.sh Script
Custom Name and Custom Description for Planning Flex Columns
Custom Name and Custom Description Format
10
Enabling or Disabling LTS
Enable or Disable LTS
Create a Wallet
Run the StatusConfiguration.script
StatusConfigurationScript.sh Script
11
Store Inventory Management Integration
12
Frequently Asked Questions