Popular Tags
- OTBI 1,445
- Reporting 1,392
- FDI 1,114
- Analysis and Data Visualization 984
- BI Publisher 852
- Analysis 681
- Oracle Fusion Analytics 583
- Administration 555
- OAC 448
- OBIEE 433
- Analytics 399
- BI Publisher Data Models 354
- Security 293
- HCM 265
- Answers 264
- BIP 263
- Analyses 255
- Developers 245
- Data Modelling and Datasets 228
- Data Connectivity 210
- ERP Analytics Content 208
- BI Publisher Report Templates 204
- Oracle Analytics Cloud 191
- Report Output 184
- Fusion Data Intelligence 176
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
BI Publisher Data Models
Discussion List
-
Dependent parameters are not showing LOV'S when new custom ESS job created by copying standard ESSHi All, We have made customizations to the standard report and are currently attempting to create a new custom ESS job by duplicating the standard ESS job. The functiona…Pooja K-Oracle 239 views 3 comments 0 points Most recent by User_U3WDJ Oracle Transactional Business Intelligence -
1Allow entry of parameter value directly in menu parameter type of custom BIP reportWhen in custom BIP report data model parameter, user can select the menu type. Once the menu type parameter is used, user can only select the parameter value from the LO…CS Yuen-Oracle 5 views 0 comments 1 point Started by CS Yuen-Oracle Oracle Transactional Business Intelligence Idea Lab
-
How to create CS pivot (Suppliers as Columns) in OTBI?I am working on a Comparative Statement report in Oracle Fusion Cloud. I am using OTBI subject areas: Procurement – Requisitions Real Time Sourcing – Supplier Negotiatio…
-
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 …
-
24Option to expose BI data model or report as a REST APIOrganization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Oracle Description (Required): BI rep…Preetham Kumar-Oracle 1.3K views 11 comments 24 points Most recent by RVohra Oracle Transactional Business Intelligence Idea Lab
-
Talent review template name column subject area for otbiHi, We are in need of assistance to locate the OTBI subject area for the following columns: Talent Review Template name Selected Population Employee Name Selected Popula…Sujan Kumar Dash 18 views 3 comments 0 points Most recent by RVohra Oracle Transactional Business Intelligence
-
Excel report only showing parameter page and not data page when burstingSee attachment. When I run the report online it works. When I orride the bursting, it works. When I schedule with DM Bursting, the excel spreadshhet has the parameter va…Al Darabaris 20 views 5 comments 0 points Most recent by RVohra Oracle Transactional Business Intelligence
-
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…
-
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…
-
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…
-
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…
-
How can I extract LEGAL_ENTITY_IDENTIFIER?How can I extract the value of LEGAL_ENTITY_IDENTIFIER from XLE_ENTITY_PROFILES table if in HR_ALL_ORGANIZATION_UNITS_F table it's null the LEGAL_ENTITY_ID field?Gian Luca Triglia 91 views 7 comments 0 points Most recent by RVohra Oracle Fusion Data Intelligence
-
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 …
-
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…
-
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 726 views 12 comments 0 points Most recent by Vanitha Kundaram Oracle Analytics Publisher -
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 101 views 3 comments 7 points Most recent by Sandeep S. Chauhan-Oracle Oracle Analytics Publisher Idea Lab
-
25Access 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 25 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…