Reporting and Analytics
Discussion List
-
ORA-01427: single-row subquery returns more than one rowSummary: Hi All, We encountered the below error in a specific report DM both while running the report and within the DM itself. After identifying and resolving the issue…Abhijit N 23 views 3 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
Details about Signals to report User Logins via Redwood SalesSummary: We raised an SR before SR 4-0000908263 in which we reported that logins are not being saved for users. We are informed that the Subject area only tracks the log…Carlo Orolfo 28 views 4 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
Connect to OAC via a REST serviceHello.I wanted to ask about a feature I need to create for my company.In this case, I need to download CSV files from OAC. I have some reports that were provided to me, …wilberth Canales Romero 14 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
Link Action in the Analytics ReportSummary: The Link Action is not returning the correct result. The URL is not working as expected in the defined parameters. The URL below is directing to another page as…
-
Rel 13.20B User Adoption – Object Activity and Resource System UsageContent User Adoption metrics help CRM stakeholders continuously measure the success of their CRM implementation. Using these metrics, CRM business leaders can obtain cr…Sudharshanan K B-Oracle 1.4K views 25 comments 21 points Most recent by Pavan Kumar Thummalapalli Reporting & Analytics for Sales
-
Pull Contacts in the Contacts Report using Account Manager and Regional Manager criteria.Summary: What is missing or incorrect in below queries or approach we are trying to use. Criteria: As an Account Manager when I launch the Contact Report, I would see My…Myles S. 45 views 3 comments 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 3.6K views 15 comments 11 points Most recent by Sachin Bhadange Reporting & Analytics for Sales
-
How to identify and group Subject Areas by module in Oracle Cloud Financials?Hello everyone, I’m currently reviewing the documentation about Subject Areas for Transactional Business Intelligence in Financials as part of a training plan I’m design…
-
Seeking Solution: Account Hierarchy Roll-up Report for Leads, Opportunities, and Service RequestsSummary: Hello Community, We have a business requirement to build a comprehensive dashboard or report in Oracle Sales Cloud that provides a consolidated view of Accounts…Sudheer V-Oracle 17 views 3 comments 0 points Most recent by Sudheer V-Oracle Reporting & Analytics for Sales
-
How to create analysis to identify contacts with duplicated e-mail?Summary: How to create analysis to identify contacts with duplicated e-mail? Content (please ensure you mask any confidential information): Hi, We're trying to create an…Max Prestes 27 views 10 comments 0 points Most recent by Priscila Terazawa - Support-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 262 views 13 comments 1 point Most recent by Prudvi_Batlanki Reporting & Analytics for Sales -
How to retrieve full update history for a specific Opportunity via OTBIThe business requirement is to retrieve all records/updates (audit history) related to a specific Opportunity in Oracle Sales Cloud, using OTBI. Required fields to be re…Paraskevi Thanasi 78 views 6 comments 0 points Most recent by Paraskevi Thanasi Reporting & Analytics for Sales
-
[EPBCS][Metadata]-Identify Parent become Lev0 member post hierarchy changesSummary: “Is there a way to identify metadata, such as a project’s parent member, where a stored property became a Level 0 member after all its children were moved to an…Muni Kumar Vellure-Oracle 9 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
How to build a report to show as when a specific report has been run and at which time?**This post was created as part of a How-To Service Request (SR) Summary: I need to report to show as when a specific report has been run and at which time. Version (inc…Priscila Terazawa - Support-Oracle 55 views 3 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
Map-based visualizations in OTBIWe are currently working on Sales Reports in OTBI within the Redwood UX environment, and the customer has requested the ability to include interactive maps within the re…Mira_Emad 24 views 2 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
How can we disable the option "Export to Excel" and Export to CSV" on the Express reports page?We would like to disable the action to "Export to Excel" and Export to CSV" from this Express reports page. We have checked in Visual Builder studio and also roles and a…User_0UTJO 24 views 2 comments 0 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Sales
-
Looking for a way to limit/disable the use of the refresh button on the BIPublisher rep executionMy client has a report that runs based on a date range. However, after running the report, when they immediately click the Refresh button, it triggers the data extractio…Oscar Chahestian-Oracle 2 views 4 comments 0 points Most recent by Oscar Chahestian-Oracle Reporting & Analytics for Sales
-
Need BI Report to get total Payout amounts per plan components in SalesSummary: Hi Experts, We are looking for BI Report to get total Payout amounts per plan components, the sum needs to group by based on Plan Name , Component Name, Perform…Rama123-Oracle 11 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
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 15 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 46 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 25 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 58 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 24 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 12 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. 12 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 43 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales