Reporting and Analytics
Discussion List
-
Logic of "Opportunity"."# Days in Stage"**This post was created as part of a How to Service Request (SR) Release: 22B Summary of the question: Would like to know what id the logic of "Opportunity"."# Days in S…Dragos Deak-Support-Oracle 61 views 1 comment 0 points Most recent by Dragos Deak-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 41 views 4 comments 0 points Most recent by Ionel Spaloghe-Support-Oracle Reporting & Analytics for Sales -
Is it possible to create a cross subject area report using a CX Sales and Incentive Compensation SA?**This post was created as part of a How to Service Request (SR) Release: 22C Summary of the question: Is it possible to create a cross subject area report using a CX Sa…Priscila Terazawa - Support-Oracle 21 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
How to set the export option at the bottom of the reports/Analysis/Dashboard?**This post was created as part of a How to Service Request (SR) Release: 22B Summary of the question: How to make a single Export option at the top for all the reports …Ioana-Pacioianu-Support-Oracle 41 views 2 comments 0 points Most recent by Ioana-Pacioianu-Support-Oracle Reporting & Analytics for Sales -
Why I am not able to search the Favorites in the 'Reports and Analytics' ?**This post was created as part of a How to Service Request (SR) Release: 22B Summary of the question: Not able to search the Favorites in the 'Reports and Analytics' se…Ioana-Pacioianu-Support-Oracle 41 views 1 comment 0 points Most recent by Ioana-Pacioianu-Support-Oracle Reporting & Analytics for Sales
-
How to sync the change of username in UI with OTBI agents created by the old username?**This post was created as part of a How to Service Request (SR) Release: 22B Summary of the question: Customer have changed the username and now all OTBI agents created…Ioana-Pacioianu-Support-Oracle 31 views 1 comment 0 points Most recent by Ioana-Pacioianu-Support-Oracle Reporting & Analytics for Sales
-
Proposed/Calibrated Rating (Recent & Historical)Summary: Hello, Good day! I have a requirement which is to pull the proposed rating (recent and historical) in one report but different column for recent and other colum…Hazel De Castro 31 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting & Analytics for Sales
-
Add Action Link in Grand Total in OTBI ReportContent Is it possible to add an action link to the Grand Total values in OTBI reports? So we can direct the user to another OTBI report. This is the automatically calcu…User0901 37 views 4 comments 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting & Analytics for Sales
-
Custom job role: impossible to execute a report even if the custom role has BI Author & BI Consumer**This post was created as part of a How to Service Request (SR) Release: 22B Summary of the question: I have created a new custom CRM job role. I have added rights via …Ionel Spaloghe-Support-Oracle 157 views 1 comment 0 points Most recent by Ionel Spaloghe-Support-Oracle Reporting & Analytics for Sales
-
How to bring information from multiple subject areas on Incentive Compensation?**This post was created as part of a How to Service Request (SR) Release: 22A Summary of the question: How to bring the columns from these subject areas in the same repo…Andrei Stan-Support-Oracle 51 views 1 comment 0 points Most recent by Priscila Terazawa - 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 31 views 1 comment 0 points Most recent by Ionel Spaloghe-Support-Oracle Reporting & Analytics for Sales
-
Territory Geography ReportSummary: Would like to be able to build a clean Report that shows all the Territories and the Zip Codes associated to each Territory. Zip codes are associated to Territo…1Name1 31 views 1 comment 0 points Most recent by Priscila Terazawa - 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 23 views 1 comment 0 points Most recent by Priscila Terazawa - Support-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 Development.…Noelle Bartlam-Oracle 2.8K views 14 comments 11 points Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Sales
-
RTF TemplatesSummary: Hi, Can anyone please provide documents or sample RTF templates for learning or exploring purpose. Thanks. Content (required): Version (include the version you …Padamatinti Varsha 91 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
Sales stage history report - count if revert to a single sales stage twiceSummary: Sales stage history report - count if revert to a single sales stage twice. Content (required): I am trying to create a report showing the number of opportuniti…Arsalan 31 views 1 comment 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Sales -
Is it possible to customize the service infolets in Analytics section?Summary: Hello, we would like to know if it is possible to customize the service infolets in Analytics section. Also, we would like to check if the data displayed in tho…Eric Serra I Paradis 11 views 1 comment 0 points Most recent by Priscila Terazawa - Support-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 33 views 1 comment 1 point Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Sales
-
Embed BI Publisher Report on Account PageSummary We need to embed a custom BIP Report on Account Page which gives info to users on unpaid customer invoices. I have created a report based on AccountID as paramet…Umang Gupta 27 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting & Analytics for Sales
-
OTBI performance recommendations paper (2679006.1) is available on MOS PortalSummary OTBI performance recommendations V2 doc is intended for OTBI system integrators, BI report developers and admins. It covers advanced performance tuning technique…Pavel Buynitsky-Oracle 137 views 11 comments 15 points Most recent by Pavel Buynitsky-Oracle Reporting & Analytics for Sales
-
Queue not identify accountsContent Hi, I'm experiencing a queuing problem on my team. Only one of them is accessing the service queue. How is this possible? How can I assign everyone to the same q…Leonardo Lazarini 13 views 1 comment 0 points Most recent by Syed Misbauddin-Support-Oracle Reporting & Analytics for Sales
-
Employee Hierarchy - Fixed Hierarchy Level is always zeroContent We have loaded employees' and managers' data populated in the resource object and running the ESS job to populate the employee hierarchy. I see manager hierarchy…Srinivas Malyala-Oracle 40 views 2 comments 0 points Most recent by Srinivas Malyala-Oracle Reporting & Analytics for Sales
-
How to do the linking of Tax Reporting Type CodeSummary Linking of Tax Reporting Type Code during running the service for European Sales Listing ReportContent Tax Reporting Type Code option is not showing any value to…Mithilesh Kashyap 74 views 0 comments 0 points Most recent by Mithilesh Kashyap Reporting & Analytics for Sales
-
SQL statements for DatastoresSummary What are the concrete SQL statements for an Datastore and what kind of joins are used for joining relevant database tables?Content Hello, we are looking for the …User_0HYL0 47 views 2 comments 4 points Most recent by Srinivas Malyala-Oracle Reporting & Analytics for Sales
-
Best Practices for Custom Subject AreaSummary Best Practices to design Custom Subject AreaContent Please refer: Oracle Engagement Cloud (Sales and Service): Best Practices for BI Extensibility and Using Cust…Syed Misbauddin-Support-Oracle 28 views 1 comment 2 points Most recent by Syed Misbauddin-Support-Oracle Reporting & Analytics for Sales -
What roles are needed to access the BI Data modelContent Hi, I created a custom role and assigned the roles: BI Administrator Role BI Applications Administrator Duty BI Applications Functional Developer Duty BI Publish…Valdir Dutra 51 views 3 comments 0 points Most recent by Valdir Dutra Reporting & Analytics for Sales -
Data Lineage document or BICCC PVO Details for 21B Sales subject Area - OTBIContent Hi Team, We need some data exports from oracle subscription management cloud application 21B. As we see there is additional feature available as part of 20B, whe…AnkitR Gupta 70 views 1 comment 0 points Most recent by Syed Misbauddin-Support-Oracle Reporting & Analytics for Sales -
CSV extract is showing date/time in UTC timeContent When the report is extracted to CSV format the time is shown in UTC time, is there a way we can convert the time to show Sydney time considering the daylight sav…Renjith Raj 27 views 5 comments 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Sales -
Weird Subject Area names appearing when using saved column featureContent When we are trying to use ‘saved columns’ we are observing weird subject area name folders in the catalog navigation. We are not able to identify in which folder…Srinivas Malyala-Oracle 37 views 2 comments 1 point Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Sales