Popular Tags
- OTBI 1,392
- Reporting 1,362
- FDI 944
- Analysis and Data Visualization 932
- BI Publisher 813
- Analysis 660
- Administration 551
- Oracle Fusion Analytics 541
- OBIEE 420
- BI Publisher Data Models 335
- Analytics 335
- OAC 315
- Security 261
- Answers 260
- Analyses 253
- Developers 239
- HCM 233
- BIP 229
- Data Modelling and Datasets 215
- Data Connectivity 205
- ERP Analytics Content 196
- BI Publisher Report Templates 184
- Report Output 180
- Agents 151
- Customizing Reports 146
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Report Layouts
Discussion List
-
Is there a way to add calculated row in the pivot table (OTBI Analysis)Summary: Is there a way to add calculated row in the pivot table (OTBI Analysis) Content (required): I am trying to create an analysis like below using pivot table funct…Dharmendra Shukla 152 views 4 comments 0 points Most recent by Sahil Makhiza Oracle Transactional Business Intelligence -
How to fix an RTF report related error in OBIEESummary In OBIEE, an error was reported when opening a RTF report produced from a Data Model. What is the solution to fix the error Content Hello Oracle Team, In OBIEE, …Jonathan Chan gmg 161 views 3 comments 0 points Most recent by Arghyo Banerjee -Oracle Oracle Transactional Business Intelligence
-
Custom column in OTBI analysis with case statement is not displaying data in graphSummary I have created an analysis with one of the columns using case statement to derive the status of the performance document based on certain conditions. The graph d…Harpreet Shergill 71 views 4 comments 0 points Most recent by Harpreet Shergill Oracle Transactional Business Intelligence
-
Hints and Tips - How to Control the Colours in a GraphSummary Explanation of how to drive the colours in your graphs by the values being displayed Content This is part of a series of sample reports created by Oracle BI and …Caroline Gladwin-Oracle 112 views 4 comments 0 points Most recent by Tamer El-Tonsy - FudgeLearn UK Oracle Transactional Business Intelligence
-
Embed BIP Report with URL on page (HTML) and have parametersSummary Embed BIP Report with URL on page (HTML) and have parameters Content Hi, I've embedded my BIP Report on the Purchase Requisitions page succesfully using an ifram…
-
Is there a way to include Prompt Description in BI Publisher?Summary Looking for insight on how to include custom help tips on BI publisher prompts for user to understand what the prompt is Content When creating a report in OTBI, …Jacob Thompson 81 views 2 comments 0 points Most recent by Jacob Thompson Oracle Transactional Business Intelligence
-
BI Publisher Excel Report Fails With Error "java.lang.OutOfMemoryError: Java heap space"Summary BI Publisher Excel Report Fails With Error "java.lang.OutOfMemoryError: Java heap space" Content Hello Everyone, We are on Oracle Cloud Application 20B. I was tr…Dhanuka Chamal 377 views 4 comments 0 points Most recent by Dhanuka Chamal Oracle Transactional Business Intelligence
-
BI Publisher Excel TemplateContent Hi All, We have a nested table and beacause of this we are receiving this row mark in front of the data Printing and Stationery" rowMark="2 Does anyone know how …Kunal Daya-76859 21 views 2 comments 0 points Most recent by _IshanAgarwal Oracle Transactional Business Intelligence
-
Custom PO Print - Text Attachment Content on BI Publisher ReportSummary We are creating a custom report where we need to display the Content of Text attachment for a Purchase Order. This information is not being stored in seeded Docu…Rahul L 324 views 2 comments 0 points Most recent by Robert Fighiroae-Oracle Oracle Transactional Business Intelligence
-
Pivot FormattingContent Hi all - When I create a Pivot in Excel, it groups together rather than repeat each row. This does not make it easy to filter the report after downloading. Is th…Prudence K 61 views 4 comments 0 points Most recent by Prudence K Oracle Transactional Business Intelligence
-
User Time-Zone in BI Publisher Excel TemplateSummary User Time-Zone Management in Bi Publisher Content Hi, I am creating a report which has to extract a field which is managed with TIMESTAMP. Since this report shou…Alberto Romani-Oracle 244 views 3 comments 0 points Most recent by Robert Fighiroae-Oracle Oracle Transactional Business Intelligence
-
BIP compress output prior deliverySummary Compress output prior delivery Content To divide the large data set in multiple data set in OTBI we have option to use bursting. By using bursting we have writte…Niketa Ashwini 687 views 9 comments 0 points Most recent by Robert Fighiroae-Oracle Oracle Transactional Business Intelligence
-
Pivot table in rtf bi publisher 12cSummary Edit for-each to fetch on another for-each-group Content Hello developers, In pivot table, it fetch all empcode with respective to the cross table but in my cas…Osama Fawzy 21 views 1 comment 0 points Most recent by Osama Fawzy Oracle Transactional Business Intelligence
-
Syntax to fetch pending transfer details from Data_cache column in hrc_txn_dataSummary Syntax to fetch pending transfer details from Data_cache column in hrc_txn_data Content Hi, We need to fetch the pending transaction Transfer details like New Lo…NIRMAL KUMAR L 51 views 1 comment 0 points Most recent by User_OWH0W Oracle Transactional Business Intelligence
-
Scheduled Report JobsSummary Deails of Scheduled Report Jobs Content Hi Experts, I would like to know is there any seeded report to pull the complete details of scheduled report jobs in BI o…Charan Kollipara 181 views 8 comments 0 points Most recent by Akshay Aiyer Oracle Transactional Business Intelligence
-
List of OTBI inefficient ReportsSummary looking for was to monitor OTBI reports performance and Frequency of use Content Hi All, I am looking for ways to monitor the performance of OTBI Reports in fuss…Fongang 71 views 6 comments 0 points Most recent by AshishERPCloud Oracle Transactional Business Intelligence
-
Report on SocialSummary Need to create a report on Application Social Content Hi, We have a requirement to build reports on Social. Are there any OTBI Subject area or Tables to select f…
-
How to do an average days to approve formula?Content Hi all, I am trying to do an average days formula from a requisition submission date and when it was approved, and then put another column in with the month it w…Doron de Jong-57089 41 views 1 comment 0 points Most recent by aconavay Oracle Transactional Business Intelligence
-
One report - multiple tabsContent Hi all - how do you create a report with multiple tabs? Right now, the team implemented a page break in the report build, but it places a blank row at the top of…Prudence K 152 views 3 comments 0 points Most recent by Prudence K Oracle Transactional Business Intelligence
-
Remove duplicate values in OBIEEContent Hi All, Is it possible to remove duplicate values in OBIEE? In my report, columns A and B have unique values per line for an employee, however, column G is all t…Natalie Andrek-27262 233 views 4 comments 0 points Most recent by RichardChan Oracle Transactional Business Intelligence