Reporting and Analytics
Discussion List
-
How to filter Resource Column in a report based on Logged in User.Summary: Trying to put a filter of logged in User on Resource name in reports. But filter is not working. Using below filter in Resource name Content (required): VALUEOF… -
Chat queue availability reportSummary: Historical report on how much time there was no agent available for a specific queue. Content (required): I'm looking for a historical report on how much time t… -
How to filter on the startdate of first event if a person may have multiple events attended?Summary: Report on only the first event Content (required): I need to have a report which only displays the first event to which a person has been. So I have the contact… -
Is There a More Detailed Database Dictionary?Summary: Is there a more detailed database dictionary for Oracle Service Cloud? Content (required): For example, I am finding that some of the information in the Databas…NDKoze 41 views 1 comment 1 point Most recent by Robert Surujbhan-Oracle Reporting & Analytics for B2C Service -
Find e-mail address in incident threadSummary: How can I make a report with an e-mail address in one column that is used to search in the initial customer thread in another column. With a third column showin…
-
Available Today: Out of the Box Reports for Service Agents and ManagersSummary: Out of the Box Reports for Service Agents and Managers - available today in Oracle Sales. Content (required): Out of the Box Reports for Service Agents and Mana… -
Available Today: Out of the Box Reports for PRM and Channel SalesSummary: Out of the Box Reports for PRM and Channel Sales - available today in Oracle Sales. Content (required): Out of the Box Reports for PRM and Channel Sales - avail…
-
Available Today: Out of the Box Reports for the Sales ExecutiveSummary: Out of the Box Reports for the Sales Executive - available today - in Oracle Sales. Content (required): Out of the Box Reports for the Sales Executive - availab…
-
Available Today: Out of the Box Reports for the Sales ManagerSummary: Out of the Box Reports for the Sales Manager - available today - in Oracle Sales. Content (required): Out of the Box Reports for the Sales Manager - available t…
-
Available Today: Out of the Box Reports for the Sales RepSummary: Out of the Box Reports for the Sales Rep available today in Oracle Sales. Content (required): Out of the Box Reports for the Sales Rep available today in Oracle…
-
Organization Hierarchy ReportingSummary How to Correctly Report the Levels of an Organization's Hiearchy?Content I am trying to create an Organizational Hierarchy report that shows the number of Contac…NDKoze 80 views 4 comments 0 points Most recent by User_2025-02-03-22-07-33-802 Reporting & Analytics for B2C Service
-
Is it possible to customize the service infolets in Analytics section?Summary: Hello, we would like to know if it is possible to customize the service infolets in Analytics section. Also, we would like to check if the data displayed in tho…Eric Serra I Paradis 15 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
Can we trace categories changes in Audit LogSummary: Tracing categories changes in the Audit Log Content (required): As we all know, we can trace the incident transactions through the Audit log. But one of my clie…Vikash Patel 24 views 2 comments 0 points Most recent by Sasi Gudimetta-281012 Reporting & Analytics for B2C Service
-
Help reporting on a button clickSummary: Need help reporting on a button click Content (required): I'm attaching my simple report definition (zipped xml) for when an agent clicks a button in their work…kerry walker 23 views 6 comments 0 points Most recent by kerry walker Reporting & Analytics for B2C Service -
Schedule a Dashboard to be emailedContent Hi All, It doesn't seem that we have the ability to schedule a dashboard to be sent to a group of email recipients, so I'm wondering what solutions you all use t…Mia B 31 views 9 comments 0 points Most recent by User_2025-02-03-22-07-33-802 Reporting & Analytics for B2C Service
-
How to migrate custom data stores in BICC from Dev instance to test instanceSummary: Hello All, We have created few custom data stores in BICC and we used existing VO by deselecting few fields, now we need to migrate these to higher environments…
-
Which table should I use to calculate agent login time?Summary: Do I need to develop a report that calculates the login / logout time and which table is the most correct to use? accountsessionhistory or user_trans.type = 1? …Leonardo Santos 34 views 5 comments 0 points Most recent by User_2025-02-03-22-07-33-802 Reporting & Analytics for B2C Service -
Is it possible to find all the reports with their filter details ?Summary: We need to fetch all the reports in the system that do not have a Date filter in them as we need to then edit those reports . Content (required): Version (inclu…User_2025-02-03-22-07-33-802 33 views 1 comment 0 points Most recent by Anuj Behl Reporting & Analytics for B2C Service -
contacts.any_phone_raw is not returning data when searching for Contact Phone Alt 3Content We have a search report set up that utilizes contacts.any_phone_raw which based on the Data Dictionary should search within any phone number field on the contact…User_2025-07-18-04-45-06-758 18 views 2 comments 1 point Most recent by Lakshay Bhalla Reporting & Analytics for B2C Service
-
how to export all custom lookups defined in application using export managementSummary how to export all custom lookups defined in applicationContent Hi All, Is there any way to export all custom lookups defined in application through export manage…
-
Default Period Prompt to Current Period (ICM BIP Report)Summary: We have an ICM BIP report where we need the "Period" prompt to be defaulted to the current period. We tried using the SQL below, but it does not reflect correct…
-
Why my Logon Reports show duplicate rows?I did a new Logon Report to show start/end by day. But it is running with duplicate rows for each Agent, I would like show one row only. I'm using account_session_histor…Leonardo Santos 43 views 5 comments 0 points Most recent by Kurt Helfrich Reporting & Analytics for B2C Service
-
Show OTBI Graph with no values rather than No Results messageSummary: There are instances when the OTBI bar graphs result in no data results. Instead of showing a "No Results" message, is it possible to show the graph instead? We …User0901 45 views 1 comment 1 point Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Sales
-
"Records" is greyed out on the report, cannot edit even if I have permissionSummary: "Records" option on report design Content (required): Hi friends, I have an old report that I need to edit. I want to edit the records that can be opened from t… -
Duplicate contact email addressesSummary: Looking for downsides to allowing duplicate email addresses Content (required): We've recently come across a few reasons to allow duplicate email addresses for …kerry walker 15 views 2 comments 0 points Most recent by kerry walker Reporting & Analytics for B2C Service
-
Search in Answer Source (Using Custom Script) - Analytics Cookbook RecipeContent Search in Answer Source Using a custom script Author: Bastiaan van der Kooij Independent Oracle Service Cloud Consultant Difficulty rating: (Advanced) Target per…User_2025-02-03-19-30-01-975 154 views 7 comments 10 points Most recent by Ssimpson-Oracle Reporting & Analytics for B2C Service
-
Merged: We invite you to attend a ⭐️ LIVE ⭐️ webinar to deeply understand your Oracle Cloud Applica…This discussion has been merged.Bethany Hubbell 1 view 0 comments 0 points Started by Bethany Hubbell Reporting & Analytics for B2C Service -
How much data is too much dataSummary: We struggle with reports not running due to too much data. We average about 45,000 open incidents a day. Our oldest ticket is year and a half old. We are lookin…Jeff Scrobel 23 views 0 comments 0 points Started by Jeff Scrobel Reporting & Analytics for B2C Service