Popular Tags
- OTBI 1,513
- Reporting 1,429
- FDI 1,344
- Fusion AI Data Platform 1,054
- Analysis and Data Visualization 1,024
- BI Publisher 908
- Analysis 699
- Oracle Fusion Analytics 641
- OAC 625
- Administration 568
- Fusion HCM Analytics 476
- Fusion ERP Analytics 472
- Analytics 465
- OBIEE 446
- BI Publisher Data Models 372
- Oracle Analytics Cloud 315
- Fusion Data Intelligence 312
- Security 312
- Fusion Data Intelligence FDI 304
- HCM 300
- BIP 275
- Answers 267
- Analyses 258
- Developers 251
- Data Modelling and Datasets 242
Report Output
Discussion List
-
Reference Relationship in BI PublisherContent Hi, I created an interview which loads data about a certain order - it then needs to go into boxes and I need to create shipping labels 1. The user adds an insta…Gaston van de Weijer 211.1K views 5 comments 1 point Most recent by Benjamin Arnulf-Oracle Oracle Transactional Business Intelligence Forum -
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 52 views 3 comments 0 points Most recent by Regie Mercado Oracle Transactional Business Intelligence Forum -
Calculating Percentage in OBIEE ReportSummary Calculating the Percentage of two columns. One column being a calculated field in itself and the other pre-defined field. Content Hello, I am trying to calculate…MarkS 322 views 2 comments 0 points Most recent by User_7JCMG Oracle Transactional Business Intelligence Forum -
2Enhancements Required to Scheduling Tool in OAC to Match Agents in OAC ClassicPlease can the new scheduling tool in OAC be enhanced to give all or some of the capabilities that you can use in OAC classic. This would allow you to trigger reports to…James Wild 1 view 0 comments 2 points Most recent by James Wild Oracle Transactional Business Intelligence Idea Lab -
We developed BI reports in English but user wants based on local Language want how to show data ?HI We developed BI reports in English Language but user wants based on local Language need to show data ? if user from arbic from need to show arbic and if user from pol…AjayKumar Maddipati 11 views 1 comment 0 points Most recent by Kevin M-Oracle Oracle Analytics Publisher Forum -
Bursting ReportHi everyone, I need your help regarding bursting report. I created two Data models G_1 and G_2. In G_1, The query fetches the list of employees whose probation is about … -
BI Report Output - How to get more than 65k rows in single tab in excel sheetWe have a requirement to get all the data in single sheet in a excel output more than 65k rows. Currently if the data more than 65k then data showing in next sheet. We t…Thanigainathan R 2.7K views 4 comments 0 points Most recent by Tejas GN Oracle Analytics Publisher Forum -
How to add Rerun option to generate BI report.Hi, We want rerun option for regenerating previously scheduled report to get incremental data. Currently we are not able do the same, every time we have to generate the …Jeetesh Singh 11 views 1 comment 0 points Most recent by Ashish-Oracle Oracle Analytics Publisher Forum -
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 14 views 1 comment 0 points Most recent by Hassan El Bouihi-Oracle Oracle Transactional Business Intelligence Forum -
how can I display days off for an employee when there is neither time in nor time out on these daysI have an issue that I need to display employee days off as "day off". For example, I have an employee whose days off are from 10:00 to 18:00 (Friday & Saturday), and hi…Salma Ashraf 16 views 1 comment 0 points Most recent by Mallikarjuna Kuppauru-Oracle Oracle Analytics Publisher Forum -
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 154 views 2 comments 0 points Most recent by Mallikarjuna Kuppauru-Oracle Oracle Fusion Data Intelligence Forum -
How to send OTBI reports to a destination folder on a network drive outside of OracleHow can one send OTBI reports to a destination folder on a network drive outside of Oraclebevwhite 181 views 1 comment 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence Forum -
What controls access to "all job histories" versus "my job histories" in Report Job History?Summary: How do we grant a user access to see all job history not just their own? Content (required): We are trying to grant access a power user access to all job histor…Lisa G. 1.5K views 6 comments 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence Forum -
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 148 views 2 comments 1 point Most recent by Anil Pandey-Oracle Oracle Transactional Business Intelligence Idea Lab -
How to display a 2nd signature based on Check AmountHi, we have a requirement to print a second signature on a check when the check amount exceeds a threshold e.g., $25,000. We have created our RTF template with one stati…Craig Garcia 136 views 7 comments 0 points Most recent by Kevin M-Oracle Oracle Analytics Publisher Forum -
How to source: Profile Item Id in OTBI to populate spreadsheet loaderI'm trying to build a spreadsheet loader to load license and certifications specifically Responsible Manager which sits in Responsible Person Region in Skills and Qualif…Tina T 11 views 1 comment 0 points Most recent by John Hung-Oracle Oracle Transactional Business Intelligence Forum -
derive FTP output parameters - Remote Filename and Remote Directory automaticallyHI, We have created BIP reports with pl/sql type and when we try to schedule them with output option → FTP, it requires to input Remote Directory and Remote Filename. Is…GaneshMat 282 views 10 comments 0 points Most recent by Hassan El Bouihi-Oracle Oracle Transactional Business Intelligence Forum -
Fixed Asset Register report returns current period date instead of selected past datesFixed Asset Register report is not working when you select a date in the past like OCT 2023. it only returns the current Open period after running depreciation. How will…Oluwaseye Dairo 22 views 1 comment 0 points Most recent by John Hung-Oracle Oracle Transactional Business Intelligence Forum -
Event Date field generates too multiple rows for the same job req phase OTBIHi experts, we have created an OTBI analysis with the following fields taken from the 2 subject areas: Recruiting real time and Recruiting event real time. We have seen …Oriana L. 47 views 1 comment 0 points Most recent by GraemeHarper Oracle Transactional Business Intelligence Forum -
Archival Transaction summary attachments in the BIP reportHi Team, We need to pull the attachments from the archived transactions in the BIP report for the reporting and audit purpose. Is there a way that we can pull the attach…Abhinay Singh-Oracle 14 views 1 comment 0 points Most recent by Mallikarjuna Kuppauru-Oracle Oracle Analytics Publisher Forum