Popular Tags
- OTBI 1,380
- Reporting 1,355
- Analysis and Data Visualization 917
- FDI 917
- BI Publisher 803
- Analysis 657
- Administration 544
- Oracle Fusion Analytics 539
- OBIEE 418
- BI Publisher Data Models 331
- Analytics 320
- OAC 293
- Answers 260
- Security 257
- Analyses 252
- Developers 235
- HCM 229
- BIP 224
- Data Modelling and Datasets 212
- Data Connectivity 204
- ERP Analytics Content 193
- BI Publisher Report Templates 181
- Report Output 179
- Agents 149
- Customizing Reports 143
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
BI Publisher Data Models
Discussion List
-
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…
-
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 83 views 5 comments 0 points Most recent by Rich Merkel Oracle Transactional Business Intelligence
-
19GSI - Data Source Access across Oracle Pillars (HCM and FIN) - BI AdminOrganization Name Southern Description The Oracle Idea Lab is logged to highlight a gap in the BI Publisher security design. As of today, a user with the ability to crea…Matt Van Asten 259 views 16 comments 19 points Most recent by Sudheer YN Oracle Transactional Business Intelligence Idea Lab
-
1Hiding the Zero Amount transactions from Create Customer Statements Seeded ReportOrganization Name BURNCO Rock Products Ltd Description Hi , As of now "Generate Statement Report" seeded report is displaying the zero balance transaction(Amount Due).Bu…Ganesh Assuru 45 views 1 comment 1 point Most recent by LJD2705 Oracle Transactional Business Intelligence Idea Lab
-
How to force URL defined in BIP Layout editor to open in a new windowWe need to open a standard application redwood page using the URL functionality in the layout editor. Example target page is: /fscmUI/redwood/procurement/workconfirmatio…Marcus131975 69 views 3 comments 0 points Most recent by Naga Durga Adabala Oracle Analytics Publisher
-
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…
-
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 13 views 0 comments 0 points Started by Dinesh K89 Oracle Transactional Business Intelligence
-
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…User_569GB 21 views 1 comment 0 points Most recent by Bhaskar Konar Oracle Transactional Business Intelligence
-
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 28 views 1 comment 0 points Most recent by Bhaskar Konar Oracle Business Intelligence Applications
-
6Allow 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 33 views 0 comments 6 points Started by Mark Ryan Oracle Analytics Cloud and Server 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…
-
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 21 views 2 comments 0 points Most recent by Ranjith1166 Oracle Business Intelligence Applications
-
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? Thanks -
Shikha Charadva 36 views 4 comments 0 points Most recent by Neha Aishwarya Oracle Analytics Publisher
-
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…
-
In a data model of a reportIn a data model of a report I have this Edit Data Set, in which table is stored the information of those data set fields?
-
4Ability to create custom Datastore in BI Could ConnectorOrganization Name Chewy Inc Description BICC (BI Cloud Connector) is the only tool that can extract data from Oracle Fusion Cloud ERP with incremental refresh capabiliti…RamRayaprolu 161 views 6 comments 4 points Most recent by Jan Bart van der Plaats Oracle Transactional Business Intelligence Idea Lab
-
22Access Oracle ATP Cloud as a Data Source in BI Publisher in Oracle Fusion Apps CloudOrganization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Deloitte Description (Required): BI P…Kaushik Pola 1.5K views 15 comments 22 points Most recent by Prasobh Oracle Transactional Business Intelligence Idea Lab
-
9Allow Selection of Multiple Values from an LOV into a single parameterOrganization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): The MathWorks, Inc. Description (Requ…StevenK 1K views 6 comments 9 points Most recent by Sidshah Oracle Transactional Business Intelligence Idea Lab