Popular Tags
- OTBI 1,428
- Reporting 1,383
- FDI 1,062
- Analysis and Data Visualization 976
- BI Publisher 840
- Analysis 673
- Oracle Fusion Analytics 577
- Administration 555
- OBIEE 429
- OAC 406
- Analytics 382
- BI Publisher Data Models 346
- Security 288
- Answers 264
- HCM 256
- Analyses 253
- BIP 247
- Developers 243
- Data Modelling and Datasets 223
- Data Connectivity 208
- ERP Analytics Content 205
- BI Publisher Report Templates 201
- Report Output 183
- Oracle Analytics Cloud 168
- Customizing Reports 156
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
BI Publisher Data Models
Discussion List
-
What parameters to put in "Transactions Print Data Model"Hi Team, Hope you all are doing great! I want to know what all parameter data would be required to put in the "Transactions Print Data Model" to generate the XML data di… -
Selecting and formatting CLOB column in data model SQLI need to pull in a CLOB column into a BIP Data Model and in the end format it as a Rich Text. Is there a reference document or any suggestions on how to accomplish this?Emily Meyer 38 views 1 comment 0 points Most recent by Sandeep S. Chauhan-Oracle Oracle Analytics Publisher
-
No output generated in bursting but status is Success in BI PublisherHello I created a report with bursting and it turns out that when creating a report, I don't always have data, and logically an empty report is created, but BI bursting …Vitalii_Alliance_dgtl 2.6K views 9 comments 0 points Most recent by User_80HXO Oracle Analytics Publisher
-
2BICC : Reset Last Extract Date at PVO LevelOrganization Name World Wide Technology Description Summary:To allow users to reset Last Extract Date to a specific date at PVO Level instead of the current across all o…Yogesh Sureshkumar 125 views 2 comments 2 points Most recent by Bhaskar Konar Oracle Transactional Business Intelligence Idea Lab
-
Queries on Timezone related outputs in ERP CloudOur users are in PST Timezone and has raised concerns about report outputs being in UTC Timezone. We are trying to update report code and wanted to clarify few queries b…Abhilash K - Deloitte USI 649 views 11 comments 0 points Most recent by User_0GPX5 Oracle Analytics Publisher -
Issue creating RTF Template using Non-standard SQL Data ModelI have created a new Data Model in Fusion BI Publisher that uses Non-standard SQL and I have that functioning at intended. However when I try to create the report templa…
-
Need table name storing reporting period and status after "Finalize Transactions for Tax".We need to retrieve the final reporting status and reporting period in Oracle Fusion tables after running the "Finalize Transactions for Tax Reporting" ESS job. This ESS…
-
19Allow report with eText template to output a report to csv with the same structureOrganization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Accenture Description (Required): Cur…User_CJ6QA 999 views 6 comments 19 points Most recent by Bhaskar Konar Oracle Transactional Business Intelligence Idea Lab
-
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 358 views 3 comments 13 points Most recent by Sri Prasanth Oracle Transactional Business Intelligence Idea Lab
-
BI Publisher Table Grouping HelpSo, in BI Publisher, in my data model I have a subgrouping for one part of my data set but in the template, I have a for each on the subgrouping but they're not appearin…
-
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 24 views 2 comments 0 points Most recent by Bhaskar Konar Oracle Transactional Business Intelligence -
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 25 views 1 comment 0 points Most recent by Gianni Ceresa Oracle Transactional Business Intelligence
-
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 22 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Oracle Analytics Publisher
-
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 21 views 2 comments 0 points Most recent by Syamantak Saha Oracle Transactional Business Intelligence
-
I have a custom report always encounters an error after running for 5 hoursSummary: The Customization Report always encounters an error after running for 5 hours if I using the parameter plan name. Content (Please ensure you mask any confidenti…
-
Registration URLCode and registrationAccessCodeWe are implementing Supplier Registration.We need required tables to get this information for Registration URLCode and registrationAccessCode dynamicallly based on user …
-
2Hiding 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 42 views 2 comments 2 points Most recent by Binod Kumar Oracle Analytics Publisher Idea Lab
-
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 143 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 296 views 3 comments 0 points Most recent by jennifer fajardo-Oracle Oracle Transactional Business Intelligence