Popular Tags
- OTBI 1,502
- Reporting 1,420
- FDI 1,294
- Fusion AI Data Platform 1,055
- Analysis and Data Visualization 1,015
- BI Publisher 898
- Analysis 699
- Oracle Fusion Analytics 634
- OAC 583
- Administration 564
- Fusion HCM Analytics 448
- Analytics 446
- Fusion ERP Analytics 445
- OBIEE 444
- BI Publisher Data Models 370
- Security 303
- Oracle Analytics Cloud 296
- HCM 295
- Fusion Data Intelligence 278
- BIP 272
- Answers 266
- Analyses 258
- Developers 250
- Data Modelling and Datasets 238
- Fusion Data Intelligence FDI 235
BI Publisher Data Models
Discussion List
-
How send two file-excel multi. templateGood day everyone! Is it possible to send several files in one letter using bursting? I have a report and there are two templates in it, how should I send them to the ma…Vitalii_Alliance_dgtl 71 views 2 comments 0 points Most recent by DPM Oracle Analytics Publisher Forum -
1Uninvoiced Receipt accrual report showing amounts in scientific notationUninvoiced Receipt accrual report showing amounts in scientific notation like Report is showing 6.12890000000000000000000000000000000001E02 Amount on UI is 612.89Himanshu M 11 views 0 comments 1 point Most recent by Himanshu M Oracle Transactional Business Intelligence Idea Lab
-
Put instructions on Parameter pageIs there a way to put a text box with instructions/comments/directions on the parameter page?Jill Larson 52 views 5 comments 0 points Most recent by Mallikarjuna Kuppauru-Oracle Oracle Analytics Publisher Forum
-
Is there a way to pull the email status for Bursting logic in BI fusion OracleIs there a way to Oracle fusion has a table or report to pull all the bursting email status for Bursting from BI report?DharaniR 11 views 1 comment 0 points Most recent by Mallikarjuna Kuppauru-Oracle Oracle Analytics Publisher Forum
-
Code Working in SQLdev but not BI PublisherHello, The below code is working in SQLdev, and will read in to BI Publisher. However, when I go to view data I am getting a 'SQL or ORA exceptions caused due to invalid…
-
Is there a role in Oracle Fusion BIP catalog, that allows users to view data model and not edit itI would like to know if there is a role in Oracle Fusion BIP catalog, that allows users to only view data model query but not give users the access to edit it.Anil Bathula 31 views 1 comment 0 points Most recent by Raghavan p-Oracle Oracle Analytics Publisher Forum
-
How to calculate the amount of data in the summary ?Hello everybody) I send the report via bursting to the mail. Is it possible to include as many lines in the file as possible in the message? Can we count such a number?Vitalii_Alliance_dgtl 66 views 3 comments 0 points Most recent by Mallikarjuna Kuppauru-Oracle Oracle Analytics Publisher Forum
-
Extract the parent BU of a specific Department in BIHow can I extract the parent BU of a specific Department in BI?Gian Luca Triglia 11 views 1 comment 0 points Most recent by Gianni Ceresa Oracle Analytics Publisher Forum
-
How to create your report execution schedule Oracle Bi PublisherIn the report execution schedule there is execution, daily, monthly, every time, can I somehow specify that my report should be executed from the 1st to the 10th of ever…Vitalii_Alliance_dgtl 74 views 3 comments 0 points Most recent by Vitalii_Alliance_dgtl Oracle Analytics Publisher Forum
-
How do I convert the date format this 2024-03-07T00:00:00.000+00:00 into 7-Mar-2024 as data datatypeI want to convert the date format this 2024-03-07T00:00:00.000+00:00 into 7-Mar-2024 as when I use trunc() function even then it returns the same and I dont want to conv…
-
1Parameter anomalies when setting a filter in the BIP reportSummary There was an anomaly with the report parameter. The scenario is that when the set parameter option in the report is set to "ALL" it works fine, it can generate d…
-
6"Refresh other parameters on change" option for Date parametersDescription We are looking for a way to have an option for refreshing other parameters with Date type Prompt. Use Case and Business Need We have a requirement that needs…
-
10Ability to use Job manager and Catalog manager in Fusion SaaS OTBIDescription If users are able to use OBIEE client tools like job manager or catalog manager in OTBI then we can reduce many number of SRs related to OTBI agents and cata…User_B8VQC 295 views 7 comments 10 points Most recent by Chris Pfeifer Oracle Transactional Business Intelligence Idea Lab
-
Bi Publisher Data model returning error when run, after using system variable in the sql query.We created a data model and defined a condition in the sql query using the system variable ':xdo_user_roles' (which fetches all roles of the session user) and using it, …Bishal Dutta 91 views 2 comments 0 points Most recent by Bishal Dutta Oracle Analytics Publisher Forum
-
Extracting all Columns from BIP Query without creating layout?Content Hi Guys I have to extract all the columns from 11 different tables for our finances guys to sift through and see what data they want. Some of these tables have 1…Aaron Leggett 263 views 4 comments 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence Forum
-
2Adding PO Change History Information to either Procurement - PO or Configurable Acct AnalysisCurrently in FAW, there is no ability to track when a Purchase Order (PO) gets changed in the system. We would like to the Change Order on the PO and the amount change. …Juan Hurtado 11 views 0 comments 2 points Most recent by Juan Hurtado Oracle Fusion Data Intelligence Idea Lab -
Convert a number to a fraction BIP reportHi all, Is there a function sql to convert a number to fraction using a BIP report in Oracle HCM? For example if I have 0.25 FTE value, I want to print the fraction 1/4.…teresa.marciano 21 views 1 comment 0 points Most recent by Mallikarjuna Kuppauru-Oracle Oracle Analytics Publisher Forum
-
Report output require in one rowHello BI Expert, I have a problem with the output of the report. How can we obtain a single employee record in a row? If someone could help me with this, it would be gre…Saher 21 views 1 comment 0 points Most recent by Mallikarjuna Kuppauru-Oracle Oracle Analytics Publisher Forum
-
Reporting for the recruitment/hiring processI need to build a report for the recruitment process that includes YTD counts for candidate slates, candidates on shortlist, interview slates and candidates interviewed …JDCal 185 views 2 comments 0 points Most recent by JDCal Oracle Transactional Business Intelligence Forum
-
New value isn't visible in NotificationHi Expert, I need your help. Our requirement is to add two fields in 'Request New Position' notification, 1. 'NUMBER OF OPENINGS' and 2. 'Business Justification' field. …