Popular Tags
- OTBI 1,419
- Reporting 1,378
- FDI 1,016
- Analysis and Data Visualization 971
- BI Publisher 836
- Analysis 669
- Oracle Fusion Analytics 566
- Administration 555
- OBIEE 427
- OAC 381
- Analytics 368
- BI Publisher Data Models 345
- Security 286
- Answers 264
- Analyses 253
- HCM 249
- Developers 241
- BIP 241
- Data Modelling and Datasets 221
- Data Connectivity 206
- ERP Analytics Content 200
- BI Publisher Report Templates 194
- Report Output 182
- Customizing Reports 154
- Agents 151
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
OTBI Reports
Discussion List
-
Pivot Table incorrect totalI created a simple pivot table to count the number of accounts in a certain category. It is doing a distinct count and adding the totals at the end. What could possibly …Donna Fazio 4 views 0 comments 0 points Started by Donna Fazio Oracle Transactional Business Intelligence -
Automating Email Recipient Updates in Oracle Fusion HCM BI Publisher: Seeking Community InsightsHello Oracle Community, Problem Statement: We frequently receive multiple tickets from the business requesting updates to the email/distribution list recipient list in B…PMDinesh 21 views 3 comments 0 points Most recent by MandeepGupta Oracle Transactional Business Intelligence
-
3Request to Enable Translation Editor for Item Description by Business unitWe’ve explored whether it’s possible to retrieve the item description from the child inventory organization instead of the PPIM master, but it appears that Oracle restri…User_YVX4K 14 views 0 comments 3 points Started by User_YVX4K Oracle Transactional Business Intelligence Idea Lab
-
Issue with VAT Details Report – Cancelled and Reversed Postings Not IncludedIs it possible to obtain the VAT amounts of a cancelled posting and its reversal, as apparently the system does not support it Any insight, workaround, or confirmation o…Jose Angel RuizMen 21 views 2 comments 0 points Most recent by Syamantak Saha Oracle Transactional Business Intelligence
-
Looking for PO line quantity column in Purchasing Subject AreasHi, I am preparing an OTBI report for Purchase Order and looking for Line Quantity Column, i see Ordered Quantity column in subject area- Procurement - Purchasing Real T…
-
Looking for PO line quantity column in Purchasing Subject AreasHi, I am preparing an OTBI report for Purchase Order and looking for Line Quantity Column, i see Ordered Quantity column in subject area- Procurement - Purchasing Real T…Sudheer YN 43 views 6 comments 0 points Most recent by Sudheer YN Oracle Transactional Business Intelligence
-
2ERP OTBI Archive / Unarchive ability in My Folders for UsersThis was originally reported in SR 4-0000680699. Oracle requested that we create an idea instead. Requirement: To enable the Archive / Unarchive option under "My Folders…Sam Heller 6 views 0 comments 2 points Started by Sam Heller Oracle Transactional Business Intelligence Idea Lab
-
How to save an OTBI report into Reports and Analystics Favorites of Job Managers role in ERPI have developed some OTBI and BIP reports and I would like to centrally save this report in the Reports and Analystics Favorites for list of users / role. (Instead of e… -
Enable custom reports centrally for all Job managers in PPM manage project financial plan analyticsWe are new to Oracle.. How can i enable list of custom report for all users/ or job manager role in the PPM manage project financial plan analytics pop up tab on the rig…
-
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 22 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 8 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 L 21 views 2 comments 0 points Most recent by Claudia Linares L 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. 24 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. 32 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 11 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…Malliga 11 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…