Popular Tags
- OTBI 1,514
- Reporting 1,429
- FDI 1,353
- Fusion AI Data Platform 1,054
- Analysis and Data Visualization 1,025
- BI Publisher 910
- Analysis 700
- Oracle Fusion Analytics 645
- OAC 634
- Administration 569
- Fusion HCM Analytics 481
- Fusion ERP Analytics 473
- Analytics 469
- OBIEE 446
- BI Publisher Data Models 372
- Fusion Data Intelligence 321
- Oracle Analytics Cloud 318
- Security 314
- Fusion Data Intelligence FDI 310
- HCM 301
- BIP 277
- Answers 267
- Analyses 258
- Developers 251
- Data Modelling and Datasets 242
Report Output
Discussion List
-
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 -
3BIP Report Output when there are no rows should return the expected headers, not DATA_DSWe currently schedule reports to output as a CSV to the UCM for import into our local data warehouse platform. This works very well except on the occasion that the repor…Dave Kekish 744 views 2 comments 3 points Most recent by Dave Kekish Oracle Analytics Publisher Idea Lab -
If applied formula in column grand total percentage value doesn't correct percentageIf applied formula in column grand total percentage But column value based on formula is correct but grand total percentage is not correct 2/804 *100=0.25% is correct Bu… -
Why can't I download BI Publisher output using Firefox anymore?My Firefox updated to Version 123 yesterday (Feb 20, 2024), and I now I can't download BI Publisher output anymore. When I click on the report output after navigating to…BeachDreamer 118 views 2 comments 0 points Most recent by Abhilash K - Deloitte USI Oracle Transactional Business Intelligence Forum -
OTBI-Learning-Is there a way to report on who specifically took the action to Withdraw the learner?OTBI - Learning Module - Is there a way to report on who specifically took the action to Withdraw the learner or who assigned the Learning item to the learner? For examp…Harish Malik 62 views 2 comments 0 points Most recent by Sivakumaran Muthusamy-Oracle Oracle Transactional Business Intelligence Forum -
Why this field is empty?I have created a report from the subject area "Workforce Performance - Performance Rating Real Time", in which it's extracted the field "- Rating Level"."Rating Level Co…Gian Luca Triglia 114 views 4 comments 0 points Most recent by Sivakumaran Muthusamy-Oracle Oracle Transactional Business Intelligence 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 296 views 4 comments 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence Forum -
How to Fetch more than 1000 records with BIP or OTBI reportSummary: Fetch more than 1000 records with BIP or OTBI report. Content (required): Hi, How to fetch more than 1000 records with BIP or OTBI report. I tried with Paramete…Sudheer YN 1.6K views 8 comments 0 points Most recent by Sudheer YN Oracle Transactional Business Intelligence Forum -
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 -
8Excel & CSV Export Date to Use the Correct Time ZoneCurrently when users export data in Excel or CSV format (i.e. unformatted), dates are exported in raw format and converted to UTC time zone (refer the note at Analysis a… -
Add division parameter to OTBI ReportSummary: I am trying to create an OTBI report under the expense report templates to show approvers of given POs. I am able to add fields for company, department, and acc…Trent M 625 views 14 comments 0 points Most recent by Ajeez K-Oracle Oracle Transactional Business Intelligence Forum -
BI Publisher ReportDear All, I edited a BI Publisher report, but the modification appears only for the user who modified this report. What should I do to resolve this issue? Please advise,George Mattar 110 views 4 comments 0 points Most recent by Simonab-Oracle Oracle Analytics Publisher Forum -
Dashboard with multiple BI Publisher reports export to excel is blankSummary When using the Export entire workbook to excel function the exported excel sheet creates all the correct worksheet pages and headings however, the data is blank.…Sarah Munro 12024679 249 views 3 comments 0 points Most recent by User_SXVU3 Oracle Transactional Business Intelligence Forum -
RTF template return different output vs testing itHi, I am having issue with my report where its not returning the expected result/design but when testing it, its works fine. To give more context, I have this XML data a…Kiko III 64 views 3 comments 0 points Most recent by Mallikarjuna Kuppauru-Oracle Oracle Analytics Publisher Forum -
Person secured list in BI reportUsing an administrator user, how can create a BI report that extract data with the security visibility of another user, that is not an administrator? For example: as adm…Gian Luca Triglia 79 views 1 comment 0 points Most recent by Sinduja Sekar-Oracle Oracle Fusion Data Intelligence Forum -
Why does the contract analysis report not bring results to one user and to others?The roles assigned to the users were reviewed and they have the same ones, only some can execute the contract report and others cannot, what could be the cause of this? …Maresa 11 views 1 comment 0 points Most recent by Mallikarjuna Kuppauru-Oracle Oracle Fusion Data Intelligence Forum -
6Addition of more columns/fields to Generate and Transfer XML Transactions programOur client requirement is to generate CMF xml with additional columns from other modules like OMS/Inventory through Generate and Transfer XML Transactions program. But c…RupaliGahalot 33 views 0 comments 6 points Most recent by RupaliGahalot Oracle Transactional Business Intelligence Idea Lab -
BI Publisher Excel - How to get multiple horizontal repeating groups working?Content Hello There, I would like to know how can I get the below output using BI Publisher for Excel. I have three groups in the xml file. G_1 -> G_2 -> G_3 Below expec…Donald 816 views 6 comments 0 points Most recent by User_307T7 Oracle Transactional Business Intelligence Forum -
Why export link is not available under dashboard report?Hi , I want to add Export link to a report in dashboard. I added export and refresh options from report link in the property icon of the dashboard. But only refresh opti… -
2Ability to Search ESS- Using Report parameterThere are standard or Custom Reports to be scheduled for autorun, and the output is being sent to the Printer or any other communication method. If there is a failure in…Natchirajan S 11 views 0 comments 2 points Most recent by Natchirajan S Oracle Transactional Business Intelligence Idea Lab