Reporting and Analytics
Discussion List
-
Initial Resolution Time calculation Excluding 'Waiting' status timeContent Hi Experts, We have one requirement where we need to calculate Resolution time i.e., total Initial resolution time for an incident. i.e. from the Incident Creati…User_2025-09-05-00-11-37-622 51 views 1 comment 2 points Most recent by User_2025-02-10-10-44-44-497 Reporting & Analytics for B2C Service -
How we can display the forecast vs quota by the quantity not by the amountContent Need to display the graph by quantity -
Send report to FTP serverContent Can we automate BI report to be sent to FTP server? Using Oracle Sales cloud version 21A Use case: We need few reports created using analysis or BI publisher to …User_2025-02-04-10-48-17-393 61 views 2 comments 0 points Most recent by Very Nice Name Reporting & Analytics for Sales -
Custom HRHD Fields in OTBIContent Hello, We have some custom fields we created for HRHD most of which show in OTBI. We have two fields for Primary contact BU and Person Number which are groovy fo…User_2025-01-31-00-25-12-234 43 views 4 comments 1 point Most recent by User_2025-01-31-00-25-12-234 Fusion Service
-
ReportsContent Hi All, Can we implement the below reports in Service Cloud? * Report to see how many incidents have been closed and then re-opened? * Report to see how many tim…User_2025-02-10-15-50-53-070 27 views 2 comments 0 points Most recent by User_2025-02-10-15-50-53-070 Reporting & Analytics for B2C Service
-
Skipping a row to be displayed when having no value (report custom script)Summary I want to prevent showing records having no products and categories assigned in answer reportContent Hi there, I have question about a report in which I want to … -
Single-line summary of mailings by contact?Content I've combed the Analytics thread and Outreach reports, but can't seem to find what I imagine ought to be a pretty basic report we are very interested in. The clo…Christos S. 8 views 0 comments 0 points Most recent by Christos S. Reporting & Analytics for B2C Service -
Time in status - only for incidents with a particular statusSummary Only report on incidents that include a particular status (not status type)Content Hi all. I am using the Time in status report (found here: https://cloudcustome…User_2025-02-01-08-17-38-818 73 views 0 comments 0 points Most recent by User_2025-02-01-08-17-38-818 Reporting & Analytics for B2C Service
-
Set Default Selection of Owner Prompt to Currently Logged-in UserSummary Set Default Selection of Owner Prompt to Currently Logged-in UserContent Hi, I want the currently logged-in user to be the default selection of Owner prompt I cr…User_2025-07-18-06-07-44-367 55 views 3 comments 0 points Most recent by User_2025-07-18-06-07-44-367 Reporting & Analytics for Sales
-
Dashboard Filters Not Updating As ExpectedSummary I am trying to make updates to some dashboard report filters and they are not being saved and/or are somehow holding on to previous settings.Content I am trying … -
Is there any rest api to run the report and download outputSummary Rest api for BI analysisContent Hi, Is there any rest api availbe to run and BI analysis and download the output. eg: Lead analyis Regards, Sudheer.
-
View analytics around sent emailsSummary How do I know that emails were sent?Content Hi, Let's say I use ConnectPHP to send 1000 emails in batches of 200. Currently, a lot of people from each batch are …King Jack 34 views 1 comment 1 point Most recent by Gursimran Singh Saini Reporting & Analytics for B2C Service -
How to capture existing Report name and Data model details in BIP ReportSummary How to capture existing Report name and Data model details in BIP ReportContent Hi All, We are having a requirement to develop the BIP publisher report which wil…Rohit Soni-259808 100 views 2 comments 4 points Most recent by Rohit Soni-259808 Reporting and Analytics for SCM
-
Is there a way to hide / remove the limit and order options for a report?Summary Need to be able to limit the number of records that an agent can see with a blank search using a custom contacts quick searchContent The quick search is useful t…Adam Neale 30 views 4 comments 1 point Most recent by Adam Neale Reporting & Analytics for B2C Service -
Get Time difference from same report columnSummary Get time difference for same incident ID but in same columnContent Hi I have incident ID and Adjusted time column in same report. Same incident ID has two time r…Baljeet Singh-231094 30 views 5 comments 0 points Most recent by Sarah Oracle-Oracle Reporting & Analytics for B2C Service -
Fetch only new or updated data from Last runContent Hi All, I am very new to Reporting hence need help to devlop report to fetch only incremental data. Report Logic: 1) Report will be called by Webservice by passi…Mayank Pande 114 views 1 comment 2 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for SCM -
Workaround To Searching Products and Product Groups in Workspace or Normal SearchContent Hi, I learned that Product and Product Group search is only available for the adaptive search REST api. Is there a workaround for this using the normal search or…User_2025-07-18-06-07-44-367 31 views 3 comments 2 points Most recent by Siraj Syed -Support-Oracle Sales
-
Passing Dynamic Filter values in a reportContent Hi, I have to filter the search report data associated with a field by passing a dynamic value that is available in the Workspace(i.e Incident.contactID). Can an…chandhiraekaran Nataraj 49 views 2 comments 0 points Most recent by Lakshay Bhalla Reporting & Analytics for B2C Service
-
Workspace Rule for Pop up Warning if you are attempting to send email to invalid email addressSummary We need to provide additional stopping points or warnings to our agentsContent We need create several warning when we have a contact with an invalid email addres…Jeff Scrobel 36 views 3 comments 0 points Most recent by User_2025-02-03-22-07-33-802 Reporting & Analytics for B2C Service -
Add percentage in bar graphSummary Add percentage in bar graphContent Hi all, I need to add the percentage for each Status Name. I chose the Pareto graph because it shows the percentage scale. But… -
How to display 'Month name' instead of the number of the Month in OTBI analysisSummary How to display 'Month name' instead of the number of the Month in OTBI analysisContent Hi all, In the result of an analysis, for the Month field, I need to see t…
-
Alternative Solution To Using User Organization Hierarchy Based LoginSummary Alternative Solution To Using User Organization Hierarchy Based LoginContent Hi, We're having issues with using User Organization Hierarchy Based Login filter in…User_2025-07-18-06-07-44-367 81 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
Can You Link an OTBI Report on the Sales Cloud Homepage?Content Hi, We want users to give quick access to their most used reports in OTBI by trying to find a way to have the link available in the sales cloud homepage. Is this…User_2025-07-18-06-07-44-367 35 views 1 comment 1 point Most recent by Priscila Terazawa - Support-Oracle Sales
-
Make CampaignId available as a session scope variableSummary Adding the CampaignId as a session variable will make able to add contextual analysis at the Campaign analysis tab from Campaigns.Content As we've made with some… -
Tracking time spent in Incident QueueContent Hi, I have/am trying to build a report that shows how long an incident has been in a certain queue. I'm using inc_performance.intv_type Queued to De-queued filte…James G 39 views 1 comment 0 points Most recent by Alison-UniSA Reporting & Analytics for B2C Service
-
Using Transaction Table to determine when and who sent initial responseSummary I need to get the accounts.group_id of the employee who sent out the initial response transactions.acct_idContent I have the Transaction Table at the Root and th…Jeff Scrobel 33 views 4 comments 0 points Most recent by User_2025-02-03-22-07-33-802 Reporting & Analytics for B2C Service
-
multiple ParameterValuesContent I need to call runReport webserivce in groovy and pass two parameters to the report (see my groovy below). Could someone please provide a sample groovy that can …
-
How To Import/Export Lead Assignment RulesContent Hi, I want to extract the existing lead assignment rules in oracle sales cloud, update and be able to import the updated rules back in OSC. Is this possible? Tha…User_2025-07-18-06-07-44-367 62 views 3 comments 1 point Most recent by Siraj Syed -Support-Oracle Sales
-
How to deactivate BI Report Jobs during/right after P2TSummary Is it possible to deactivate report jobs during a P2T, avoiding the reports to be sent automatically right after the P2T is completed?Content Hello, Our customer…Murielle Manambelona-Oracle 36 views 1 comment 0 points Most recent by Sahil_Makhiza Reporting and Analytics for SCM