Popular Tags
- OTBI 1,458
- Reporting 1,399
- FDI 1,153
- Fusion AI Data Platform 1,024
- Analysis and Data Visualization 994
- BI Publisher 868
- Analysis 684
- Oracle Fusion Analytics 597
- Administration 557
- OAC 488
- OBIEE 434
- Fusion HCM Analytics 417
- Analytics 411
- Fusion ERP Analytics 390
- BI Publisher Data Models 360
- Security 301
- HCM 270
- Answers 265
- BIP 265
- Analyses 255
- Developers 246
- Data Modelling and Datasets 229
- Oracle Analytics Cloud 221
- ERP Analytics Content 215
- Data Connectivity 212
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Report
Discussion List
-
Pivot row header nameI am trying to do a Pivot but the name is not appearing for the header. I am also trying the same in Pivot for bi publisher but not sure how to do it XML is attached. Co…Dhevina 11 views 1 comment 0 points Most recent by Hassan El Bouihi-Oracle Oracle Transactional Business Intelligence Forum -
Oracle Analytics BICC vs BIPFrom Oracle documentation I understand that BI Publisher (BIP) and BI Cloud Connector (BICC) is used for exporting bulk data from ERP Cloud I have used BIP in the past a…JoyP 2.8K views 4 comments 1 point Most recent by C. Joseph Oracle Business Intelligence Applications Forum
-
How to call BIP report using REST API?Hi all, we want to call BIP report using rest api service, we were able to call it using soap using the Basic Auth however when using the rest api it's saying 404 not fo…mayank_tripathi 673 views 4 comments 0 points Most recent by Gianni Ceresa Oracle Analytics Publisher Forum
-
I need to Employee Signed Date and Manager Signed Date from the position description documenti need a SQL query to fetch the Employee digitally Signed Date and Managers digitally Signed Date from position description Document which is attached in DOR. Please let…Chetana2000 31 views 1 comment 0 points Most recent by RajeshPolavarapu-Oracle Oracle Fusion AI Data Platform Forum
-
OTBI Report : Department level DFF issueWe have an OTBI report which pulls the employment level details and department level details of an employee. We would like to pull certain detail of the departments base…Amulya Kadiyala 21 views 1 comment 0 points Most recent by John Hung-Oracle Oracle Transactional Business Intelligence Forum
-
Excel is not considering my date value as date even after I tried many formatting? Need suggestionI am creating a XML publisher report where the date in the excel output should be in 'MM/DD/YYYY' format. Here I am able to achieve this format in excel however my excel…User_90781 61 views 2 comments 0 points Most recent by Nehemias-Oracle Oracle Analytics Publisher Forum
-
What is the difference between Refresh Data and Reload Data within the functional areas?I would like to know the difference between these two options within the functional areas, because we made an update in the financial categories of the accounts but the …SERGIO BARRETO 82 views 1 comment 1 point Most recent by Sumanth V -Oracle Oracle Fusion AI Data Platform Forum -
Can you reference other parameters in the initial value's logical SQL?For our projects report, we'd like to create a project manager parameter where we set the the project manage equal to the display name so that when project managers acce…Caroline Blanchard 81 views 5 comments 1 point Most recent by David Saggioro Oracle Fusion AI Data Platform Forum -
2Not able to calculate aggregated amounts for 'Discount' Column in Purchase Order Line Detail FolderWe have a requirement to generate reports in FDI that display the following metrics for Purchase Orders (POs): PO amount before discount Discount amount PO amount after …
-
Bursting ReportHi everyone, I need your help regarding bursting report. I created two Data models G_1 and G_2. In G_1, The query fetches the list of employees whose probation is about …
-
Try to find in which table I can find Default Expense Account discerptionHello everyone, I am working in BI Report and I am trying to find Default Expense Account discerption. I found the code but I could not find the discretions. the code fo…Khalid Aldosari-Oracle 121 views 5 comments 0 points Most recent by Gianni Ceresa Oracle Transactional Business Intelligence Forum
-
recruiting - recruiting real time Candidate AttachementHi Experts, I'm trying to fetch candidate attachment files/URLs by using this recruiting - recruiting real time OTBI. Unfortunately, I can't see any attachment files or …Saher 21 views 1 comment 0 points Most recent by John Hung-Oracle Oracle Transactional Business Intelligence Forum
-
Custom report to monitor login activityLeadership would like a custom report to monitor login activity. We'd like to know which users logged in last week and which application/function they used. Sample outpu…SUSAN SANDIFER 12 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Oracle Transactional Business Intelligence Forum -
Pulling Employee Balance Result value in Person Result.Hi Experts, I have a report requirement that needs to pull the value from 'Person Result > Calculate Quickpay > Balance Result > Value'. Is there any sample query that I…
-
Prevent merged rows in xpt template when there are line breaksSummary: I run into a problem when generating a report where a field contains line breaks. The row expands to the number of line breaks present in the field. I can't fin…Edisson Gabriel López 151 views 1 comment 1 point Most recent by Mallikarjuna Kuppauru-Oracle Oracle Analytics Publisher Forum
-
Hiring manager and recruiter's full names not displayed in anaylsisHello experts, we are creating an otbi analysis with the following info: job req number, hiring manager’s and recruiter’s full names. However these last 2 info appear fr…Oriana L. 72 views 4 comments 0 points Most recent by Oriana L. Oracle Transactional Business Intelligence Forum
-
2To include audit or update information in the saved customization report in OTBIUser cases: There are multiple users encountering deleted saved customization report in OTBI and it happens intermittently every year. Description of need: To have an au…Nicole Sy 21 views 0 comments 2 points Started by Nicole Sy Oracle Transactional Business Intelligence Idea Lab
-
Unable to join the field Display Name in Requisition Preparer in Procurement-Requistions Real TimeHi All, Requirement : To add the 'Entered By' field from the Manage Requisition Header UI to an existing OTBI report (Full PO Report - Purchasing) Subject Area : Procure…Deepak Bhatt 11 views 1 comment 0 points Most recent by John Hung-Oracle Oracle Transactional Business Intelligence Forum
-
Combining Recruiting - Recruiting Real Time and Recruiting - Recruiting Event Real TimeHi All, I have created a report using 'Recruiting - Recruiting Real Time' and one of the column Rejection/Withdrawal Reason("Recruiting - Recruiting Events Real Time"."J…Robinson Ng 91 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Oracle Transactional Business Intelligence Forum
-
Is there a cost report which end user can query for FAW infrastructure costs?Is there a cost report which end user can query for FAW infrastructure costs in OCI or maybe through another way?Tareena 1 view 1 comment 0 points Most recent by Mallikarjuna Kuppauru-Oracle Oracle Fusion AI Data Platform Forum