Print      Open PDF Version of Online Help


Previous Topic

Next Topic

Orders Real-Time Reporting Subject Area

Availability

This subject area is available in all editions of Oracle CRM On Demand.

Business Purpose

Use this subject area to analyze orders by account, contact, date, opportunity, owner, and product dimensions.

Relationship Type

Simple

Dimensions

This subject area has the following dimensions:

  • Account
  • Contact
  • Date
  • Opportunity
  • Order
  • Owned By User
  • Product

Metrics

The complete list of metrics for this subject area is as follows:

  • Number (#) of Orders
  • Order Items Quantity

Usage Notes

This subject area has multiple dimensions, but you must take care not to mix dimensions indiscriminately. Not all combinations of dimensions and metrics yield useful results.

  • The metric ‘Number (#) of Orders’ applies only to the Order dimension which can be rolled up by direct relationship (Account, Contact, Date, Opportunity, and Owner dimensions) but not by the Product dimension, because there is no direct relationship between the Product and Order dimensions.
  • The Product dimension is only associated with Order Item, you can still report Product with Order details through the Order dimension.


Published 7/3/2018 Copyright © 2005, 2018, Oracle. All rights reserved. Legal Notices.