Popular Tags
- OTBI 1,401
- Reporting 1,365
- FDI 961
- Analysis and Data Visualization 953
- BI Publisher 816
- Analysis 663
- Administration 553
- Oracle Fusion Analytics 543
- OBIEE 421
- Analytics 342
- OAC 336
- BI Publisher Data Models 335
- Security 271
- Answers 261
- Analyses 253
- Developers 240
- HCM 237
- BIP 232
- Data Modelling and Datasets 218
- Data Connectivity 205
- ERP Analytics Content 199
- 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 Output
Discussion List
-
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. 1K views 6 comments 0 points Most recent by Nathan CCC 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 93 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…
-
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 12 views 1 comment 0 points Most recent by John Hung-Oracle Oracle Transactional Business Intelligence
-
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 131 views 10 comments 0 points Most recent by Hassan El Bouihi-Oracle Oracle Transactional Business Intelligence
-
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
-
Queries on Timezone related outputs in ERP CloudOur users are in PST Timezone and has raised concerns about report outputs being in UTC Timezone. We are trying to update report code and wanted to clarify few queries b…Abhilash K - Deloitte USI 555 views 10 comments 0 points Most recent by Abhilash K - Deloitte USI Oracle Analytics Publisher -
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
-
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 Fusion Data Intelligence
-
How can I extract LEGAL_ENTITY_IDENTIFIER?How can I extract the value of LEGAL_ENTITY_IDENTIFIER from XLE_ENTITY_PROFILES table if in HR_ALL_ORGANIZATION_UNITS_F table it's null the LEGAL_ENTITY_ID field?Gian Luca Triglia 53 views 5 comments 0 points Most recent by Mallikarjuna Kuppauru-Oracle Oracle Fusion Data Intelligence
-
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 11 views 1 comment 0 points Most recent by Gianni Ceresa Oracle Analytics Publisher
-
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 462 views 2 comments 2 points Most recent by Dave Kekish Oracle Analytics Publisher Idea Lab -
If applied formula in column grand total percentage value doesn't correct percentageIf applied formula in column grand total percentage But column value based on formula is correct but grand total percentage is not correct 2/804 *100=0.25% is correct Bu…User_HQ9TE 122 views 5 comments 0 points Most recent by EzequielC-Oracle Oracle Analytics Cloud and Server -
Why can't I download BI Publisher output using Firefox anymore?My Firefox updated to Version 123 yesterday (Feb 20, 2024), and I now I can't download BI Publisher output anymore. When I click on the report output after navigating to…BeachDreamer 102 views 2 comments 0 points Most recent by Abhilash K - Deloitte USI Oracle Transactional Business Intelligence
-
OTBI-Learning-Is there a way to report on who specifically took the action to Withdraw the learner?OTBI - Learning Module - Is there a way to report on who specifically took the action to Withdraw the learner or who assigned the Learning item to the learner? For examp…Harish Malik 42 views 2 comments 0 points Most recent by Sivakumaran Muthusamy-Oracle Oracle Transactional Business Intelligence
-
Why this field is empty?I have created a report from the subject area "Workforce Performance - Performance Rating Real Time", in which it's extracted the field "- Rating Level"."Rating Level Co…Gian Luca Triglia 55 views 4 comments 0 points Most recent by Sivakumaran Muthusamy-Oracle Oracle Transactional Business Intelligence
-
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 156 views 4 comments 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence
-
How to Fetch more than 1000 records with BIP or OTBI reportSummary: Fetch more than 1000 records with BIP or OTBI report. Content (required): Hi, How to fetch more than 1000 records with BIP or OTBI report. I tried with Paramete…Sudheer YN 1.1K views 8 comments 0 points Most recent by Sudheer YN Oracle Transactional Business Intelligence
-
Convert a number to a fraction BIP reportHi all, Is there a function sql to convert a number to fraction using a BIP report in Oracle HCM? For example if I have 0.25 FTE value, I want to print the fraction 1/4.…teresa.marciano 11 views 1 comment 0 points Most recent by Mallikarjuna Kuppauru-Oracle Oracle Analytics Publisher
-
7Excel & CSV Export Date to Use the Correct Time ZoneCurrently when users export data in Excel or CSV format (i.e. unformatted), dates are exported in raw format and converted to UTC time zone (refer the note at Analysis a…Neil M 1 121 views 0 comments 7 points Started by Neil M 1 Oracle Analytics Cloud and Server Idea Lab