Report Layouts
Discussion List
-
We have set operations report but unable to reviewSummary: Hi Team, we have set operations report but I'm unable to find out applied filters and where we need to check . any one help me on how can we review for enchanem…AjayKumar Maddipati 11 views 2 comments 0 points Most recent by Bhaskar Konar General Transactional Reporting (OTBI) -
we have questin text and answer report but all questions are coming in columnsSummary: Hi , we have questin text and answer report but all questions and answers are coming in columns. so we get multiple records for each employee i mean 7 questions…AjayKumar Maddipati 21 views 4 comments 0 points Most recent by Bhaskar Konar General Transactional Reporting (OTBI)
-
Removing HTML tags from a datbase fieldSummary Remove HTML tags saved in database fieldContent Hi, I have an sql data model retruning HCM performance review data. One of the fields returned is a comments fiel…Geoff Fredericksen 60 views 3 comments 1 point Most recent by Gaurav Bharadwaj-Oracle General Transactional Reporting (OTBI) -
Fusion BI Catalog Folder Management Best PracticesSummary A white paper on Fusion BI Catalog Folder Management Best PracticeContent This white paper provides the best practices for working with BI catalog folders, and s…User720640-Oracle 108 views 1 comment 9 points Most recent by HarishVummidi General Transactional Reporting (OTBI) -
How do you convert UTC time to EST for transaction reportingSummary: Content (required): We are experiencing having issues with Oracle time zones defaulting to UTC vs EST for transaction reporting. Our client business operations …MBaze 22 views 1 comment 0 points Most recent by Gaurav Bharadwaj-Oracle General Transactional Reporting (OTBI)
-
Exist Interview Responses Report Not working for some of countriesSummary: Hi Team, we haveExist Interview Responses Report it was developed on few years back still no issue but now yesterday only one of country working fine but reamin…AjayKumar Maddipati 1 view 0 comments 0 points Started by AjayKumar Maddipati General Transactional Reporting (OTBI)
-
Repeat Column Headers in BI Publisher Excel TemplatesSummary Repeat Column Headers in BI Publisher Excel TemplatesContent Hello Everyone, I have a requirement to repeat column headers in BI publisher excel templates when t…Dhanuka Chamal 40 views 5 comments 2 points Most recent by ravikiran goda-Oracle General Transactional Reporting (OTBI) -
we have developed new OTBI report but when we Export analysis issue is occuringSummary: Hi Team, when we Export analysis > data > excel we get each row have person number, name some columns coming each row. and we export another way like Export ana…AjayKumar Maddipati 21 views 5 comments 0 points Most recent by Amrita Gupta-Oracle General Transactional Reporting (OTBI)
-
Remove repeating valuesSummary: Some of the column numeric values repeat even though Suppress is enabled for the column. Is there anything else I am missing? Thank you Content (required): Vers…Eva Mirzoyan 11 views 1 comment 0 points Most recent by Bhaskar Konar General Transactional Reporting (OTBI) -
duplicay coming for each employee due to each employee have showing multiple mangersSummary: Hi Team, In below screen shot we have taken employee name and manger name, but same employee has two line mangers coming that is the issue facing in the report.…AjayKumar Maddipati 41 views 14 comments 0 points Most recent by Amrita Gupta-Oracle General Transactional Reporting (OTBI)
-
When we creating the otbi report that time showing as UI but some times showing dff nameSummary: Hi Team, when we create the OTBI report that columns shown as as per ui but in some time showing as dff name directly in report. PFA Thanks, Ajay Content (requi…AjayKumar Maddipati 31 views 2 comments 0 points Most recent by AjayKumar Maddipati General Transactional Reporting (OTBI)
-
Pie Chart does not return all itemsSummary: Table results not displayed in Pie Chart Content (required): We have a table that is ranked and everything ranked above 10 is grouped under the reason name 'Oth…Dawn Cawston - CPS 1 view 6 comments 0 points Most recent by Amrita Gupta-Oracle General Transactional Reporting (OTBI) -
How to default an OTBI SQL in a Data Model to Table View?Summary: How to default an OTBI SQL in a Data Model to Table View? Content (required): Does anyone know if it's possible to default the Data tab of an OTBI Data Model to…Mike Burnett 11 views 3 comments 0 points Most recent by Mike Burnett General Transactional Reporting (OTBI) -
In OTBI report each employee have getting two rows but businees need only one row?Summary: Hi Team, when i set order as per bussiness requiremnt i taken and suppress the columns then when i export into csv or excel and with out usiing formatted option…AjayKumar Maddipati 51 views 6 comments 0 points Most recent by Amrita Gupta-Oracle General Transactional Reporting (OTBI)
-
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 1 view 4 comments 0 points Most recent by Sahil Makhiza General Transactional Reporting (OTBI) -
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 errorContent Hello Oracle Team, In OBIEE, w…Jonathan Chan gmg 20 views 3 comments 2 points Most recent by Arghyo Banerjee -Oracle General Transactional Reporting (OTBI)
-
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 23 views 4 comments 0 points Most recent by Harpreet Shergill General Transactional Reporting (OTBI)
-
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 displayedContent This is part of a series of sample reports created by Oracle BI and H…Caroline Gladwin-Oracle 236 views 4 comments 8 points Most recent by Tamer El-Tonsy - FudgeLearn UK General Transactional Reporting (OTBI) -
Pivot table in RTF TemplateContent Hello, I am trying to create a pivot table for an asset number per row and period name and depreciation amount in columns. I have followed this doc to create the…Nalinee Uppiah 16 views 10 comments 0 points Most recent by Anil Kola-Oracle General Transactional Reporting (OTBI)
-
Embed BIP Report with URL on page (HTML) and have parametersSummary Embed BIP Report with URL on page (HTML) and have parametersContent Hi, I've embedded my BIP Report on the Purchase Requisitions page succesfully using an iframe… -
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 isContent When creating a report in OTBI, y…Jacob Thompson 16 views 2 comments 1 point Most recent by Jacob Thompson General Transactional Reporting (OTBI)
-
How To Merge Quote and Quote Line Item In Advanced Custom Objects (Subject Area)Summary How To Merge Quote and Quote Line Item In Advanced Custom Objects (Subject Area)Content Hi, I'm working to extract all Quotes and their respective Quote Line Ite… -
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 try…Dhanuka Chamal 20 views 4 comments 2 points Most recent by Dhanuka Chamal General Transactional Reporting (OTBI)
-
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…
-
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 47 views 2 comments 2 points Most recent by _IshanAgarwal General Transactional Reporting (OTBI)
-
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 20 views 2 comments 0 points Most recent by Sarah Munro 12024679 General Transactional Reporting (OTBI) -
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 25 views 2 comments 1 point Most recent by Robert Fighiroae-Oracle General Transactional Reporting (OTBI)
-
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 21 views 4 comments 1 point Most recent by Prudence K General Transactional Reporting (OTBI) -
User Time-Zone in BI Publisher Excel TemplateSummary User Time-Zone Management in Bi PublisherContent Hi, I am creating a report which has to extract a field which is managed with TIMESTAMP. Since this report shoul…Alberto Romani-Oracle 24 views 3 comments 2 points Most recent by Robert Fighiroae-Oracle General Transactional Reporting (OTBI)
-
BIP compress output prior deliverySummary Compress output prior deliveryContent To divide the large data set in multiple data set in OTBI we have option to use bursting. By using bursting we have written…Niketa Ashwini 22 views 9 comments 1 point Most recent by Robert Fighiroae-Oracle General Transactional Reporting (OTBI)