Popular Tags
- OTBI 1,473
- Reporting 1,405
- FDI 1,195
- Fusion AI Data Platform 1,038
- Analysis and Data Visualization 1,004
- BI Publisher 875
- Analysis 687
- Oracle Fusion Analytics 611
- Administration 556
- OAC 527
- OBIEE 436
- Fusion HCM Analytics 427
- Analytics 419
- Fusion ERP Analytics 409
- BI Publisher Data Models 361
- Security 301
- HCM 279
- BIP 267
- Answers 266
- Analyses 255
- Developers 246
- Oracle Analytics Cloud 246
- Data Modelling and Datasets 231
- ERP Analytics Content 217
- Data Connectivity 214
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
BI Publisher Data Models
Discussion List
-
13Automation of OTBI reports for version source control and deploymentOrganization Name Pengurusan Air Selangor Sdn Bhd Description We are looking for the mechanism to automate the archive and unarchive steps of custom BIP catalogs from Re…User_BKC13 421 views 3 comments 13 points Most recent by Sri Prasanth Oracle Transactional Business Intelligence Idea Lab -
How to LinkExpense and Advance (Financials Query Report Development)Hi Oracle Community, I’m working on developing a query report in Oracle Cloud Financials and need assistance with linking an expense and an advance. I have an expense an…Kauan_Bohn 42 views 2 comments 0 points Most recent by Bhaskar Konar Oracle Transactional Business Intelligence Forum -
Oracle Community Idea Raised - No ResponseWe have raised an Idea in Oracle Community (below is the link): https://community.oracle.com/products/oracleanalytics/discussion/19536/restriction-of-data-in-reports-and…V P Aravind 21 views 1 comment 0 points Most recent by Gianni Ceresa Oracle Transactional Business Intelligence Forum -
Invoke fusion webservice as BI Publisher Web Service SourceHi Team, can you confirm Invoke fusion webservice as BI Publisher Web Service data Source? We try to invoke esswebservice from BI Publisher Web Service Source it is not …Prasanth Venkata p 21 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Oracle Analytics Publisher Forum -
How does the data get restored into a useable format so that reports can be generated?Hi Team, Could you please help with the following query. Client is running SaaS Fusion ERP, HCM, SCM, and a few others. Client is dissolving and going out of business Cl… -
Issue with VAT Details Report – Cancelled and Reversed Postings Not IncludedIs it possible to obtain the VAT amounts of a cancelled posting and its reversal, as apparently the system does not support it Any insight, workaround, or confirmation o…Jose Angel RuizMen 31 views 2 comments 0 points Most recent by Syamantak Saha Oracle Transactional Business Intelligence Forum -
Hiding 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 62 views 2 comments 2 points Most recent by Binod Kumar Oracle Analytics Publisher Forum -
6View BI Data model query and results in one single editor like SQL Developer.Description Create a DM > Data set > Query > Enter your query > when you view data > you will not be able to see the query and results at the same time. Original Idea Nu…kmanda 202 views 12 comments 6 points Most recent by Wim vd Veer Oracle Transactional Business Intelligence Idea Lab -
How to create ess job that will directly use the parameter of the data model?Hello, We have an analysis that we wanted to be available in the Scheduled Process. Since we cannot link the Analysis itself to the ESS job report job ID, we tried to re…Kristelle 334 views 3 comments 0 points Most recent by jennifer fajardo-Oracle Oracle Transactional Business Intelligence Forum -
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 34 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 AI Data Platform 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 64 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 12 views 1 comment 0 points Most recent by Mallikarjuna Kuppauru-Oracle Oracle Fusion AI Data Platform 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 11 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 31 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 141 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 521 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 991 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…