Popular Tags
- OTBI 1,434
- Reporting 1,386
- FDI 1,092
- Analysis and Data Visualization 981
- BI Publisher 847
- Analysis 676
- Oracle Fusion Analytics 581
- Administration 555
- OAC 437
- OBIEE 432
- Analytics 397
- BI Publisher Data Models 351
- Security 292
- Answers 264
- HCM 259
- BIP 257
- Analyses 254
- Developers 244
- Data Modelling and Datasets 226
- Data Connectivity 210
- ERP Analytics Content 208
- BI Publisher Report Templates 204
- Report Output 184
- Oracle Analytics Cloud 184
- Fusion Data Intelligence 163
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
BI Publisher Data Models
Discussion List
-
Locate Offer SalaryHi, For the context, we are using HCM 25A. I'm trying to query the offer salary amount in the job offer. I have checked IRC_OFFERS, and it doesn't contain the informatio… -
Oracle Analytics Cloud - OAPublisher Parameter Issue on Snowflake Data SourceWe have a data model off of a Snowflake data source that is working without issue except in one particular case: selecting all parameter values. The Data Model uses our …
-
Burst to multiple destinations (FTP server and Email)Hello - We use Fusion BIP application for ERP. I wanted to know if it is possible to have a Bursting Definition in the Data Model that will burst both a file to an FTP s…
-
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 699 views 12 comments 0 points Most recent by Vanitha Kundaram Oracle Analytics Publisher -
Last login of service accountSummary: I would like to find when a particular service account last logged in either through UI or through Webservice or both in Oracle ERP Fusion. Is there any SQL que…
-
Generate multiple Excel sheets based on parameter valueHi All, We are using Oracle Fusion Cloud Application 25C and Oracle BI Publisher Desktop for developing data template reports. Our requirement is to generate Excel outpu…Sonia Choudhary 17 views 1 comment 0 points Most recent by Subha_Tripathy-Oracle Oracle Fusion ERP Analytics
-
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…
-
Retrieve records for Supplier Audit reports in OracleHi I am trying to find below attributes from the Tools- Audit reports from UI but not able to find the table and attributes for Supplier Audit report. Please advise!Khushi 31 views 1 comment 0 points Most recent by MandeepGupta Oracle Transactional Business Intelligence
-
7Enable BIP to delivery output to OCI containerOrganization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of):Arcadis Description (Required):Add a n…Scott_Thomson 105 views 3 comments 7 points Most recent by Sandeep S. Chauhan-Oracle Oracle Analytics Publisher Idea Lab
-
24Access 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.8K views 16 comments 24 points Most recent by LJ_IQPC Oracle Analytics Publisher Idea Lab
-
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 46 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.7K 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 127 views 2 comments 2 points Most recent by Bhaskar Konar Oracle Transactional Business Intelligence Idea Lab
-
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 1.1K 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 378 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 23 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