Reporting and Analytics
Discussion List
-
Created and Closed/Resolved in the same reportSummary Creating a report (not a dashboard) with incidents created and closed/resolved in a period of timeContent Hello, I am trying to create a report that will include…User_2025-02-06-05-46-29-624 38 views 11 comments 0 points Most recent by Ajay Yadav-140866 Reporting & Analytics for B2C Service -
Aggregate functions last() is not working as expectedSummary last() should return last row of the data set, but it is fetching all the records.Content Objects : a) Incident b) CO.AuditLog (Custom Object). Joining Relations…Manish S. Dixit 53 views 3 comments 1 point Most recent by Levi Dyckman-Support-Oracle Reporting & Analytics for B2C Service -
Report with link to attachments.Summary How do I get a report with a link to attachments for each incident?Content Hello, I have a report that shows the incident information and the attachments associa…User_2025-10-31-01-08-51-703 141 views 9 comments 0 points Most recent by Alison-UniSA Reporting & Analytics for B2C Service
-
How to trigger an action on association of Product with Product GroupSummary Hi, I want to call Rest API which will send the Product Group Id to other application when Product is associated with Product Group through Manage Product Group …
-
Frequently Asked Questions on User System Usage SASummary This document will provide information on many questions related to User System Usage SContent Hi All, We have consolidated a list of How To questions asked on U…Dimple-Nagesh-Support-Oracle 112 views 1 comment 5 points Most recent by Syed Misbauddin-Support-Oracle Reporting & Analytics for Sales -
Incident SizeSummary How to get size of incidents?Content Hi, Is there a way to return the total size of an incident with and without file attachments through reporting? A simple rep…User_2025-02-03-21-58-25-969 38 views 2 comments 0 points Most recent by User_2025-02-03-21-58-25-969 Reporting & Analytics for B2C Service
-
Have a dynamic column headingSummary We would like to have a column heading as current month, next month etc.Content Hi Is it possible to have a column heading that displays the current month, next …Cyrille Saulnier-Oracle 47 views 6 comments 0 points Most recent by User_2025-02-01-07-27-35-188 Reporting & Analytics for Sales -
Sales – Best Practices to Track CX Sales User Adoption, 24 June 2020, 8 a.m PT - Submit QuestionsContent Submit your questions for the Sales – Best Practices to Track CX Sales User Adoption session to have them answered during the live event. Post your questions by … -
Passing filter value from one to anotherSummary Passing filter value from one to anotherContent There are 2 filters one for primary branch code and another for secondary branch code. Customer want to show sing…User_2025-02-03-16-53-11-440 31 views 2 comments 0 points Most recent by User_2025-02-03-16-53-11-440 Reporting & Analytics for B2C Service
-
Ability to add Password protection to PDF output of Bursting JobContent Hello Everyone,Do we have an Ability to add Password protection to PDF output of Bursting Job in BIP?Use case: Each report output should be password protected by…Shivakumar Ayyanagowdar-Oracle 163 views 3 comments 2 points Most recent by Shivakumar Ayyanagowdar-Oracle Reporting & Analytics for Sales -
Disposition of Incident when Survey went outSummary What was the disposition of the incident when the survey went out?Content I am trying to find the disposition of an incident at the moment the survey went out. I…User_2025-02-01-08-26-30-444 30 views 0 comments 0 points Most recent by User_2025-02-01-08-26-30-444 Reporting & Analytics for B2C Service
-
Contact custom records - display only record with latest date or just one if date blankSummary Return single latest customer record for a contactContent Our contacts have custom records in eg. myTable. They may have none, a single, or multiple linked recor… -
Time in statusContent For a given incident ID - what is the easiest way to show how long it has spent in each status Not status type - each statusKing Jack 28 views 2 comments 1 point Most recent by User_2025-02-03-22-07-33-802 Reporting & Analytics for B2C Service -
Adding a Wildcard function to a Report Definition FormulaSummary I'm wanting to use an if statement in a report to search the subject title for a key word such as 'Accepted' and to return a custom value for this. Is it possibl…User_2025-02-05-15-36-42-527 53 views 2 comments 0 points Most recent by Sasi G Reporting & Analytics for B2C Service
-
Add the body of the ticket in a reportSummary I want to add the text-body of the ticket in a reportContent Hello All, I'm trying to create a report for all the tickets created in the last year that will have…Jenica Dracea 36 views 5 comments 0 points Most recent by User_2025-02-01-08-17-38-818 Reporting & Analytics for B2C Service
-
Dashboard prompt shows Deleted records InformationSummary How to avoid deleted records information in dashboard promptContent Hi, I have created an OBIEE report where as deleted records available in dashboard prompt not… -
Phone search field with or without hyphensContent Many of our contact phone number have hyphens and more do not. I cannot find a solution for agent to search for a contact by phone number without them needing to…User_2025-02-03-19-05-39-651 50 views 4 comments 0 points Most recent by InSinkErator Reporting & Analytics for B2C Service
-
Incidents report with Answers SummarySummary Creating a report joinning two tables with no common fieldsContent Hello! I can´t find a way to add the title of an answer (answers.summary) into the incident's …User_2025-02-06-21-26-19-557 32 views 6 comments 0 points Most recent by User_2025-02-06-21-26-19-557 Reporting & Analytics for B2C Service
-
Masking functionality in ReportsContent Masking functionality in Reports Do we have any functions in OTBI/OBIEE or in BI Publisher/Templates/XSL functions to perform a masking functionality for some cu…Shivakumar Ayyanagowdar-Oracle 61 views 7 comments 1 point Most recent by Karina Ogata Reporting & Analytics for Sales
-
column header is randomly ordered in the csv output for BIP reportSummary BIP reportContent Hi, I posted this a while ago. I wonder if there is a change on 20B. Here is the issue detail, I created a BIP data model with SQL (e.g. select… -
Create Infolet through BI analysis to get PO count created for the daySummary Need to create an analysis to get today's PO created count based on userContent I created a analysis to get the buyer wise PO count. But it gives the as at date …
-
Returning More than 10k Records on Scheduled ReportContent All, We have a report that runs every night that displays new records created in one of our custom objects in the past 24hrs. This report emails itself to a hand… -
Difference between ProductGroupItemId ,ProductGroupId, ItemCatalogGroupid columnsSummary Difference between ProductGroupItemId ,ProductGroupId, ItemCatalogGroupid columnsContent Hi I have exported ProductGroupItem data and Product data from export ma…
-
Emails Received - Exclude Client Response to Auto Reply and Thank You ResponsesSummary Exclude Client Responses to Auto Replies and "thank you" responses to solved incidentsContent I am trying to update the Emails Received report to count the numbe…User_2025-02-07-10-02-12-918 35 views 0 comments 0 points Most recent by User_2025-02-07-10-02-12-918 Reporting & Analytics for B2C Service
-
Setting up multiple reporting schedules for different time periods within the same day.Summary Unable to change VRL_HARD limit, needing a workaround.Content Hi, I need to craft several reporting workarounds to report on previous days data via scheduled run…User_2025-02-05-08-03-16-850 22 views 6 comments 1 point Most recent by Tushar G Reporting & Analytics for B2C Service
-
Events at same second sorting incorrectly. Any way to go smaller than seconds in date_format?Content Hi, I've found when reporting on the chat_events table & sorting output by chat_events.created that two posts with the same second can be shown out of order. The…User_2025-02-03-20-01-45-901 18 views 2 comments 0 points Most recent by User_2025-02-03-20-01-45-901 Reporting & Analytics for B2C Service
-
Forward reports using non-default mailboxSummary Looking for a way to optionally forward analytics reports from a mailbox other than the default for that interfaceContent Being able to send specific types of re…Jared Terry 34 views 1 comment 1 point Most recent by User_2025-02-01-08-46-19-550 Reporting & Analytics for B2C Service -
Catch/close "redundant" incidents that solve themselves?Summary Any ideas to recognize Incidents after customer reports issue is resolved?Content Hi All - in ecommerce, a large source of customer incidents is "Where's my orde… -
Ship to Org LOV not returningSummary I am able to run a report from the Procure to Pay Real Time subject area and the column returns Organization Name, but the same column in the parameter does not …Ari 34 views 2 comments 0 points Most recent by Alexandra Andrei-73074 Reporting and Analytics for SCM
-
Emailed Report ErrorSummary Scheduled report sending Excel opens with warningContent Hi all, We have a really simple report that is scheduled to run once daily. The report contains only 3 c…