Popular Tags
- OTBI 1,417
- Reporting 1,378
- FDI 1,013
- Analysis and Data Visualization 967
- BI Publisher 831
- Analysis 668
- Oracle Fusion Analytics 565
- Administration 554
- OBIEE 426
- OAC 375
- Analytics 365
- BI Publisher Data Models 340
- Security 284
- Answers 264
- Analyses 253
- HCM 247
- Developers 240
- BIP 238
- Data Modelling and Datasets 220
- Data Connectivity 206
- ERP Analytics Content 200
- BI Publisher Report Templates 192
- Report Output 181
- Customizing Reports 153
- Agents 151
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Report Layouts
Discussion List
-
Cells are not merged for formulasDear All, I have developed a custom OTBI report to retrieve data related to the payable module; however, invoice number and supplier number are merged when the data is e…George Mattar 31 views 3 comments 0 points Most recent by Regie Mercado Oracle Transactional Business Intelligence -
Issue in Applying Sorting in Union Query ReportHi, We have a requirement to create P&L report with 6 months of Trailing Period Data, Since the Revenue Accounts , Total Revenue is from different levels of Hierarchy ha…
-
Can we have multiple RTF templates as links instead of tabs in BIP report?Instead of having as tabs in case of multiple templates, we would like to have them as links in single view/screen, in one page. Attached the usual format, which we don'…Vaitheghi 11 views 1 comment 0 points Most recent by Hassan El Bouihi-Oracle Oracle Transactional Business Intelligence
-
Production to Stage for BIP ReportsSummary Easiest way to copy BIP reports from Production to Stage environments Content Hi all - we have two ways that we use BIP reports on our dashboards: 1) Embedded Co…Prudence K 61 views 3 comments 0 points Most recent by Vicki Parker Oracle Transactional Business Intelligence
-
Hi, I was trying to customize the lay out of SA Payslip seeded report.they want to customize the area that reflect the salary information so if the specific value of element equal to zero the hole area won't reflect. I tried to add conditi…menna allah muhammed 11 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Oracle Transactional Business Intelligence -
Dynamic column names and column value for BI reportI am creating custom report, in that we have to get column names and their respective values dynamically. Like this I have data, I have to get output like in this format…Rahul K-Oracle 54 views 2 comments 0 points Most recent by Mallikarjuna Kuppauru-Oracle Oracle Fusion ERP Analytics
-
2On Behalf of the Customer: Being able to send more than one Report Layout by Email SchedulingSometimes it is necessary to send different Layouts of the same Report, to the same person. Customer requests to be able to send them on a single email via scheduling th…Jorge Marañón-Oracle 11 views 0 comments 2 points Started by Jorge Marañón-Oracle Oracle Analytics Cloud and Server Idea Lab
-
Rows repeating with different values though it's not available in the Front end under Customer SiteHi, We have developed an OTBI report using Receivables - Customer Real Time and Receivables - Customer Account Site Tax Profile Real Time and it is repeating a single si…Rahul Kumar Gupta.-Oracle 11 views 1 comment 0 points Most recent by John Hung-Oracle Oracle Transactional Business Intelligence
-
Dynamic column names and respective column values for BI reportI am creating custom report, in that we have to get column names and their respective values dynamically. Like this I have data, I have to get output like in this format…Rahul K-Oracle 23 views 1 comment 0 points Most recent by Sathyaprakash M Oracle Fusion ERP Analytics
-
Insert Row/Column in-between sections in the OAC WorkbookHello experts, Is there a way to insert (Empty or Calculated) Row/Column between section in the OAC DV Workbook to replicate the financial statement reports with custom …Vaigu_27 45 views 5 comments 0 points Most recent by BalagurunathanBagavathy-Oracle Oracle Fusion Data Intelligence
-
Custom Report - It is possible to translate Layout name in a RTF type reportHello, We have a OTBI report created with a RTF template. In the report, we have by example an Layout name call Approval_RTF. When we attach this report to a dashbord an…Patrick Turcotte 62 views 4 comments 0 points Most recent by Patrick Turcotte Oracle Transactional Business Intelligence
-
1How to show Dynamic decimal formatting of Amount in BIP Report excel(*.xlsx) format using RTFExpectation is to show the value to number decimal based on CCY value in Excel(*.xlsx) report format. E.g. if CCY = CAD then number decimal value should be #,##0.00 else…Anil Pandey-Oracle 92 views 2 comments 1 point Most recent by Anil Pandey-Oracle Oracle Transactional Business Intelligence Idea Lab
-
Duplicate rows in Active Employees ReportWhen running the Active Employees Report I am getting duplicate rows for only a few of the employees. What is the best workaround for this?Usif Ahmed 31 views 1 comment 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence
-
Generate QR code along with logo at the center in rtf template.Hi All, There is a requirement to embed the image(logo) at the center in QR code. How we can generate QR code along with logo at the center in rtf template. I have attac…Poo_ja 61 views 2 comments 0 points Most recent by Poo_ja Oracle Transactional Business Intelligence
-
BIP Report Layout - Chart Values rounding up and showing as K (thousands)Hello everyone, I am using Oracle PLM Cloud Version 24A (11.12.24.01.0) And I am creating a data model with FSCM Database source and then I am creating report template o…
-
4Scaling settings to show chart value numbers as it is instead of rounding it up to Thousands (K)Hello everyone, I am using Oracle PLM Cloud Version 24A (11.12.24.01.0) And I am creating a data model with FSCM Database source and then I am creating report template o…Ramsha Zameer 21 views 0 comments 4 points Started by Ramsha Zameer Oracle Analytics Cloud and Server Idea Lab -
How to setup Excel table for RTF template so that the cursor goes to next row on pressing TabRTF Template when generated in Excel output doesn't have accessibility option such as cursor going to the next row in the Table on clicking Tab on reaching end of the ta… -
13Folder/heading columns in Data VisualizationHi. I'm trying to create workbooks with a huge number of columns. To better group the informations and clarify the content of the report, i would use a double level fold…User_YBCVZ 121 views 5 comments 13 points Most recent by La_Berry91 Oracle Analytics Cloud and Server Idea Lab
-
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 159 views 4 comments 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence
-
Excel template of BI Publisher: specific requirement on Grouping of 1 FieldHi, Attached are the samples from BIP as I cannot use ours due to security issues. But the Output requirement is mentioned exactly required marked in GREEN.Pradnya_Pampatwar 11 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Oracle Transactional Business Intelligence