Working with Delivered OBIEE Dashboards for the Supply Chain Management (SCM) Warehouse

This chapter provides prerequisites, an overview of delivered OBIEE dashboards for the SCM Warehouse, and discusses:

Click to jump to parent topicPrerequisites

Before you use dashboards for the SCM Warehouse, you must implement:

Click to jump to parent topicUnderstanding Dashboards for the SCM Warehouse

The prebuilt dashboard and reports packaged for the SCM Warehouse help track procurement operations performance and analyze spending by commodity and supplier to discover ways to decrease costs and cycle times, and increase working capital.

PeopleSoft provides dashboards that map to the following SCM Warehouse data marts:

Click to jump to top of pageClick to jump to parent topicDelivered Security Groups

This list contains the financials-oriented Oracle BI Server and Oracle Presentation Catalog security groups provided for the SCM Warehouse:

Click to jump to parent topicUsing the Procurement Page

Access the Procurement page (Dashboards, SCM Reports, SCM: Procurement, Procurement).

Usage

Reports

Dashboard Prompt

Provides you with an overview of supplier on-time performance by vendor PO shipments received versus expected delivery dates.

The Procurement page includes the Supplier On-Time Performance report.

Use the Procurement dashboard prompt to filter dashboard results by:

  • PO Business Unit

  • Buyer ID

  • Supplier SetID

  • Supplier ID

Click to jump to top of pageClick to jump to parent topicSupplier On-Time Performance Report

Access the Supplier On-Time Performance report, which provides insight into the percentage and actual number of vendor shipments that are on time, early, and late for all of the items within a period.

The pie chart shows the percentages of shipments to date that are early, late, and on time. Click a pie segment or a value within the table to view the Supplier On-Time Performance Drill report, which provides details of your shipments, including the items, ship to location, receipt date, and due date.

The following table lists the columns used in the Supplier On-time Performance report.

Report Column Name

Report Column Origin

Record / Field

Delivery Status

D_DLVRY_STATUS / DLVRY_STATUS_SD

PO Identifier

F_PO_SHIP_RCPT / PO_ID

Item ID

D_INV_ITEM / INV_ITEM_ID

Item Description

D_INV_ITEM / ITEM_LD

Ship to Location

F_PO_SHIP_RCPT / SHIP_TO_LOC

PO Receipt Date

F_PO_SHIP_RCPT / PO_RCPT_DT

PO Due Date

F_PO_SHIP_RCPT / PO_DUE_DT

Receipt Line

F_PO_SHIP_RCPT / RCPT_LINE

Receipts

F_PO_SHIP_RCP

(Value is derived from row count)

Click to jump to parent topicUsing the Spend Page

Access the Spend page (Dashboards, SCM Reports, SCM: Spend, Spend).

Usage

Reports

Dashboard Prompt

Provides an overview of spending by commodity, supplier and organization.

This dashboard is comprised of the following reports:

  • Commodity Spend Analysis report

  • Supplier Spend Analysis report

  • Organization Spend Analysis report

Use the Spend dashboard prompt to filter dashboard results by:

  • Buyer

  • Invoice Date (this filter requires that you specify a time range using the two date prompts)

Click to jump to top of pageClick to jump to parent topicCommodity Spend Analysis Report

Access the Commodity Spend Analysis report, which provides you with information about the goods and services your organization has purchased, including Total Commodity Spend, Percent of Total, and Invoice Count measures.

The pie chart displays total commodity spend data grouped by UNSPSC Segment, which can be toggled using the UNSPSC Segment prompt.

You can click on a pie slice to drill down to individual segment-level data.

Click to jump to top of pageClick to jump to parent topicSupplier Spend Analysis Report

Access the Supplier Spend Analysis report, which provides you with information about the suppliers your organization uses to purchase goods and services, and includes measures such as Total Supplier Spend, Percent of Total, and Buyer Count.

The pie chart displays total supplier spend data grouped by Remit to Supplier, which can be toggled using the Remit to Supplier prompt.

You can click on a pie slice to drill down to individual supplier-level data.

Click to jump to top of pageClick to jump to parent topicOrganization Spend Analysis Report

Access the Organization Spend Analysis report, which provides total expenditure information for goods and services for your organization.

The pie chart displays total organization spend data grouped by Performance Business Unit, which can be toggled using the Performance Business Unit ID prompt.

You can click on a pie slice to drill down to individual business unit level data.