Popular Tags
- OTBI 1,494
- Reporting 1,411
- FDI 1,269
- Fusion AI Data Platform 1,048
- Analysis and Data Visualization 1,011
- BI Publisher 890
- Analysis 696
- Oracle Fusion Analytics 626
- OAC 567
- Administration 559
- OBIEE 444
- Fusion HCM Analytics 440
- Analytics 438
- Fusion ERP Analytics 436
- BI Publisher Data Models 367
- Security 311
- HCM 292
- Oracle Analytics Cloud 279
- BIP 272
- Answers 266
- Analyses 256
- Fusion Data Intelligence 249
- Developers 248
- Data Modelling and Datasets 237
- ERP Analytics Content 220
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Report Output
Discussion List
-
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 313 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.4K 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 11 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 11 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 111 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 122 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.3K 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 137 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 91 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 212 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 21 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. 31 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 11 views 1 comment 0 points Most recent by Mallikarjuna Kuppauru-Oracle Oracle Analytics Publisher Forum -
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 13 views 1 comment 0 points Most recent by Gianni Ceresa Oracle Analytics Publisher Forum -
2BIP 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 650 views 2 comments 2 points Most recent by Dave Kekish Oracle Analytics Publisher Idea Lab