Category 192-2
Discussion List
-
Last 7 days or week query - Looking to query for Opps, Contacts or Accounts updated in last 7 daysSummary: I am trying to generate reports on Opportunities Created or modified in last 7 days - or "Last Week". Also, I want to do the same with Contacts and Accounts cre… -
Select query not giving desired resultSummary: I'm using below query but it is not giving desired result Content (required): The use case is to fetch the Email ID and subscription number of the contact assoc…Neelesh Varma 13 views 1 comment 0 points Most recent by Syed Misbauddin-Support-Oracle Reporting & Analytics for Sales
-
Reporting by Sales Reps for their Accounts and the activity in their accountsSummary: I am looking for a report that would enable the Sales Manager to drill into a Sales Rep, then see a summary of their accounts, then select on an account and see…Tim Gruidl 41 views 6 comments 0 points Most recent by Priscila Terazawa-Support-Oracle Reporting & Analytics for Sales
-
How to combine two rows of text data into a single column in OTBI?**This post was created as part of a How to Service Request (SR) Release: 11.13.22.07.0 Summary of the question: How to combine two rows of text data into a single colum…Priscila Terazawa-Support-Oracle 43 views 2 comments 0 points Most recent by Priscila Terazawa-Support-Oracle Reporting & Analytics for Sales -
Can the Notification Preferences of all users be found through reporting?**This post was created as part of a How to Service Request (SR) Release: 22C Summary of the question: Is there a way to obtain for all users, through reporting, the inf…Andrei Stan-Support-Oracle 32 views 1 comment 0 points Most recent by Andrei Stan-Support-Oracle Reporting & Analytics for Sales
-
How to Send an Email with report attachment?Question : How can an email notification be sent to the opportunity owner with all the opportunity details at the same time? **This post was created as part of a How to …Iulian Hanza-Support-Oracle 4 views 1 comment 0 points Most recent by Iulian Hanza-Support-Oracle Reporting & Analytics for Sales
-
Analytics: Infolets Limitation**This post was created as part of a How to Service Request (SR) Release: 22B Summary of the question: Is there any limitation of indicators to add within the Infolets s…Ionel Spaloghe-Support-Oracle 21 views 4 comments 0 points Most recent by Ionel Spaloghe-Support-Oracle Reporting & Analytics for Sales
-
How can I create reports with 2 different CSA**This post was created as part of a How to Service Request (SR) Release: 22B Summary of the question: I am trying to create a report using 2 different custom subject ar…Ionel Spaloghe-Support-Oracle 12 views 1 comment 0 points Most recent by Ionel Spaloghe-Support-Oracle Reporting & Analytics for Sales
-
How can I generate a report that has a manual quota amount set for each rep and pull that into a repSummary: I don't have territories and Quotas setup yet. I wanted to see how to generate a report that allows me to set a static amount for a sales rep and then pull in t…
-
Can we migrate reports/folders and content from 22B version in DEV to Production which is 21D?Summary: Can we migrate reports/folders and content from 22B version in DEV to production which is 21D? Description :- We are planning to migrate our reports/folders fro…Syed Misbauddin-Support-Oracle 4 views 1 comment 0 points Most recent by Syed Misbauddin-Support-Oracle Reporting & Analytics for Sales -
Change US week num into ISOWeekNUM**This post was created as part of a How to Service Request (SR) Release: 22B Summary of the question: The week number that is provided in CX is using a US week num. Can…Ionel Spaloghe-Support-Oracle 11 views 1 comment 0 points Most recent by Ionel Spaloghe-Support-Oracle Reporting & Analytics for Sales
-
"Total Amount" column in OTBI from Paysheet - ICMSummary: Anyone who knows the exact column name of "Total Amount" in OTBI? This is a field from Paysheets in Incentive Compensation. Tried other existing columns in the …User0901 2 views 1 comment 0 points Most recent by Priscila Terazawa-Support-Oracle Reporting & Analytics for Sales
-
Calculated Field in OTBIHi, I have created OTBI report based on custom object in which I have field called Start Date and Number of months. I need to display calculated field called End Date wh…Mohammed Rafi 11 views 11 comments 2 points Most recent by Shivakumar Ayyanagowdar-Oracle Reporting & Analytics for Sales -
R13.x CX OTBI Subject Area to Database Lineage Mapping SpreadsheetSummary This posting includes R13 CX OTBI subject areas to database lineage mapping and security roles. Content This spreadsheet is published by Oracle OTBI Developm…Noelle Bartlam-Oracle 1.5K views 14 comments 11 points Most recent by Dimple Nagesh-Oracle Reporting & Analytics for Sales
-
Cloud BI dashboardSummary: Performance issue with dashboard. Content (required): Pivots populate within seconds within the analytic report. However, running through the dashboard it can t…Donna Fazio 2 views 1 comment 0 points Most recent by Priscila Terazawa-Support-Oracle Reporting & Analytics for Sales
-
How to Set Date Format to Dashboard Prompt?Summary: How to Set Date Format to Dashboard Prompt? Content (required): How to Set Date Format to Dashboard Prompt? Does the Date Format shown by default is based on Us…Shivakumar Ayyanagowdar-Oracle 1 view 0 comments 0 points Started by Shivakumar Ayyanagowdar-Oracle Reporting & Analytics for Sales -
Default Period Prompt to Current Period (ICM BIP Report)Summary: We have an ICM BIP report where we need the "Period" prompt to be defaulted to the current period. We tried using the SQL below, but it does not reflect correct…
-
Show OTBI Graph with no values rather than No Results messageSummary: There are instances when the OTBI bar graphs result in no data results. Instead of showing a "No Results" message, is it possible to show the graph instead? We …User0901 1 view 1 comment 1 point Most recent by Dimple Nagesh-Oracle Reporting & Analytics for Sales
-
Quotes and Quote Line - Sample ReportsOracle CX Sales has proactively provided pre-configured quote and quote line reports and dashboards in OTBI, referencing Sales - CRM Quote Lines subject area. A set of p…User938840-Oracle 21 views 0 comments 3 points Started by User938840-Oracle Reporting & Analytics for Sales