Reporting and Analytics
Discussion List
-
Combining Conditions for column definition expression in Analytics ReportI'm facing a challenge in Analytics reports while trying to create a column definition expression that combines multiple conditions. I have two distinct expressions for …jaliya sampath 51 views 2 comments 0 points Most recent by jaliya sampath Reporting & Analytics for B2C Service -
Is there a way to undo changes within reports?Summary: Is there a way to undo changes within reports? Content (please ensure you mask any confidential information): I'm wondering if there is a way to undo the most r…kerry walker 31 views 2 comments 0 points Most recent by kerry walker Reporting & Analytics for B2C Service -
Data Model stuck and need to rerunSummary: We have a report that generated only the deleted record but for the new and changed record it was not included in the file. However when I rerun the data model …Cristelle Rose Sampang 1 view 3 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting & Analytics for B2C Service -
Facing issue with FTP Server setup in OBIEEHi All, We are setting up the FTP server in OBIEE to burst the BIP report output to FTP server. But the connection is failing after passing the Server, Host, Port, Secur…Ashok Ganesh-Oracle 31 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Sales -
planned service provider in transportation intelligenceHello can you please advise if there is a Planned Carrier (Planned Servprov) column in Transportation Intelligence or I am overlooking it? we are calculating a PTA % but…TatianaS 1 view 1 comment 0 points Most recent by Islam Bahgat-Oracle Reporting and Analytics for SCM -
Report Incident Grouping by Servicing TimeHi all. I have a report that groups incident by servicing time (using the inc_performance table and appropriate interval type filter). Using the formula if(inc_performan…Lucas Zuzarte 31 views 4 comments 0 points Most recent by Lucas Zuzarte Reporting & Analytics for B2C Service -
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 1.2K 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 -
Help with report chartsSummary: Looking for help utilizing charts in a report Content (please ensure you mask any confidential information): I'm wondering if anyone can point me to a video tut…kerry walker 11 views 2 comments 0 points Most recent by kerry walker Reporting & Analytics for B2C Service -
List all opportunities via APISummary: List all opportunities created using API Content (required): De momento necesitamos hacer una consulta de todas las oportunidades a través de API, en la documen… -
Defaulting the dashboard filterSummary: We have a dashboard which includes prompt as well, which is built based on custom subject areas with lead , opportunity , activity and custom object data. we de… -
Finding Contacts, not attached to any incidentsContent Over the time we have collected thousands of contacts through them contacting us and thus creating incidents. As part of the data protection we have been seperat…User_2025-01-29-21-23-47-181 53 views 5 comments 2 points Most recent by Darsen Prasad Reporting & Analytics for B2C Service -
Report showing different output when logging in same environment (With SSO and Without SSO)Summary: Background A customer report is a custom report that shows all parts/items that are appended to a Machine. Parts/items will be included in the report even when …Kamohelo Leqele-Oracle 11 views 1 comment 0 points Most recent by Kamohelo Leqele-Oracle Reporting and Analytics for SCM
-
How to setup different schedules on the same BICC datastoreIn BICC (OSC Sales Cloud) , I want to have two extracts of a datastore e.g. CrmAnalyticsAM.OpportunityAM.Revenue going to two destinations for different reporting use ca… -
how to calculate business days in the incident levelSummary Based on the business days, in My Inbox report level, the record colour needs to be changed. For example, once the incident is created for the **** category. For…Muthulakshmi 21 views 1 comment 0 points Most recent by Steve Garvert-Support-Oracle Reporting & Analytics for B2C Service -
Opening the Text field link in a new tab obieeSummary: In OBIEE , I have a text field and which contains a URL. I made it to clickable from data format. When we choose the data format as html hypertext it started wo… -
How to increase time-out limit for online reportsSummary: I need to know where to increase the processing time for online reports. We have already increased the extraction limit to 2GB, but when we extract the report w… -
ORACLE_SERVICE_CLOUD_Extensibility - How to execute a funcion after report load in BUI?Hi Oracle Community, How to execute a funcion after report load data in BUI ? I need to change value after report data load in analitic extension ThanksRichard J Algarve 41 views 5 comments 0 points Most recent by Nika Gerson Lohman Reporting & Analytics for B2C Service -
Are Custom Field Values from Custom Objects stored in PageFlowScope Variable? How can I access them?Summary: Getting Custom Objects Custom Fields Values from PageFlowScope Variable Content (required): Hello, I added an OTBI analysis to a custom object details page (Ana… -
Partner Table (ZPM_PARTNER_PROFILES ) is not return Primary contact detailsSummary: I am using ZPM_PARTNER_PROFILES table to fetch partner primary contact detail. But it is not getting any field to check partner primary contact detail. select *… -
Are there any report to extract knowledge advance article ?Hi There, I am wondering if there are any reports that I can use to extract knowledge advanced articles created by all authors. I try to look through all the tables in t…Vincent Lin 71 views 5 comments 0 points Most recent by Robert Surujbhan-Oracle Reporting & Analytics for B2C Service -
How to cancel scheduled reports?Summary Steps to cancel the scheduled custom reportContent Hi All, Can somebody please help me with the navigation to cancel the scheduled custom reports in Cloud? Thank…MAHESH TALWADE 42 views 4 comments 0 points Most recent by Erica Williams Reporting and Analytics for SCM -
Is CREATOR_PARTY_ID of ZMM_NOTES refers to Resource PartyId?Summary: I am loading the Account Note from one POD to another POD with following attributes. "CURRENCY_CODE,SOURCEOBJECTID,NOTETYPECODE,VISIBILITYCODE,NOTETITLE,CREATOR… -
How to access Party Source System Reference for Contact object using Groovy ScriptSummary: I need to retrieve the "Party Source System Reference" field from the "Contacts" standard object using a groovy script. This field is not visible in BI and also… -
Profile/Fill Inbox Report?Content Is it possible to generate a report listing all profiles and their assigned Fill Inbox queues? What table contain these queues? Thanks, Version OSC Feb 2015Joe P. 48 views 6 comments 0 points Most recent by Rasheed Ahamed Reporting & Analytics for B2C Service -
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 81 views 3 comments 0 points Most recent by Narula Shray Reporting & Analytics for Sales -
Can we change report standard date format using date_formatSummary: Hi We are trying to change the standard way of displaying date i.e. 09/26/2023 10:27 AM EDT in the report analytics the same way we have in CP or in Connect Obj…Baljeet Singh-231094 32 views 3 comments 0 points Most recent by Rasheed Ahamed Reporting & Analytics for B2C Service -
Change in the environment from production to test in links to reportsHi, We want to change links to BI PUBLISHER reports within the dashboard. When we do P2T we need to go through all the links and change them from the production environm…Alex_Balanovsky 42 views 3 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
OTBI Procurement - Requisitions Real Time Subject areaSummary: Procurement - Requisitions Real Time Subject area doesn't show Requisition with Source Inventory, Only showing Data for Supplier Source so which Subject area ca…