Popular Tags
- OTBI 1,406
- Reporting 1,365
- FDI 970
- Analysis and Data Visualization 953
- BI Publisher 818
- Analysis 663
- Administration 553
- Oracle Fusion Analytics 546
- OBIEE 421
- Analytics 345
- OAC 337
- BI Publisher Data Models 335
- Security 272
- Answers 261
- Analyses 253
- Developers 240
- HCM 238
- 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
OTBI Reports
Discussion List
-
-
How to identify missing Associations in a Taxable Benefits Calculation CardHi, We have started Payrolling Benefits this tax year and have identified an issue where a Calculation Component, along with the Calculation Component Details have been …
-
Knowledge Management Article Views- Unable to view the data for Knowledge Article Status.Hello, I attempted to run an OTBI analysis using the 'Knowledge Management - Article Summary Historical' Subject Area to retrieve data on "# of Article Views," "# of Art…User_UE94E 13 views 3 comments 0 points Most recent by User_UE94E Oracle Transactional Business Intelligence
-
1Provide Total Pages option in OTBI HeaderWe are not able to print Page number (that is available) of Total pages (that is not available in Print & export options>Header). And this is a standard/vanilla need in …VDM_IM 4 views 0 comments 1 point Started by VDM_IM Oracle Transactional Business Intelligence Idea Lab -
How to get the manager assigned to the department to show in a OTBI reportHi team!I need to add this manager to my data model, so please can you help me with what tables or code I need to add in my SQL? In my report, the column will be called …Claudia Linares 19 views 2 comments 0 points Most recent by Claudia Linares Oracle Transactional Business Intelligence -
Current Year Promotion ReportI want to get the promotions of current year in OTBI report, I am getting it but the if there is any action after promotion then system is not picking that employee reco…Nazera Shabnam. 21 views 4 comments 0 points Most recent by Bhaskar Konar Oracle Transactional Business Intelligence
-
OTBI Parameter - formula of numeric number of the monthCould anyone help me with the formula to get the numeric number of the current month and previous month to use in parameter of OTBI Report Example: If current month is J…Nazera Shabnam. 36 views 5 comments 0 points Most recent by Nazera Shabnam. Oracle Analytics Cloud and Server
-
Request for Legal Employer of Manager in OTBI AnalysisHI in the subject area "Workforce Management - Worker Assignment Real Time", I need to retrieve the legal employer of the manager. Is this possible? If not, is it availa…
-
How to get the number of pages in report output (docx)Hello! Simple task has proven to be too complicated. I have a rtf template to generate report in docx format and in that report I need to show the total number of pages …MariLiis H 14 views 2 comments 0 points Most recent by MariLiis H Oracle Transactional Business Intelligence
-
second subject area selected columns values are being null in OTBIwhen join procurement - Requisition real time with product management - item revisions subject areas, columns selected from product management - item revisions are being…User_I895I 13 views 3 comments 0 points Most recent by Riyaz Ali-Oracle Oracle Transactional Business Intelligence
-
error using data mode property: Optimize Query ExecutionHello everyone, a few days ago I experienced a new situation. I have a report that extracts a large amount of data (over 100,000). I tried to optimize the execution time…
-
How do I report the total contractual working hours for a group of staff over a period of timeHello all, I have been asked to report on the total number of contractual hours (working Hours) for a group of staff (based on Job Role type) in a department over a peri…Peter Downer 33 views 10 comments 0 points Most recent by Riyaz Ali-Oracle Oracle Transactional Business Intelligence
-
When generating report from Analysis the rows are mergingHello Experts, I am currently having issues when I generated the report from the analysis it is looks okay but when I try to filter the report there are missing details,…Joliver Caangay 13 views 0 comments 0 points Started by Joliver Caangay Oracle Analytics Cloud and Server
-
Latest data changes are not reflecting in the OTBI report immediatelyHello All, We have an AOR drill-down OTBI report, but the latest changes to data are not reflecting immediately. For example, when we assign an AOR to an employee, it so…Nusrat Shaheen 46 views 6 comments 0 points Most recent by Riyaz Ali-Oracle Oracle Transactional Business Intelligence -
2Report Request - BI reports security auditing report.Report Request - BI reports security auditing report. Need to create a custom BI report to fetch the list of Bi reports, path of the BI reports and security roles that h…Sriram Shashank 13 views 0 comments 2 points Started by Sriram Shashank Oracle Transactional Business Intelligence Idea Lab
-
OTBI report built using cross subject area not pulling the data for custom subject area columnHi, There is an OTBI report built using crm sales standard subject area and the column named "Customer Driver" in the same subject area is pulling incorrect data as the …cvidhya 15 views 3 comments 0 points Most recent by ravikiran goda-Oracle Oracle Transactional Business Intelligence
-
Custom Report - It is possible to translate Layout name i an 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 31 views 1 comment 0 points Most recent by Riyaz Ali-Oracle Oracle Transactional Business Intelligence
-
Termination Data and Performance data in one reportI'm having problems combining termination data and previous performance ratings into one analysis to add to a dashboardGabby 1 view 1 comment 0 points Most recent by Riyaz Ali-Oracle Oracle Transactional Business Intelligence
-
Trying to connect two SAHi Everyone, I have those two subject area and I wondering if there is a way to joining them together 1- Payroll - Payroll Costing Setup Detail Real Time. 2- Payroll - P…Khalid Aldosari-Oracle 33 views 3 comments 0 points Most recent by ravikiran goda-Oracle Oracle Transactional Business Intelligence
-
How to fetch the First start date and latest end date from multiple rows in OTBI.I was trying to fetch the first start date and latest end date for and absence taken. since the short-term disability plan stores multiple rows in weekly wise so not abl…MohammedAmeenmfp10 23 views 4 comments 0 points Most recent by Riyaz Ali-Oracle Oracle Transactional Business Intelligence