Note!! Please register for a free account to access the full content and also to participate in Q&A in the community
OTBI
Discussion List
-
Customer wants to have email and in-app notifications for Sales reports to be sent to team membersCustomer wants to have email and in-app notifications for Sales reports to be sent to team members. How can this be achieved? -
How to optimize SQL query on MOO_OPTYSummary: A BI Report must extract daily a specific set of specific opportunities Content (please ensure you mask any confidential information): We want to query on MOO_O…Luca Angheben 32 views 3 comments 0 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Sales
-
Searching on HZ_ORGANIZATION_PROFILES_Hi all we need to create a report, to run weekly, that searches for Accounts/Organizations on which a specific field changed in the last week. Any idea how to avoid a FU…Luca Angheben 13 views 2 comments 0 points Most recent by Luca Angheben Reporting & Analytics for Sales
-
BI Report: multiple filters return no results but when filters used individually returns recordsSummary: I have a BI report relating to Opportunities. I'm using 3 subject areas and one is a custom subject area, a group initiative that allows us to group opportuniti…Tonya H 44 views 3 comments 0 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Sales
-
How to access Data Model via API?Summary: How to access Data Model via API? Content (please ensure you mask any confidential information): Hi, our customer have external dashboards, using PowerBI, and t… -
Subject Area to Database Lineage MappingSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Sheela Pai-Oracle 11 views 0 comments 0 points Started by Sheela Pai-Oracle Reporting & Analytics for Sales
-
Can I use responsive design when displaying BI?Can I use responsive design when displaying BI?
-
Query to get ResourceOrganizationName of the userHi All, I am trying to extract resources/users with specific ResourceOrganizationName. I want to extract the ResourcePartyNumber and ResourceOrganizationName. Can you pl…Anj M. 11 views 1 comment 0 points Most recent by Topher Heath-Support-Oracle Reporting & Analytics for Sales
-
XMLPSERVERIn the XMLPServer section, can OTBI reports be seen, or are only BI reports visible?Emanuele De Marchi 11 views 1 comment 0 points Most recent by Priscila Terazawa - Support-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 638 views 12 comments 9 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
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 11 views 3 comments 0 points Most recent by Priscila Terazawa - Support-Oracle 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 31 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 31 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 51 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 32 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 526 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 2.8K 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 12 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