Reporting and Analytics
Discussion List
-
How to make a report on the configbase_values tableContent Hi All, I recently started working on existing site, before starting this i would like to understand their current configuration settings, i can see there is con…Ajay Yadav-140866 24 views 7 comments 0 points Most recent by Ajay Yadav-140866 Reporting & Analytics for B2C Service -
Chat Concurrency Factor - 30 min intervalsContent Hello How would I edit the Chat Concurrency Factor (3015) to be broken down in intervals of 30 minutes instead of an average of the entire day?Hanna Page 40 views 6 comments 1 point Most recent by Ajay Yadav-140866 Reporting & Analytics for B2C Service -
Display order - 10 answers to be top alwaysSummary Display order - 10 answers to be top alwaysContent Report displays answers based on ID (Descending order, latest first). Customer has given 10 answers ID's and t…User_2025-02-03-16-53-11-440 32 views 4 comments 0 points Most recent by Carl Elliott Reporting & Analytics for B2C Service -
Understanding Percentage ValueSummary Percentage Value of Reports GeneratedContent Hi Experts, I need help in understanding the reports generated from OSvC. I made a report (Status Report) I just wan…Jepee Celorico 40 views 8 comments 0 points Most recent by Ajay Yadav-140866 Reporting & Analytics for B2C Service -
Cross instance reportingSummary Report on data from other instanceContent Hi there. Does anyone have a sample script/report/instructions for me to report on an interface residing in another ins…Sebastiaan Draaisma-122509 34 views 2 comments 3 points Most recent by Gursimran Singh Saini Reporting & Analytics for B2C Service -
Organization Phone # Look UpContent Hi - I am importing a large list of organizations over that could have multiple phone numbers tied to one org. I have created custom fields for these (ex: ph, al…Hanna Page 29 views 6 comments 0 points Most recent by Sebastiaan Draaisma-122509 Reporting & Analytics for B2C Service -
Report to show search textSummary Report to show search textContent Hi How do I create report to show what is being searched in the search box? Is there any standard report available?User_2025-02-03-16-53-11-440 49 views 10 comments 0 points Most recent by Ajay Yadav-140866 Reporting & Analytics for B2C Service -
Chat Occupancy By HourContent I'm able to create an occupancy report by date and by agent. Before I get too involved creating a formula, does anyone have a template that can report on occupan…Marv Ferrer 32 views 6 comments 0 points Most recent by Ajay Yadav-140866 Reporting & Analytics for B2C Service -
Show Warning Message in ReportSummary Show Warning Message in ReportContent I want show following warning message in my report. I don't want to add any fields into the report. "WARNING! You have logg…User_2025-02-03-16-53-11-440 43 views 18 comments 0 points Most recent by Sebastiaan Draaisma-122509 Reporting & Analytics for B2C Service -
Interval based reportSummary Number of incidents in every 30 minutes for a day.Content Hi, I have a query related to number of incidents created in every 30 minutes but what I can see in doc…Ashutosh_86 58 views 3 comments 0 points Most recent by Sebastiaan Draaisma-122509 Reporting & Analytics for B2C Service -
Display Number as Number in Excel output of BI publisher reportSummary Display Number as Number in Excel output of BI publisher reportContent I have a report which displays employee ids as part of the report. Now when I export that …User_DYMHE 31 views 1 comment 0 points Most recent by Sebastiaan Draaisma-122509 Reporting & Analytics for B2C Service -
How to use both SUM and COUNTContent Hi, We have custom field for a contact called department. It's in the format: DEPARTMENT.TEAM I've split this successfully into two columns. The 3rd column does …King Jack 63 views 5 comments 1 point Most recent by Sebastiaan Draaisma-122509 Reporting & Analytics for B2C Service -
account_session_history tableSummary How long is data kept in the account_session_history table?Content Anyone know how long the data is kept in the account_session_history table? Specifically looki… -
Is it possible to show the Report Definition as a report column?Summary Output the report definition as a columnContent I have a report that shows information about reports, such as the Report ID (name), ACID, Owner, Last Run, etc. I…Ken Sands 43 views 4 comments 1 point Most recent by Sebastiaan Draaisma-122509 Reporting & Analytics for B2C Service -
Report on Report FiltersContent Hi, Is it possible to build a report which shows all the reports and what report filters are used in those reports? Report Link Run Values (ac_rpt_link_run_vals)…User_2025-02-03-17-15-23-653 48 views 2 comments 1 point Most recent by Sebastiaan Draaisma-122509 Reporting & Analytics for B2C Service -
creating historical reports independent of individual column dataContent While creating a report that relies on more than one date column (incidents.created and incidents.closed) to calculate backlog, it didn't appear possible to perf…Edgardo Lineros-Oracle 50 views 5 comments 0 points Most recent by Sebastiaan Draaisma-122509 Reporting & Analytics for B2C Service -
Need to expose the executive dashboards on Sales home pageSummary Need to expose the executive dashboards on Sales home pageContent We have developed an excutuve dashboard to contain 6 BI reports for the upper management users.… -
Cost - Item Cost Real Time subject area refresh questionSummary How long it will take to refresh the data in the real time subject areasContent Hi Team, i would like to know how the real time subject areas will refresh. The r…User_2025-01-30-01-18-25-142 43 views 1 comment 2 points Most recent by Amarnath Govindu Reporting and Analytics for SCM -
contracts approval flow tabelSummary tabel behind the contracts approval history flowContent Hello all, I have to build a report that contains the contracts approval flow information, like in the im…User_2025-02-04-08-34-10-102 40 views 5 comments 0 points Most recent by User_2025-02-04-08-34-10-102 Reporting & Analytics for B2C Service -
How to check syndicate chat performanceContent Hi, i am working to get all the pages from where Chat Initiated, we are using Conditional Chat and Proactive Chat both. Columns are required : URL from where cha…Ajay Yadav-140866 31 views 1 comment 0 points Most recent by Ajay Yadav-140866 Reporting & Analytics for B2C Service -
one report as input for another (similar to SQL View)Content Hi all, I have the following challenge: I want to use one report with a group count (e.g. first name, last name, email) to put a count behind, then do a group fi…Kai-Uwe 23 views 4 comments 0 points Most recent by Sebastiaan Draaisma-122509 Reporting & Analytics for B2C Service -
Expired Incident reference #Content For incidents that are created due to a reply to an old incident that has been closed past it's threshold- Can I create a report that shows the new incident refe…Kim Dante 58 views 5 comments 2 points Most recent by Sebastiaan Draaisma-122509 Reporting & Analytics for B2C Service -
Using data_group function to show two separate date formats?Content Hello - I am trying to utilize the data_group function to show two separate date formats within one column, if possible. For example, data would show as Year/Qua…User_2025-02-03-16-45-30-713 52 views 3 comments 0 points Most recent by User_2025-02-04-09-25-45-142 Reporting & Analytics for B2C Service -
How to get the COUNT totalSummary I need information on how to use the COUNT function in an IF conditionContent Hello, I tell you that I have a column called "Interactions Arrived" that displays …User_2025-02-04-18-19-53-976 82 views 1 comment 0 points Most recent by Sebastiaan Draaisma-122509 Reporting & Analytics for B2C Service -
How to Mask Year in Date of BirthSummary Attempting to mask or completely remove year in date of birthContent Hello, I am attempting to produce a report that will give birthdays without year. We have ma…User_2025-02-04-13-00-33-588 88 views 5 comments 1 point Most recent by User_2025-02-03-22-07-33-802 Reporting & Analytics for B2C Service -
How to find the technical name of a field in Oracle Fusion Cloud ModulesSummary Building OTBI Report - want to make it easier to choose the field I needContent When building an OTBI report, most of the battle is trying to find the exact fiel…Kim Winkler - NCS Multistage 348 views 1 comment 0 points Most recent by Purnachandra Rao Reporting and Analytics for SCM -
Display Product ID on ReportSummary Display Product ID on ReportContent It is possible to display the product id, not the name, on a report?JLFolkman 44 views 4 comments 0 points Most recent by Ajay Yadav-140866 Reporting & Analytics for B2C Service -
Executive dashboard using Sales Page or OBIEE interactive dashboard?Summary What would be the benefit of using the BI dashboard?Content Hi, We want to create an executive dashboard, and can either do it in the OEC application dashboards/…User_2025-02-04-10-37-00-332 32 views 2 comments 0 points Most recent by User_2025-02-04-10-37-00-332 Sales -
Chat session and skillsSummary Showing chat skills with status detailsContent Hi, Our chat team want a report to see details of agent statuses/availability together with skills. They want to s…User_2025-02-01-07-03-13-295 26 views 3 comments 0 points Most recent by Ajay Yadav-140866 Reporting & Analytics for B2C Service