To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting & Analytics for B2C Service
Discussion List
-
R13.19A OTBI Direct Database Query Privilege ChangeSummary In R13.19A OTBI direct database query has been disabled by default. To prevent reports generating system errors, BI Administrator can modify BI privileges to rev… -
How to export archived incidents programmatically?Content Hi, there are 3 million archived incidents in the site and we need only some of them. Some could be purged, some not. But the purge setting will delete all of th… -
Report suppliersContent Can someone help me ? All our suppliers are in oracle service cloud, but now i have to make a report with all our supplier and the money that we spend on custome…
-
REPORT_ERROR_EXCEEDS_MAX_JOIN_SIZE despite report running quicklyContent Hi, Definition as per the attached. When I run the report in the console, it runs quickly and brings back about 300 rows. Prior to the recent 18D upgrade, callin… -
Formula to pull previous day solved when date filter is broader rangeSummary Pulling all open statuses while only pulling solved for the previous day or week, month, etc.Content I am pulling all open status incidents based on date filter …User_2025-02-01-08-49-49-892 39 views 7 comments 0 points Most recent by User_2025-02-01-08-49-49-892 -
Report Not Displaying all Community Questions or CommentsSummary Report Not Displaying all Community Questions or CommentsContent We have a report that displayed the basic Community information (see attached) that had been wor…
-
How can I get the report id of a reportSummary Can I use the custom scripts to get the report_id?Content I created an AddIn and would like to get the report ID to use it to refresh the report after running a …User_2025-07-18-03-19-20-600 61 views 6 comments 3 points Most recent by User_2025-07-18-03-19-20-600
-
How to Display the Min Login for the Max DaySummary I am trying to create a report column that displays the Min Time for the Max Date?Content I am trying to create a Staff Account Login report that will show the A… -
Report Scheduling Not Working With Custom ScriptContent Hi, I need to run cron job from OSvC for particular interval of time. I created one custom report and wrote my custom code in custom script. Initialization Tab p…User_2025-02-04-06-31-46-728 100 views 13 comments 0 points Most recent by Sebastiaan Draaisma-122509
-
How to set the default output formats for reportsContent We have created the reports through the BIP and for each and every report there are some default output formats ara predefined if my required output format is no… -
Report on incident rules that have been triggeredContent Is there a report or has anyone built a report based on a specific incident rule to see how often it has been triggered? Ideally, I'd like to have the report wor…
-
How to count Number of incidents Created by Service mailbox and Ask a questionSummary How to count Number of incidents Created by Service mailbox and Ask a questionContent i created a report to count how many incidents Created, Edited, Solved by a… -
Rollup Totals on Rollup HeaderContent Hi folks, I have a report with a number of columns being totaled/avg'd via rollup. The Totals show at the bottom of each rollup when it is expanded. However, I a…
-
Customer entry thread-ReportsContent Hi All, Can we add the customer entry thread in reports level?I have searched in all the incident related tables, I cant see any related columns. Could any one h…
-
How to do Scheduled Job for custom scripts ?Content Hi All, I need to run custom scripts automatically from File manager OSvC with some particular time interval. How can I suppose to run those custom scripts with …User_2025-02-03-17-48-20-813 116 views 5 comments 0 points Most recent by User_2025-02-04-06-31-46-728
-
search for phone number in ph_mobile with our without leading 0Content Hi, Currently we have the challenge to find a mobile phone number, that is maintained sometimes with and sometimes without leading 0 (yes I know, that should not…
-
Export a report directly to a FTP siteContent Is it possible to schedule a report to be exported directly to a FTP site? Would it be possible to have a report automatically exported to a specified network fo… -
Incident last updated by and last status change byContent Hi, Happy new year! I have a report which lists incidents. I want to show who last updated it and who did the last status change. They can be the same person at …
-
Oldie Moldy - Analytics Cookbook RecipeContent Oldie Moldy Identifying Holes in Your Process and/or Overloaded Teams Author: Luuk Schalk Difficulty rating: (Intermediate) Target persona: Managers / Team Leade… -
Consolidated Dashboard - Analytics Cookbook RecipeContent Consolidated Dashboard Rolling up various KPI metrics in a common view Author: Mehrzad Kootar Difficulty rating: (Intermediate) Target persona: Managers, Supervi… -
Extract the middle section of thread noteContent Hi, I need to extract the middle-part of thread notes for incidents relating to a given product. The format of the note is consistent, but the middle part may so…User_2025-02-03-17-31-49-785 53 views 12 comments 0 points Most recent by Sebastiaan Draaisma-122509
-
Dynamic Text FieldContent How do you add a dynamic text field to a report such as Record Count. I created a text field in the footer and used the following text 'Record Count: {NumberOfRe…
-
Sum of integers in report column out of integer rangeSummary Sum of integers in report column out of integer rangeContent Hi, I'm working on a report where I need to sum an integer field using 'sum' function and it is unab…PavanSatishKumar Annavarapu-Oracle 44 views 4 comments 0 points Most recent by Sebastiaan Draaisma-122509
-
Create CX reports to display on tabletsSummary Tips on creating reports so that they display correctly on tablets as well as laptops/desktopsContent Does anyone have any tips on creating reports so they are u…
-
Using Score as a variableSummary Using Score as a variableContent Good day, and Happy New Year! We’ve recently run into an issue with a survey report we’ve had running for a few years. Its set u… -
Help with an AlertSummary Alert for number of emails routed to a QueueContent Hi, Can anyone maybe help me with setting up an alert? I have a simple report showing incidents that arrived …
-
Is there a way to add the Report ID (AcId) to the title of a report?Summary We occasionally need to know the report ID of the report for our scheduled reports and would like to add this to the report title or somewhere in the reportConte…
-
Exclude weekends from the create date and closed dateSummary Need to exclude the weekends while calculating he date differenceContent Hi Team, I am struggling to calculate the time difference between incident creation and …
-
Report Export to Excel formatting issue.Summary Preset Report formatting is not working when reports export to Excel, but only for certain users.Content I am having an issue with getting Reports to keep the pr…
-
Count the number of customers who make chat dailyContent Hi, Everyone I have a problem, now our business wants to know how many customers have launched chat every day, we want to count the number of people who launch c…