Popular Tags
- OTBI 1,494
- Reporting 1,411
- FDI 1,268
- Fusion AI Data Platform 1,048
- Analysis and Data Visualization 1,011
- BI Publisher 890
- Analysis 696
- Oracle Fusion Analytics 626
- OAC 567
- Administration 559
- OBIEE 444
- Fusion HCM Analytics 440
- Analytics 438
- Fusion ERP Analytics 436
- BI Publisher Data Models 367
- Security 311
- HCM 292
- Oracle Analytics Cloud 279
- BIP 272
- Answers 266
- Analyses 256
- Fusion Data Intelligence 249
- Developers 248
- Data Modelling and Datasets 237
- ERP Analytics Content 220
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
BI Publisher Data Models
Discussion List
-
Client cannot view report dataI have create a report BIP with data model but when the user execute it the result is empty when I can see data example: My user view: Customer view:Diego Zegarra 32 views 3 comments 0 points Most recent by Arun Raj Oracle Transactional Business Intelligence Forum -
Required Backend SQL table for Manage Taxes setupHi Team, Could anyone please tell us the Table name where the columns("Collecting tax authority" and "Collecting Tax authority site" ) information stored for the task Ma…Opkey PA 11 views 1 comment 1 point Most recent by Rodrigo Mello-Oracle Oracle Fusion Data Intelligence Forum -
Parameters field not populated in the bursting output excel fileThere is a custom report with two different datasets, with Excel template, client requested with to schedule the custom report daily to show the parameters(which we are …Shahid Qureshi 01 82 views 1 comment 0 points Most recent by Bhaskar Konar Oracle Transactional Business Intelligence Forum -
What is the table name used to display group names in the report?Hi everyone, Does anyone know which table we can use to display the highlighted grouping in the cash management report? ThanksMuhammad Itzaz 11 views 1 comment 0 points Most recent by Mallikarjuna Kuppauru-Oracle Oracle Fusion Data Intelligence Forum -
Create Data Set for HTTP XML Feed type with parameters.I'm creating a Data Model with HTTP XML Feed type. But not able to define URL Suffix with parameter. Without parameter its working fine but its giving error when define …MFM Tech 23 views 1 comment 0 points Most recent by Mallikarjuna Kuppauru-Oracle Oracle Analytics Publisher Forum -
1Requirement to add any other attribute to be added in bipublisher_vThe requirement is to have an audit report/log of the activity that are being done on the BIP server. We've enabled the audit log checkbox at the WebLogic level and now … -
SQL query to get SO DetailsCan someone please provide SQL query to get SO, Customer, ship_to, bill_to, delivery_id, invoice_number, payment_terms and other detailsDinesh K89 51 views 2 comments 0 points Most recent by MandeepGupta Oracle Transactional Business Intelligence Forum -
SQL editor for Oracle BISummary What tools are people using to edit SQL in Oracle BI? Content Hi, as per title, I'm wondering what everyone is using to edit SQL in Oracle BI? Eg. for data model…Alex Andreadis-21319 142 views 6 comments 1 point Most recent by Riyaz Ali-Oracle Oracle Transactional Business Intelligence Forum -
Page Numbers are not incrementing sequentially.Hello all, Am working on a requirement in which I have a header to be repeated dynamically I have used and and able to achieve it but we should use for each section fo…Bhavani Rikkula 691 views 29 comments 0 points Most recent by User_J83AL Oracle Analytics Publisher Forum -
2Ability to Adhoc SQL using REF CURSOR based BIP Report not supported anymoreOrganization Name National Oilwell Varco Description Our IT & HRIS Team is currently using a Tool to query Oracle HCM Cloud Database for information while debugging an I…Ravi Patil-74669 1.1K views 37 comments 2 points Most recent by User_M8ZEL Oracle Transactional Business Intelligence Idea Lab -
BIP Report in Oracle fusion not generating output when XML bursting is used in excel templateHi All, I've designed a BIP report using excel template as layout. I wrote XML bursting query to send the output to an email address. Observed that when I use excel temp… -
How do I preserve parameter visibility settings when migrating BI Publisher reports to a new server?I was working with Oracle BI Publisher and I came upon this problem: In the Report Editor page, there's a Parameters dialog where you can choose to show or hide specific…Ngoc Phung 83 views 5 comments 0 points Most recent by Kevin M-Oracle Oracle Analytics Publisher Forum -
Group Filter set to parameters with default values but no data returns, even though it's there.I created a Data Model with an Excel spreadsheet. I added a group filter setting the parameter to a value and I even converted it all to strings in the group filter. How…jmore92 101 views 9 comments 0 points Most recent by Kevin M-Oracle Oracle Analytics Publisher Forum -
Updates to performance goalsWithin the database itself, is it possible to see how often a goal is updated? Does the database create a new row when a performance goal or goal measure is updated? (Is…Vignesh Raghupathi 31 views 1 comment 0 points Most recent by Bhaskar Konar Oracle Transactional Business Intelligence Forum -
Tips on how to best troubleshoot BIP report performanceWe have a custom BIP report that was created by our SI back when we implemented, that we are having some performance issues as of late. The code is a bit complex and we …MDeming 736 views 1 comment 0 points Most recent by Bhaskar Konar Oracle Business Intelligence Applications Forum -
17Allow Joining of Multiple DV Datasets within a BI Publisher Data ModelWe really like how DV dataset seems a lot more friendly and user intuitive when using them within a BIP Data Model. HOWEVER: We were trying to leverage using DV datasets…Mark Ryan 51 views 0 comments 17 points Most recent by Mark Ryan Oracle Analytics Publisher Idea Lab -
A BI Report data model have two data sets with one data sets not returning dataI have a client requirement, a BI report having two data seta when one data set does not return data. The report should not generate output for one data set and send ema…SayanDutta 31 views 3 comments 0 points Most recent by Bhaskar Konar Oracle Analytics Publisher Forum -
Need SQL Logic to get data from last bip report scheduled dateWe have requirement to get report output from sysdate to last report scheduled date. for example, if report is first scheduled on Jan 1st 2025 and later schedule date is…Ranjith1166 41 views 2 comments 0 points Most recent by Ranjith1166 Oracle Business Intelligence Applications Forum -
Shikha Charadva 96 views 4 comments 0 points Most recent by Neha Aishwarya Oracle Analytics Publisher Forum -
Adding Image in a BIP ReportHi All, We have a requirement to pull an image in a BI Report. Is this achievable? We are using a table (HRT_PROFILES_B) with a CLOB type field wherein the base64 format…JohnAngelo 31 views 2 comments 0 points Most recent by Gianni Ceresa Oracle Analytics Publisher Forum