Reporting and Analytics
Discussion List
-
Quota ManagementSummary How to build roll up Quota reportContent Hi, Can anyone help me how to achieve the below roll up quota requirement using OBIEE report ? Position Actual Quota Tar… -
Passing filter value to search report dynamically from workspaceSummary Passing filter value to search report dynamically from workspaceContent when we open a search report from a workspace, i want to pass a filter value dynamically,…SumanB 54 views 1 comment 0 points Most recent by Suresh Thirukoti-Oracle Reporting & Analytics for B2C Service -
Exceptions don't work after the script processing has runContent How do I make exceptions work when I have a custom script processing the rows? Should it still work because I can't make it work So let's say I have a column tha…King Jack 58 views 0 comments 1 point Most recent by King Jack Reporting & Analytics for B2C Service -
date_add but only weekdaysSummary Want to use date_add, but only using weekdaysContent We have a variable that adds different numbers of days to the created date depending on the category to give…Ineke Clewer 35 views 0 comments 0 points Most recent by Ineke Clewer Reporting & Analytics for B2C Service -
Saved Prompt Values not working (Apply Saved Customizations)Summary Need ability to have individual users review Analysis based on their prompt value selections and be able to save those values so they don't have to make prompt s…Brannon B 30 views 1 comment 0 points Most recent by Just Rhianna Reporting & Analytics for B2C Service -
group search resultsSummary OKA I try to make a grouping of results by date and IDContent Hi, for an OKA customer im working on a report that groups searches by contact iD, by datetime. I g…Sjoerd Spring in 't Veld-145555 33 views 0 comments 0 points Most recent by Sjoerd Spring in 't Veld-145555 Reporting & Analytics for B2C Service -
Report join should display info from Primary & Secondary tableSummary Report join should display info from Primary & Secondary tableContent I have contact table with primary employment detail and custom object secondary employment …User_2025-02-03-16-53-11-440 33 views 4 comments 0 points Most recent by User_2025-02-03-16-53-11-440 Reporting & Analytics for B2C Service -
Report including Incident created, status changed and previous status changed date columnsSummary Help required with Custom Script to enable date in status reporting requirementContent Hi, 1. I have built a report that uses the Incidents table to get the refe…Craig Hevey 85 views 1 comment 2 points Most recent by User_2025-02-03-18-42-00-650 Reporting & Analytics for B2C Service
-
Dividing MetricsSummary Trying to divide two metrics, not working!!Content I am trying to divide two metrics and am not getting the results I need. Can someone help? The number of Won O…User_2025-01-22-20-09-02-352 25 views 3 comments 1 point Most recent by User_2025-02-07-15-30-51-637 Reporting & Analytics for Sales
-
Last day of month...11 months agoContent I need to pull leads created 11 months ago in May 2019. The current month is April of 2020 so I need to pull leads created in May of 2019. The expression works b…Patrick Kelley 39 views 3 comments 1 point Most recent by Patrick Kelley Reporting & Analytics for Sales -
BI Publisher bar graph: change series sort order but keep the order of series colorsSummary Looking for a way to change the sort order of series without changing the color order.Content Hello! First time on this forum, and hoping someone can help me out…User_2025-02-01-07-27-35-188 105 views 1 comment 2 points Most recent by User_2025-02-01-07-27-35-188 Reporting & Analytics for Sales
-
how to get the number of chats by siteContent We offer customers to start chat from customer Portal and brand website (by CCL link), i would like to identify how many chat coming from our custhelp pages and …Ajay Yadav-140866 29 views 3 comments 0 points Most recent by Anuj Behl Reporting & Analytics for B2C Service -
Show corresponding filter valueSummary Show corresponding filter valueContent Hi, I have 2 filters ID & Name. User filter the report either by ID or Name. I show filter value in text item ((filter nam…User_2025-02-03-16-53-11-440 35 views 2 comments 0 points Most recent by Anuj Behl Reporting & Analytics for B2C Service
-
How to show decimal places in 'average' column calculation?Summary Using the 'average' calculation is rounding, and I don't want it to.Content Hi everyone, I am trying to use "Edit Calculations" on a report column to get an aver…Mig Ponce-121584 30 views 1 comment 0 points Most recent by Anuj Behl Reporting & Analytics for B2C Service -
Changing date in report column from dd/mm/yyyy to dd/mm/yySummary Change from 4 digit year to 2 digit yearContent In Edit Definition I have tried date_format(fieldname,'DDMMYY') but it stopped showing the date and just repeated… -
Possibility to retrieve URL of an attachment stored in SaaS through BI PublisherSummary URL of attachments stored in UCMContent Hi, I am trying to find a way to extract via BI Publisher the URL of an attachment stored in the UCM. I have checked in t…Alberto Romani-Oracle 56 views 7 comments 1 point Most recent by Alberto Romani-Oracle Reporting and Analytics for SCM
-
Report to pull Accounts that doesnt have any associated opportunitiesSummary Report to pull Accounts that doesn't have any associated opportunitiesContent HI team, we are in the process of cleaning our Accounts module in Sales cloud, so i…Sharath Shanker 64 views 11 comments 2 points Most recent by Sharath Shanker Reporting & Analytics for Sales
-
How Charge type (Freight, Duty...) is calculated on a POSummary How Charge type (Freight, Duty...) is calculated on a PO in Landed Cost ManagementContent I need to show per unit cost of Charge (Freight, Duty, Material, Miscel…
-
OTBI CX Reporting - Best PracticesSummary OTBI CX Reporting - Best PracticesCode Snippet OTBI CX Reporting - Best PracticesMadhava Reddy-Oracle 86 views 3 comments 6 points Most recent by Adam Liu Reporting & Analytics for Sales
-
Date group formatting by week.Content Hi, I am grouping data into reporting weeks by using the syntax below: date_format(transactions.created,'Week: WW MONTH YY'). This is displayed as "Week: 34 Augu…User_2024-12-17-19-49-19-019 52 views 6 comments 0 points Most recent by Marissa Gonzales Reporting & Analytics for B2C Service
-
Filter "To" Email Addresses in Forward IncidentSummary Filter "To" Email Addresses in Forward IncidentContent Is it possible to filter the list of email addresses that are displayed when forwarding an incident? For e…JoshLong 23 views 3 comments 2 points Most recent by Just Rhianna Reporting & Analytics for B2C Service -
Difference between Duration and Total PeriodSummary Difference between Duration and Total PeriodContent Hello, Can you help me understand the difference between Chat duration defined as if(chats.state=5, date_diff…User_2025-02-03-17-38-42-482 31 views 3 comments 0 points Most recent by User_2025-02-03-17-38-42-482 Reporting & Analytics for B2C Service
-
Remove field in exported reportSummary Remove fields in exported reportContent I have 4 fields in my report. When I export the report, I want remove 1 fields and show 3 fields in the exported report.(…User_2025-02-03-16-53-11-440 17 views 3 comments 0 points Most recent by Levi Dyckman-Support-Oracle Reporting & Analytics for B2C Service
-
Reporting on NotesSummary How can we report on notes created in Sales Cloud?Content Is it possible to report on the notes created against an opportunity or an account? Example attached Th…Cyrille Saulnier-Oracle 37 views 2 comments 1 point Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
Enabling the User to Edit Reports Created by other USerSummary Enabling the User to Edit Reports Created by other USerContent Hello , I need to enable a user to edit reports for SCM created by other user i created a Custom R…Ali Essam El-Bandrawy 46 views 2 comments 0 points Most recent by Ali Essam El-Bandrawy Reporting and Analytics for SCM -
SR Feedback featureSummary Any ways to request feedback from Customers?Content Do we have any feature to request feedback for SRs we worked with customers? If no, do we have it in near roa… -
Removal of duplicate emails for a contactSummary Script to remove emails with .00XXContent Hi All, I've added the below script in one of my report to delete duplicate emails Scenario: email_alt1 is valid and em…User_2025-02-04-23-27-31-855 94 views 1 comment 0 points Most recent by User_2025-02-04-23-27-31-855 Reporting & Analytics for B2C Service