Reporting and Analytics
Discussion List
-
What is the Subject Area to retrieve Invoice DetailsSummary: We are currently retrieving invoice details using a DM (Data Model) report with the SQL query provided below. Now, we want to create an Analytics Report using a…Anusha716 9 views 1 comment 0 points Most recent by Prabha.R Oracle-Oracle 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
-
Specific information regarding the UCM (Universal Content Management) folderSummary: Requesting for some specific information regarding the UCM (Universal Content Management) folder that we are currently working with. Accessing View Object Files…Carlo Orolfo 19 views 1 comment 0 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Sales
-
Alignment issue in Absence Approval Seeded notificationSummary: Let me explain theissue clearly how the notification is been triggered in Responsive UI andRedwood in over mail and in bell notification.Responsive UI level the…
-
What all roles has BI Consumer Privilege?Summary: We have created a copy of the Employee role and removed the analytics permissions from it. However, we would now like to grant analytics access to only a few se…Anusha716 21 views 2 comments 0 points Most recent by Priscila Terazawa - Support-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… -
What would be the reason of showing the Enterprise Quarter as null in Analytics- Sales CRM PipelineSummary: Eventhough the Accounting calendar is setup with proper periods & quarters; Calendar profile option also set to the configured. The opportunity records are show…Cyriac Mathew-Oracle 17 views 2 comments 0 points Most recent by Cyriac Mathew-Oracle Reporting & Analytics for Sales -
In partners, need the corresponding backend table and column name for Partner's Geographies Served.In partners, there is a column titled 'Partner's Geographies Served.' We need the corresponding backend table and column name. In BIA, we are currently able to retrieve …Vennela Valluri 17 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
Using Filters for Items with Rank Functions in BIThe Rank function is used to get the order of the employee numbers and divide the groups by 10's. Can I use this group for filters and prompts? Please let me know how to…
-
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. 19 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 12 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
In OTBI Analytics - How to export more than 75,000 records in Excel/CSV formatSummary: Currently in Oracle Transactional Business Intelligence, there is an export limit of 75,000 records in Excel format on a custom subject area we have created. Ar…Jay Patel-157091 33 views 1 comment 0 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
-
Add the users based on roles in Agent in analyticsHi Team, we are currently adding or removing the users in the agent in analytics individually. Is there a way to add or remove the users based on their resource role in …Haider Saifee 11 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
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
-
Business Intelligence Publisher Bursting to Email upper ThresholdContent Business Intelligence Publisher Bursting to Email upper Threshold Requirement: 50000 Bursting records get selected and they need to be sent as Email Attachment i…Shivakumar Ayyanagowdar-Oracle 211 views 12 comments 1 point Most recent by ShubhamTiwari93 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 33 views 3 comments 0 points Most recent by Manasi.Singh Reporting & Analytics for Sales
-
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
-
Is there any way we can edit visibility of the data labels and legends from Redwood Express Reports?Summary: We have a client requirement to remove data label text from a express report chart. But there is not option to edit (enable/disable) the same. The same express …Jameel Ahmed Ansari 41 views 2 comments 0 points Most recent by Jameel Ahmed Ansari 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
-
Pivot TableSummary: Hi, I need help with a report format. Object 1: Contains Question IDs Object 2: Contains Question IDs and Response fields We have a table that includes Question…Anusha716 42 views 5 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
I need to Create a report on a Contact where I have created a custom field for their managerSummary: I am trying to generate a hierarchal report on contacts within an organization. I have created a "Manager" field that links to another contact in Sales. I want …
-
How to enable the BI label drop down on a descriptive flexfieldContent Trying to figure out how I can use the BI label field drop down box on the description flexfield segment area when creating a new attribute. Reading the configur…Chris C 602 views 2 comments 1 point Most recent by Sailaja Chillara Reporting & Analytics for Sales -
Digital Signature in RTF templatesSummary: Hi Team, Could you please advise on how to enable digital signatures in RTF templates that span multiple pages? According to the documentation, it seems we need… -
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 495 views 9 comments 0 points Most recent by User_Q9CAN Reporting & Analytics for Sales
-
How to enable audit log in report and analytics.Summary: Is there any possibility to add audit log in report and analytics? For example: In objects(like Lead ,Opportunity ) there is a field which shows the value of la…ArjunReddy88 111 views 4 comments 1 point Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
Table Industries CRM SALESCordial greetings Please help me to identify the table that brings the Industries field data from the account in oracle cloud sales. Thank youJhonattan Diaz 11 views 1 comment 0 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Sales
-
Changes to DM is not reflecting in FTP Schedule ReportSummary Changes to DM query is not reflecting in FTP scheduled reportContent We have scehdule FTP report based on data model. Recently we made changes to that data model…
-
Service Usage Metrics Per User ReportSummary: Service Usage Metrics Per User Report Content (please ensure you mask any confidential information): Hi Could you help me to know if there is any report that pr…Jazmin Saldierna 38 views 3 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
PublicReportService - generateReport failedWe have a report in this path: /Custom/Customer Relationship Management/Data Warehouse/Res/Informes_Parametros/SpaceConfigurationDS_Analisis.xdo We reviewed the permissi…Jonatan Montiel 84 views 4 comments 0 points Most recent by Jonatan Montiel Reporting & Analytics for Sales