Reporting and Analytics
Discussion List
-
BI Publisher - Roles to Cancel Scheduled Job ReportWe are trying to cancel/delete an active scheduled job report. What are the roles we need to have the privilege to cancel the report job? -
DCL on OOTB Object doesn't show in OOTB subject areaSummary: Hi, I create a custom DCL on Activity Object. When I check the standard subject area (CRM - CRM Activity Real Time), I don't see this DCL in Activity Extension … -
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
-
CDM: Unable to find hierarchy fields in Fusion back end tablesHello, In a requirement we are creating hierarchy in CDM through the import management. We are required to create a report based on the fields in the import Hierarchy an…
-
Remove column header in BIP csv outputSummary is it possible?Content Quick question - Is it possible to remove column header for BIP csv output with configuration? I saw this MOS doc. I wonder if there are o…
-
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
-
Dashboard Filter in IST but results in ESTI have a dashboard filter that is run off IST time. Is there a way to modify the time zone in the dashboard filter? For Example: When entering a date range of 5/29/23 to…
-
java.net.SocketTimeoutException: Read time out - runReport ServiceSummary: java.net.SocketTimeoutException: Read time out - runReport Service Content (please ensure you mask any confidential information): We have a report created to ge…Nipuna Thandi Ashok 53 views 1 comment 0 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Sales
-
'Oracle Analytics Cloud Services' integration with IDCS - protocolsWe are having OACS instance which is integrated with IDCS out of box. We would like to know which protocol and encryption mechanism being used in IDCS(IAM) to establish …Shivaprasad Kamath 12 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
total column row should have only total amount valueSummary: In Report we are using Pivot table and there is amount column so doing total of the row , but the total row is giving again entire row values. Providing sample …
-
how to add dynamic values inside message content in BIP report schedulingSummary: I would like to know whether we can add parameter values under "message" while scheduling the report . The screen shot is given below. Content (please ensure yo…Simi_SS 51 views 6 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
How to find linkage between renewed subscription and original subscriptionSummary: Lets say we have a renewed subscription having number as 123456. How do we find the original subscription for this renewed one. Content (please ensure you mask …Neelesh Varma 31 views 2 comments 0 points Most recent by Ashwinikumar Sharma Subscription Management
-
Filter to get the earliest date in the OTBI Analysis.Summary: Content (please ensure you mask any confidential information): Hi, kindly asking for your help. I am trying to get the earliest date per account/activity within…Ivony Ann Paula Salango 21 views 3 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
Which Table stores data for Source Systems for Trading Community MembersSummary: Which Table stores data for Source Systems for Trading Community Members. SOAP WSDL and Operation to retrieve the data is below https://servername/crmService/Fo…Roshan Kottari 151 views 10 comments 0 points Most recent by Topher Heath-Support-Oracle Reporting & Analytics for Sales
-
custom subject area factSummary: My customer requested the creation of custom subject areas to put the information from these child custom objects in the reports. My team and I created the cust…Matheustavares#1412 11 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
Diagnose link purpose?Summary: What's the purpose of the Diagnose link in analytics dashboard? Content (please ensure you mask any confidential information): What's the purpose of the Diagnos…Chin Chi-Oracle 11 views 1 comment 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Sales
-
REST API to run BI reportSummary: Hi, I am trying to run existing BI report using REST API but getting error. Pls advise Thanks Content (please ensure you mask any confidential information): Ver…Suman Biswas 41 views 2 comments 0 points Most recent by Suman Biswas Reporting & Analytics for Sales
-
How to insert logo dynamically in RTF template headerSummary: We have a RTF template in that we are showing logos in header and same will be different for different Business units. now we have a base 64 encoded format of i…Hari krishna 971 views 2 comments 0 points Most recent by Hari krishna Reporting & Analytics for Sales
-
How can I create a custom job Role in BI Publisher?Summary: I can view the Roles and Permission under the Security Center using the /xmlpserver/. However, I cannot create a custom Role as there is no way for me to see th…Cristelle Rose Sampang 11 views 3 comments 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Sales
-
How to Version Invoice templatesSummary: We currently create Invoices by using an OTBI report to gather the data and put it into a RTF Template. However when you upload a new version of the template, t…
-
OTBI Union Report Data IssueSummary: I have created OTBI UNION Report with below subject areas and applied all mandatory filters but did not see any data in the report. 1. Subledger Accounting - Jo…FirozahamedSK 31 views 1 comment 0 points Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP
-
Is there a way to automatically trigger a scheduled job if it encounters failure on scheduled run?Summary: We have one file that was not sent to SFTP location as there is a connection issue in the SFTP as there is an emergency change in SFTP. In Oracle BI Publisher, …Cristelle Rose Sampang 71 views 3 comments 0 points Most recent by Narula Shray Reporting & Analytics for Sales
-
ORACLE FUSION SAAS CLOUD BI REPORT TIME OUT ISSUESummary: ORACLE FUSION SAAS CLOUD BI REPORT TIME OUT ISSUE Content (required): ORACLE FUSION SAAS CLOUD BI REPORT TIME OUT ISSUE IN DATA MODEL PROPERTY I HAVE INCREASED …RIfdhy Zain 31 views 4 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
Is there a report or analytics for activity notes?Summary: Analytics for activity notes Content (required): Hello, For the Service request module, we need to create a new report that can download the notes from the acti…Camilo Martinez-114335 31 views 3 comments 0 points Most recent by Camilo Martinez-114335 Reporting & Analytics for Fusion Service
-
How to create BI analysis for Sales Product and Product GroupsSummary: How to create BI analysis for Sales Product and Product Groups Content (required): Hi, We want to create a couple of analysis to show a list of product groups a…Max Prestes 31 views 2 comments 0 points Most recent by jiweiss-Oracle Reporting & Analytics for Sales -
Attachment ReportIs there a way to create a report on Account Attachments? Want to create a report that shows the Account and Attachment Name.
-
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 303 views 1 comment 0 points Most recent by Ian Rumble Reporting & Analytics for Sales -
How to filter for Finalized territories in Sales - CRM Territory Resource subject area?Summary: How to filter for Finalized territories in Sales - CRM Territory Resource subject area analysis? Content (required): I'm using Sales - CRM Territory Resource su…Chin Chi-Oracle 51 views 4 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
How to align 63 Report Fields in RTF Report TemplateSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):Malavika Sairaman 101 views 7 comments 0 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Sales
-
List of Values via SQL/Analytics Query - Oracle Sales Cloud (FUSION)Is there a way to extract/Query all Lists of Values via Analytics SQL Query or from a Task in Setup & Maintenance? We are trying to document this information in Oracle S…Christian Gerald Patacsil 71 views 4 comments 0 points Most recent by Christian Gerald Patacsil Reporting & Analytics for Sales