Print      Open PDF Version of Online Help


Previous Topic

Next Topic

Book Hierarchy Support in Analytics

In many subject areas, one or more of the dimensions includes a Book hierarchy. In dimensions where the Book hierarchy is supported, you can analyze metrics and related attributes at any level of the book hierarchy. The maximum number of hierarchy levels that is supported for Analytics is nine, that is, eight sublevel books and the top-level book.

The following table lists the dimensions that include the Book hierarchy in the historical analytics subject areas.

Historical Analytics Subject Area

Dimensions with Book Hierarchy

Account Addresses

Account

Account and Competitor History

Account, Campaign

Account and Partner History

Account, Campaign

Account and Related Account History

Account, Campaign

Account Contact History

Account, Contact

Account Hierarchy

None

Account History

Account, Campaign

Account Team History

Account

Activity History

Account, Activity, Campaign, Contact, Lead, Opportunity, Service Request

Advanced Custom Objects History

Account, Activity, Campaign, Contact, Lead, Opportunity, Service Request

Asset History

Account, Asset, Opportunity

Call Activity History

Account, Campaign, Contact, Opportunity

Campaign History

Campaign

Campaign Response History

Account, Campaign

Contact Addresses

Contact

Contact History

Account, Campaign, Contact

Contact Interests History

Contact

Contact Revenue History

Contact

Contact Team History

Account, Contact

Deal Registration History

Associated Contact (based on Contact), Associated Opportunity (based on Opportunity)

Deal Registration Product Revenue History

Associated Opportunity (based on Opportunity)

Dealer History

None

Event History

Account, Event, Lead, Opportunity

Household History

Contact

Lead History

Account, Campaign, Contact, Lead, Opportunity

Lead Team History

Account, Lead

MDF Request History

Campaign

Opportunity and Competitor History

Account, Campaign, Opportunity, Primary Contact (based on Contact)

Opportunity and Partner History

Account, Campaign, Opportunity, Primary Contact (based on Contact)

Opportunity Contact History

Contact, Opportunity

Opportunity History

Account, Campaign, Opportunity, Primary Contact (based on Contact)

Opportunity Product Revenue History

Account, Campaign, Opportunity, Primary Contact (based on Contact)

Opportunity Team History

Account, Opportunity

Partner History

None

Personalized Content Delivery History

Account, Activity, Contact

Pipeline History

Account, Opportunity

Portfolio History

Contact, Institution (based on Account)

Product History

Account, Opportunity

Quote History

Account, Opportunity

Sales Stage History

Account, Opportunity

Service Request History

Account, Asset, Contact, Opportunity, Service Request

Service Request Team History

Account, Service Request

Shared Activity History

Account, Activity, Contact

Shared Address History

Account, Contact

Solution History

Service Request

Special Pricing Product History

Opportunity

Usage Tracking Analysis

None

The following table lists the dimensions that include the Book hierarchy in the real-time reporting subject areas.

Real-Time Reporting Subject Area

Dimensions with Book Hierarchy

Account Contacts

Account, Contact

Account Revenues

Account, Campaign

Account Team

Account

Accounts

Account, Campaign

Accounts and Competitors

Account, Campaign

Accounts and Partners

Account, Campaign

Accounts and Related Accounts

Account, Campaign

Activities

Account, Activity, Campaign, Contact, Lead, Opportunity, Service Request

Advanced Custom Objects

Account, Activity, Campaign, Contact, Lead, Opportunity, Service Request

Assessments

Activity, Lead, Opportunity, Service Request

Assets

Account, Asset, Opportunity

Books

Book

Business Plans

Activity, Book, Lead, Opportunity, Service Request

Campaigns

Campaign

Contact Relationships

Account, Contact

Contact Team

Account, Contact

Contacts

Account, Campaign, Contact

Custom Objects and Accounts

Account, Campaign

Custom Objects and Contacts

Account, Campaign, Contact

Custom Objects and Opportunities

Account, Campaign, Opportunity, Primary Contact (based on Contact)

Custom Objects and Service Requests

Account, Contact, Service Request

Custom Objects

Account, Activity, Campaign, Contact, Lead, Opportunity, Service Request

Events

Account, Event, Invitees (based on Contact), Lead, Opportunity

Forecasts

Account, Book, Contact, Opportunity

Households

Contact

Lead Team

Account, Lead

Leads

Account, Campaign, Contact, Lead, Opportunity

Master Audit Trail

None

Opportunities

Account, Campaign, Opportunity, Primary Contact (based on Contact)

Opportunities and Competitors

Account, Campaign, Opportunity, Primary Contact (based on Contact)

Opportunities and Partners

Account, Campaign, Opportunity, Primary Contact (based on Contact)

Opportunity Contacts

Contact, Opportunity

Opportunity Product Revenues

Account, Campaign, Opportunity, Primary Contact (based on Contact)

Opportunity Team

Account, Opportunity

Orders

Account, Contact, Opportunity

Partners

None

Personalized Content Delivery

Activity

Quotes

Account, Opportunity

Service Request Team

Account, Service Request

Service Requests

Account, Asset, Contact, Opportunity, Service Request

Shared Activities

Account, Activity, Contact

Solutions

Service Request

Special Pricing Products

End Customer (based on Account), Opportunity

Vehicles

Account, Contact


Published 6/21/2021 Copyright © 2005, 2021, Oracle and/or its affiliates. Legal Notices.