| Yazdır Çevrimiçi Yardımın PDF Sürümünü Aç

##### Events 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 report on event and related dimensions, such as account, account event, date, invitees, lead, lead event, opportunity, opportunity event, owned by user, product category, and product. ### Relationship Type One to Many ### Dimensions This subject area has the following dimensions: Account Account Event Date Event Invitees Lead Lead Event Opportunity Opportunity Event Owned By User Product Product Category ### Metrics The complete list of metrics for this subject area is as follows: Event Metrics Number (#) of Accounts for Event Number (#) of Events Number (#) of Invitees (Definition: Number of active invitees not having a deleted status.) Number (#) of Leads for Event Number (#) of Opportunities for Event Budget Surplus/Shortfall (Definition: The difference between the event budget and the event cost.) Event Budget The Event Budget metric comes from the dimension. When only the Event dimension is used the metric is the sum of the dimension field value. However, when other dimensions (particularly invitee) are used, the metric is calculated as the budget amount divided by number of invitees. Event Cost (Definition: The per attendee cost of an event, which is the total cost of the activities for all active attendees associated with a completed event, divided by the number of attendees.) ### Usage Notes The Event dimension includes a Book hierarchy, which enables you to analyze metrics and related attributes at any level. Number (#) of Accounts for Event returns the number of accounts that are associated with events that have invitees. Number (#) of Leads for Event returns the number of leads that are associated with events that have invitees. Number (#) of Opportunities for Event returns the number of opportunities that are associated with events that have invitees. #### Events with No Invitees Events that have zero invitees are excluded from reports, except for one special case. The only way to have a zero invitee event appear in a report is to use the Event dimension only (do not add a second dimension) and do not include any metrics. Conversely, if you construct a report that uses dimensions other than the Events dimension (for example, Lead and Invitees), the rows in the report are the intersection of the Events dimension and the selected dimensions. The only rows in the report are rows that exist in all three dimensions.

Ağustos 2022'da Yayımlandı | Copyright © 2005, 2022, Oracle ve/veya Oracle'a bağlı kuruluşlar. Legal Notices.