OTBI
Discussion List
-
SCM report in Saleshi all We have a Fusion application with Sales module sending Sales Orders (via CPQ) to SCM module. Customer would like to have an icon, in Sales home page, to allow use…Luca Angheben 1 view 2 comments 0 points Most recent by Luca Angheben Reporting & Analytics for Sales -
How do I remove the measure labels from my bar chart so it doesn't show in the legend?I have a horizontal bar chart and have noticed that the "measure labels" is in the Vary Color By section of my chart. I can move it to Group By, Sections, and Graph Prom…
-
OTBI Analysis reports giving different set of data in fusionSummary: Hi Team, The OTBI report giving different set of data in fusion for different users, we checked the roles both users have the same roles but still difference in…
-
How to create BI report/analysis based on external data?Summary: Is it possible to create report/analysis based on external data, such as an external ERP system? What options does Fusion have for this kind of connection? Is i…Max Prestes 21 views 1 comment 0 points Most recent by Piyush.Jain-Oracle Reporting & Analytics for Sales -
How to do custom color formatting for only top 3 Horizontal bars Graph in Oracle fusion OTBI ReportHi All, How to do custom color formatting for only top 3 Horizontal bars Graph in Oracle fusion OTBI Report like below image?. Please share us your Ideas or Implementati…Sukumaran Ayyaswamy 21 views 3 comments 0 points Most recent by Manasi.Singh Reporting & Analytics for Sales
-
Can we add Deep Link to lead a Contract and populate statusSummary: They want a link on the Contract OTBI/Infolets that, if clicked in contract status "active / pending approval status", will lead them to a Contract Record and p…
-
How to add lead notes to a reportSummary: We need to add in a report through of subject areas the notes that are recorded on the leads Content (required): How can we add the notes that are related to th…SERGIO BARRETO 41 views 4 comments 2 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Sales
-
How to create a custom Smart List Analysis/visualization to use in Redwood DashboardSummary: Hi, we need to create a custom Smart List analysis/visualization to use in the Redwood Dashboard. Content (please ensure you mask any confidential information):…Max Prestes 31 views 5 comments 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Sales
-
Need to build report between Task and Call Report (created via Task Page)Summary: Created a Task > open Task Detail > Action > Create Call Report. So now we have Task and its linked call report. Now we want to create a BI Report which should …AMIT KUMAR YADAV 41 views 9 comments 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Sales
-
How to get the SQL of a report made through Subject AreasSummary: We need to extract the source SQL code of a report made through subject areas Content (required): How can we get the source SQL code of a report made by subject…SERGIO BARRETO 381 views 9 comments 0 points Most recent by User_Q9CAN Reporting & Analytics for Sales
-
Problem in query that returns information from Oracle customers by siteSummary: My query should have only the records that were modified in sysdate SELECT /*********hz_parties******************/ hp.party_id, hp.party_name, hp.jgzz_fiscal_co…Cesar Tepetla Corte 11 views 2 comments 0 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Sales -
Query to get customer contacts by siteSummary: Query to get customer contacts by site Content (please ensure you mask any confidential information): Hi, I am trying to fetch AR Customer contact information w…Cesar Tepetla Corte 1.6K views 3 comments 0 points Most recent by Manoj Kumar-Support-Oracle Reporting & Analytics for Sales
-
How to limit prompt values to values displayed on analysis - OTBISummary: I'm building an analysis using the "Incentive Compensation - Attainments Real Time" subject area. One of the prompts in the dashboard that includes this analysi…Vitor Nakamura 71 views 3 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
Error when trying to add an analysis inside a datamodelI am trying to add an analysis inside a datamodel created through subject area, but when I click on view to see the information the application takes a long time and at …SERGIO BARRETO 101 views 12 comments 0 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Sales
-
Is there a way to push report out of OTBI into a database?Is there a way to push a report out of OTBI on a weekly or daily basis that generates an excel file into a OneDrive folder?mfribeiro 21 views 3 comments 0 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Sales
-
Table for main contact in CRMDear all, Please help, I need to identify the table that brings me the main contact of the CRM module in Oracle Fusion Cloud. Thank you.Jhonattan Diaz 31 views 3 comments 0 points Most recent by Madhuri Cheruku-Support-Oracle Reporting & Analytics for Sales
-
Get Data from OTBI to PowerBIIs there a way to get data from OTBI to integrate to PowerBI?Anj M. 101 views 3 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
Freezing of Headers in a Pivot TableSummary: We have this analysis showing multiple records. Is there a way to freeze the pivot table header view in this dashboard? We have checked Oracle documentations an…Kelvin Jamil Reyes 21 views 1 comment 0 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Sales
-
Multi Select field in UI returning Lookup Code in OTBISummary: We have this field in Sales UI having an FCL multi select in Division custom field. We have tried to add DESCRIPTOR_IDOF in this field however it is showing bla…Kelvin Jamil Reyes 11 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
Analysis Close Ratio by Trailing 12 MonthsHello, We are trying to create a dashboard that will show the close ratio - win vs loss - of each month as a trailing 12 total. We are looking to have the months as the …NAndrusick 21 views 3 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
How to fetch the Covered Levels of a Subscription using querySummary: How to fetch the Covered Levels of a Subscription using query Content (please ensure you mask any confidential information): How to fetch the Covered Levels of …Neelesh Varma 1 view 3 comments 0 points Most recent by Manoj Kumar-Support-Oracle Reporting & Analytics for Sales
-
Create Analysis Report for Marketing Interactions with Account informationDear Community, we are trying to create an analysis report for Marketing Activities linked to various Contacts but it's hard to find a good subject area that works corre…George Papadogiannopoulos 11 views 1 comment 0 points Most recent by Patrick Breidel-Oracle Reporting & Analytics for Sales
-
Can a Vanity URL be setup for the OTBI or BIP ReportsSummary: One of the requirements is to have a Vanity URL setup for accessing the OTBI/BIP reports from external source. Content (please ensure you mask any confidential …SSN-Oracle 41 views 9 comments 0 points Most recent by Patrick Breidel-Oracle Reporting & Analytics for Sales
-
User Adoption Insights - Preconfigured Sample Reports in OTBISummary Sample reports for user adoption insights in OTBI are available with attached .catalog fileContent Oracle CX Sales has received requests to provide pre-configure…Greg Rice-Oracle 597 views 10 comments 8 points Most recent by Nishant Lodha Reporting & Analytics for Sales -
Redwood - See all Email Interactions in a ReportAs an admin or sales manager, I want the ability to see all activities logged for customers. Prior to Redwood, an Activity Report could be leverage to see all activities…Amanda McAfee 61 views 14 comments 0 points Most recent by Amanda McAfee Reporting & Analytics for Sales
-
How to configure OTBI Reports for LaunchXSummary: LaunchX has built in Offers and Initiatives Dashboard which can be enabled by performing a set of steps. Instructions: Please download and unzip the attached zi…Deepak Gopal Venugopal-Oracle 91 views 0 comments 0 points Started by Deepak Gopal Venugopal-Oracle Digital Business Experience - Launch
-
Supplier Recon reportSummary: We are importing the suppliers,address,site details using FBDI.Is there a specific report that we can access or generate to reconcile the imported data with the…prabhunagu 31 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
OTBI does not display and filter standard Oracle Cx attributesSummary: Hello community, I hope you are well. To generate a Leads report, you need to filter the Leads by type of currency, the standard attribute of "Revenue". "Curren…XUM TECHNOLOGIES 31 views 2 comments 0 points Most recent by Patrick Breidel-Oracle Reporting & Analytics for Sales -
Total row should have same color according to the stage respectivelySummary: Total row should have same color based on the stage. Kindly check the screenshot. Content (please ensure you mask any confidential information): Version (includ…Nalsoft Pvt Ltd 11 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
Is Data numbers on graphs with different colours possible?Can two different colours be applied for value and count in the below graph? Like, Total Number of Opportunities data number should be in one colour and Total Value of O…Nalsoft Pvt Ltd 41 views 5 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales