[PDF] Oracle® Retail Data Warehouse

View - Download Oracle® Retail Data Warehouse

Previous PDF

Next PDF

Oracle

Retail Data Warehouse

User Guide

Release 13.0

April 2008

Oracle® Retail Data Warehouse User Guide, Release 13.0

Copyright © 2008, Oracle. All rights reserved.

Primary Author: Rich Olson

The Programs (which include both the software and documentation) contain proprietary information; they are provided under a license agreement containing restrictions on use and disclosure and are also protected by copyright, patent, and other intellectual and industrial property laws. Reverse engineering, disassembly, or decompilation of the Programs, except to the extent required to obtain interoperability with other independently created software or as specified by law, is prohibited. The information contained in this document is subject to change without notice. If you find any problems in the documentation, please report them to us in writing. This document is not warranted to be error-free. Except as may be expressly permitted in your license agreement for these Programs, no part of these Programs may be reproduced or transmitted in any form or by any means, electronic or mechanical, for any purpose. If the Programs are delivered to the United States Government or anyone licensing or using the Programs on behalf of the United States Government, the following notice is applicable: U.S. GOVERNMENT RIGHTS Programs, software, databases, and related documentation and technical data delivered to U.S. Government customers are "commercial computer software" or "commercial technical data" pursuant to the applicable Federal Acquisition Regulation and agency- specific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of the Programs, including documentation and technical data, shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement, and, to the extent applicable, the additional rights set forth in FAR 52.227-19, Commercial Computer Software - Restricted Rights (June 1987). Oracle Corporation, 500 Oracle Parkway, Redwood City, CA 94065 The Programs are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be the licensee's responsibility to take all appropriate fail-safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and we disclaim liability for any damages caused by such use of the Programs. Oracle, JD Edwards, PeopleSoft, and Siebel are registered trademarks of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. The Programs may provide links to Web sites and access to content, products, and services from third parties. Oracle is not responsible for the availability of, or any content provided on, third- party Web sites. You bear all risks associated with the use of such content. If you choose to purchase any products or services from a third party, the relationship is directly between you and

the third party. Oracle is not responsible for: (a) the quality of third-party products or services; or

(b) fulfilling any of the terms of the agreement with the third party, including delivery of products

or services and warranty obligations related to purchased products or services. Oracle is not responsible for any loss or damage of any sort that you may incur from dealing with any third party. iii

Value-Added Reseller (VAR) Language

(i) the software component known as ACUMATE developed and licensed by Lucent Technologies Inc. of Murray Hill, New Jersey, to Oracle and imbedded in the Oracle Retail Predictive Application Server - Enterprise Engine, Oracle Retail Category Management, Oracle Retail Item Planning, Oracle Retail Merchandise Financial Planning, Oracle Retail Advanced Inventory Planning and Oracle Retail Demand Forecasting applications. (ii) the MicroStrategy Components developed and licensed by MicroStrategy Services Corporation (MicroStrategy) of McLean, Virginia to Oracle and imbedded in the MicroStrategy for Oracle Retail Data Warehouse and MicroStrategy for Oracle Retail Planning & Optimization applications. (iii) the SeeBeyond component developed and licensed by Sun MicroSystems, Inc. (Sun) of Santa Clara, California, to Oracle and imbedded in the Oracle Retail Integration Bus application. (iv) the Wavelink component developed and licensed by Wavelink Corporation (Wavelink) of Kirkland, Washington, to Oracle and imbedded in Oracle Retail Store Inventory Management. (v) the software component known as Crystal Enterprise Professional and/or Crystal Reports Professional licensed by Business Objects Software Limited ("Business Objects") and imbedded in

Oracle Retail Store Inventory Management.

(vi) the software component known as Access Via™ licensed by Access Via of Seattle, Washington, and imbedded in Oracle Retail Signs and Oracle Retail Labels and Tags. (vii) the software component known as Adobe Flex™ licensed by Adobe Systems Incorporated of San Jose, California, and imbedded in Oracle Retail Promotion Planning & Optimization application. (viii) the software component known as Style Report™ developed and licensed by InetSoft Technology Corp. of Piscataway, New Jersey, to Oracle and imbedded in the Oracle Retail Value

Chain Collaboration application.

(ix) the software component known as i-net Crystal-Clear™ developed and licensed by I-NET Software Inc. of Berlin, Germany, to Oracle and imbedded in the Oracle Retail Central Office and

Oracle Retail Back Office applications.

(x) the software component known as WebLogic™ developed and licensed by BEA Systems, Inc. of San Jose, California, to Oracle and imbedded in the Oracle Retail Value Chain Collaboration application. (xi) the software component known as DataBeacon™ developed and licensed by Cognos Incorporated of Ottawa, Ontario, Canada, to Oracle and imbedded in the Oracle Retail Value Chain

Collaboration application.

v

Contents

Preface ........................................................................ Related Documents........................................................................ Customer Support........................................................................ Review Patch Documentation........................................................................ ....................xii Oracle Retail Documentation on the Oracle Technology Network...............................xii

1 Introduction to Oracle Retail Data Warehouse.........................................................1

Decision Support in the Retail Environment.....................................................................

..1

Data Warehousing and Decision Support........................................................................

...1 Data Sources ........................................................................ Oracle Retail Solutions........................................................................ ............................2 Retailer-Specific Interfaces........................................................................ ......................3

Functional Areas That Can Be Added to RDW...........................................................3

Data Granularity........................................................................ ......................................4

Oracle Retail Data Warehouse ........................................................................

......................5

Oracle Business Intelligence Enterprise Edition.................................................................5

RDW Implementation........................................................................ .............................6

Oracle BI Presentation Interface.......................................................................

..............7

Oracle BI Administration Interface ........................................................................

.......8 Supported Languages ........................................................................ .............................9

2 Report Components and Concepts........................................................................

.11 Report Elements........................................................................ Attributes and Dimensions........................................................................ ..........................12 Dimensions and Drilling........................................................................ ..............................12 Formulas ........................................................................ Metric Levels ........................................................................

Time Series Conversion Functions ........................................................................

.............14 RDW Packaged Reports........................................................................ ...............................17

3 RDW Dimensions and Attributes .............................................................................19

Competitor Dimension........................................................................ .................................19 Currency Code Attribute........................................................................ .............................20 Customer Dimension........................................................................ ....................................20 Employee Dimension ........................................................................ ...................................21 Geographic Code Dimension........................................................................ ......................21

Market Organization Dimension........................................................................

................22 vi Market Product Dimension........................................................................ .........................22 Organization Dimension........................................................................ ..............................23 Product Dimension........................................................................ Item Architecture........................................................................ ...................................27

Product Differentiator Dimension........................................................................

..............27 Promotion Dimension........................................................................ ..................................28 Reason Dimension........................................................................ Register Attribute........................................................................ Retail Type Attribute........................................................................ ....................................30

Sales Audit Total Type Attribute........................................................................

................30 Supplier Dimension........................................................................ ......................................30 Tender Type Dimension........................................................................ ...............................31 Time Calendar Dimension........................................................................ ...........................31

4-5-4 Calendar ........................................................................

Gregorian Calendar........................................................................ ...............................31

13-Period Calendar........................................................................

................................32 Time of Day Dimension........................................................................ ...............................33

Transfer From Organization Dimension........................................................................

....34 Transfer Type Attribute ........................................................................ ...............................34 Voucher Age Band Attribute........................................................................ .......................34

Wholesale/Franchise Dimension ........................................................................

...............35 Customer Type Attribute........................................................................ ......................35 Store Type Attribute........................................................................ ..............................35

4 Retail Base and Performance Metrics .....................................................................37

RDW Metrics ........................................................................

Comparable Store Analysis Metrics........................................................................

...........38

Customer Segmentation Metrics........................................................................

.................40 RFMP Analysis........................................................................ Business Metrics........................................................................ .....................................41 In-Store Markdown Metrics ........................................................................ ........................41 Loss Prevention Metrics........................................................................ ...............................42 Over/Short Amounts........................................................................ ............................42 Loss Prevention Voucher........................................................................ ......................42

Loss Prevention Transaction Activity........................................................................

.43 Markdown Metrics ........................................................................

Audience

vii Pack Sales Metrics........................................................................ Prorating of Packs........................................................................ ..................................46 Planning Metrics........................................................................ Plan Sales and Profit........................................................................ ..............................47 Plan Inventory........................................................................ Plan Markups and Markdowns........................................................................ ...........49 Price Metrics ........................................................................ Promotions Metrics........................................................................ Sales and Profit Metrics........................................................................ ................................52 Retail Type........................................................................ Value-Added Tax (VAT)........................................................................ .......................55

Returns, Exchanges, Replacements, and Partials ......................................................55

...................................57 Spatial Analysis Metrics........................................................................ ...............................58 Base Formulas and Metrics........................................................................ ...................58

Profit Per Unit of Allocated Space........................................................................

.......58

Sales Per Unit of Allocated Space........................................................................

........58 Space Allocation Aggregation........................................................................ ..............59 Stock Ledger Metrics........................................................................ ....................................60 Sales and Gross Margin ........................................................................ ........................60

Beginning and Ending Stock Values........................................................................

...60 Stock Turn Retail Value ........................................................................ ........................61 Gross Margin Return per Dollar of Inventory (GMROI)..........................................61 Receipts ........................................................................ Stock Movement Metrics................................................................ ......................................63 Receipts ........................................................................ Return to Vendor (RTV)........................................................................ ........................63 Stock Adjustments........................................................................ .................................64

Gross Margin Return on Inventory (GMROI)............................................................65

Stock Position Metrics........................................................................ ..................................66 Stock on Hand........................................................................ In Transit........................................................................ On Order........................................................................ Store Traffic Metrics........................................................................ ......................................69 Facts and Base Measures........................................................................ .......................69 Conversion Rate........................................................................ .....................................69 Supplier Compliance Metrics........................................................................ ......................70 Supplier Invoice Cost........................................................................ ............................70 Receipts by Supplier........................................................................ ..............................70 Supplier Compliance Rating ........................................................................ ................70 viii

Supplier Contracts and Availability Metrics.....................................................................71

Base Formulas and Metrics........................................................................ ...................72 Balance of Contract........................................................................ ................................72

Commitment Total Units and Value........................................................................

...72 Supplier Performance Metrics........................................................................ .....................72 Primary Supplier........................................................................ ....................................73 Performance Metrics........................................................................ ..............................73 Velocity Metrics........................................................................ Stock Turn........................................................................ Percent Sell-Through........................................................................ .............................75

Wholesale / Franchise Metrics........................................................................

....................76

A Appendix: Joint-Child Attributes ........................................................................

.....79 Item Joint-Child Attributes........................................................................ ..........................79 Deposit Code........................................................................ Electronic Marketing Club........................................................................ ....................80 Food Stampable Indicator........................................................................ .....................80 Full Pallet Item Indicator........................................................................ ......................80

National Brand Comparison Item........................................................................

.......80 New Item Start Date........................................................................ ..............................81 Reorderable Indicator........................................................................ ............................81

Reward Club Eligible Indicator ........................................................................

...........81 Item Type........................................................................ Unauthorized Indicator..................................................................... ............................81

Competitor Pricing Joint-Child Attributes........................................................................

82
Competitor Store Distance and Competitor Store Distance UOM..........................82 Competitor Store Rank........................................................................ ..........................82 Competitor Target Ind ........................................................................ ..........................82

Pricing Joint-Child Attributes ........................................................................

.....................83

B Appendix: Time Series Conversion Functions.......................................................85

Mapping Types for Table-Based Conversions..................................................................85

Time Conversions........................................................................ RDW Time Conversion Levels........................................................................ ....................86 Conversion List ........................................................................ Conversion Mappings........................................................................ ..................................89 Day Level........................................................................ Week Level ........................................................................ Month Level........................................................................ Quarter Level........................................................................ Half-Year Level........................................................................ ......................................94 Year Level ........................................................................

Audience

ix Time Conversions for the RDW 4-5-4, Gregorian, and 13-Period Calendars...............95 Time Conversions for the RDW 4-5-4 Time Calendar..............................................95 Time Conversions for the RDW Gregorian Time Calendar.....................................96 Time Conversions for the RDW 13-Period Time Calendar......................................97

C Appendix: Repository Documentation....................................................................99

xi

Preface

The Oracle Retail Data Warehouse User Guide is a conceptual overview and user reference to the dimensions, attributes, and metrics (measures) of Oracle Retail Data Warehouse (RDW).

Audience

This document is intended for the users and administrators of Oracle Retail Data Warehouse. In particular, it is for business analysts who create and publish RDW reports (requests) using the Oracle Business Intelligence (Oracle BI) user interface to RDW.

Related Documents

For more information, see the following documents in the Oracle Retail Data Warehouse

Release 13.0 documentation set:

Oracle Retail Data Warehouse Data Model

Oracle Retail Data Warehouse Database Installation Guide Oracle Retail Data Warehouse Middle Tier Installation Guide

Oracle Retail Data Warehouse Operations Guide

Oracle Retail Data Warehouse Release Notes

Also see the documentation library for Oracle Business Intelligence Enterprise Edition at this URL: In particular, these documents describe how to use the Oracle Business Intelligence user interface and features to create and publish reports: Oracle Business Intelligence Answers, Delivers, and Interactive Dashboards User Guide (B31767) Oracle Business Intelligence Publisher User's Guide (B40017) See the Oracle Business Intelligence Server Administration Guide (B31770) for information about using Oracle BI administration utilities to create and manage your Oracle BI repository.

Customer Support

https://metalink.oracle.com When contacting Customer Support, please provide the following:

Product version and program/module name

Functional and technical description of the problem (include business impact)

Detailed step-by-step instructions to re-create

Exact error message received

Screen shots of each step you take

xii

Review Patch Documentation

For a base release (".0" release, such as 13.0), Oracle Retail strongly recommends that you read all patch documentation before you begin installation procedures. Patch documentation can contain critical information related to the base release, based on new information and code changes that have been made since the base release. Oracle Retail Documentation on the Oracle Technology Network In addition to being packaged with each product release (on the base or patch level), all Oracle Retail documentation is available on the following Web site: Documentation should be available on this Web site within a month after a product release. Note that documentation is always available with the packaged code on the release date.

Conventions

Navigate: This is a navigate statement. It tells you how to get to the start of the procedure and ends with a screen shot of the starting point and the statement "the Window Name window opens." Note: This is a note. It is used to call out information that is important, but not necessarily part of the procedure.

This is a code sample

It is used to display examples of code

A hyperlink appears like this.

User Guide 1

1

Introduction to Oracle Retail Data

Warehouse

This chapter introduces the role of decision support and data warehousing in a retail environment. It briefly describes the implementation of Oracle Retail Data Warehouse (RDW) and its data sources, and the RDW user interface through Oracle Business

Intelligence Enterprise Edition (Oracle BI).

Decision Support in the Retail Environment

Decision support allows all users in a retail organization to answer questions about the business, for example: How do actual sales this period compare to the current plan? What is the retail value of inventory on hand, and how does it compare to the same period last year? How do our prices compare to our competitors' prices? What are the best-selling items in a category or department?

How effective was the last promotion?

The answers to these questions and others are embedded in the enormous volume of sales and returns, price changes, receipts, and other transactions generated by your retail organization. These transactions are the raw material for decision support. Transaction- level data must be converted to information to support decisions in a retail enterprise.

Data Warehousing and Decision Support

The data warehouse is the central repository for the data that is required for decision support in a retail environment. The applications and components that make up the data warehouse perform these functions: They organize and standardize data so that it can be stored in a consistent format in the data warehouse. They load data to a relational database management system that is specially constructed for decision support. They provide analytical tools and interfaces necessary to deliver information throughout the retail organization. Online transaction processing (OLTP) applications, such as the Oracle Retail Merchandising System (RMS), are designed for efficient record-keeping. They generally hold only a small amount of historical information. The data warehouse, on the other hand, consists entirely of historical data organized by business area. (Collections of data organized to support particular business areas are sometimes called data marts.) These business areas consist of a relatively small number of very large tables.quotesdbs_dbs17.pdfusesText_23

[PDF] adobe data warehouse pending

[PDF] adobe data warehouse request

[PDF] adobe data warehouse segments

[PDF] adobe data warehouse sftp

[PDF] adobe data workbench download

[PDF] adobe data workbench logo

[PDF] adobe data workbench review

[PDF] adobe data workbench training

[PDF] adobe data workbench tutorial

[PDF] adobe data workbench use cases

[PDF] adobe data workbench wiki

[PDF] adobe database breach

[PDF] adobe database design

[PDF] adobe database leak

[PDF] adobe database leak download