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
Oracle Analytics Community
The Oracle Analytics Community helps connect with Data, Analytics, and AI experts, explore forums, events, user groups, idea labs & share data visualizations.
Discussion List
-
OTBI - View only role to access GL subject area dataWe need to provide some non financial users the ability to view General Ledger data (gl balances and gl transactions) without giving functional access to the General Led…Warren N 1 view 1 comment 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence
-
How to fetch and display employee details in rows based on manager hierarchy in OTBI reports.There is a requirement to fetch and display below mentioned fields in an OTBI report based on manager hierarchy. Business Unit Cost Center Cost Center Manager Name Title…Sifat Shaikh 1 view 2 comments 0 points Most recent by Aarthi Natarajan-Oracle Oracle Transactional Business Intelligence
-
OTBI Analysis Seniority Dates pulled into 1 rowPlease, I need help I will like to create an Analysis into a table that shows respective dates of under each respective Seniority Date Rule column. Currently the analysi…AlvinTanCH 1 view 1 comment 0 points Most recent by AlvinTanCH Oracle Transactional Business Intelligence
-
dashboard link expirOrganization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): AdaptHealth, Inc Description (Require…melanie.antoine 1 view 1 comment 0 points Most recent by MiaM-Oracle Oracle Transactional Business Intelligence
-
OTBI report for absence with Accrual, Adjustment and carryover details of an employee.I would like to create an OTBI report to display Accrual, Adjustment and carryover details of an employee. We have updated the carryover and adjustments through data loa…
-
OTBI Analysis Report to get Aligned goal nameWe are creating a OTBI Report With subject area Goal Status overtime real time and Goal Alignments Real time. We want to get the Aligned goal name but we are not able to…kanchana venkatasubramanian 1 view 3 comments 0 points Most recent by Krishnaveni.B -Oracle Oracle Transactional Business Intelligence
-
Logical SQL report does not display values from one subject area for a userWe have built a report on "Costing - Receipt Accounting Uninvoiced Receipt Accruals Real Time" and "Procurement - Purchasing Real Time", to display project details again…BSHAN_LNER 1 view 2 comments 0 points Most recent by BSHAN_LNER Oracle Transactional Business Intelligence
-
duplicate values in OTBI Excel outputIn the OTBI report results tab showing only one record where as in the export showing expected number of rows along with duplicate rows. Please advise any property setti…Sharmava 1 view 4 comments 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence
-
Procurement Spend analysis Report/Dashboard for Top level ExecutivesOur executives looking for for the real-time report/dashboard that will show spend analysis for all associates under their hierarchy (irrespective if transaction require…
-
How to restrict data access in OTBI reports: buyer can only retrieve their own POHi Experts, (Please advise the category of posting this inquiry, I am choosing OTBI as a start, if it is more suitable to Purchasing category then please help to migrate…Liwen Chiu 1 view 3 comments 0 points Most recent by Liwen Chiu Oracle Transactional Business Intelligence
-
Sign In Sign Out Audit report in Oracle FusionSummary: Hello, We have requirement to extract User Sign In, Sign Out and IP Address details through Oracle BIP/OTBI reports. Is there any Seeded report available in Ora…Sushmitha G 1 view 2 comments 0 points Most recent by Kishore Padala-Support-Oracle Oracle Transactional Business Intelligence
-
How to get the Take-Home Pay (Net Pay) of EMP in Oracle HCMI am working on generating reports related to Take-Home Pay (Net Pay) in Oracle HCM, which is the net amount of income a worker receives after deductions (such as taxes,…Trupti Khodke 1 view 1 comment 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence
-
conditional formatting in RTF for duplicateSummary: Is it possible to format rows so that a value is filled with yellow when the value is present in the data more than once? Content (please ensure you mask any co…Alex Glose 1 view 4 comments 0 points Most recent by Alex Glose Oracle Transactional Business Intelligence
-
Oracle Procurement Cloud BIP Report - Does trigger require parameters unique to the trigger SQL?Summary: Trigger SQL returned no data when sharing the same parameter with the report logic. Content (please ensure you mask any confidential information): We are using …C. Joseph 1 view 1 comment 0 points Most recent by C. Joseph Oracle Transactional Business Intelligence
-
Special characters not to be used for OTBIPlease suggest the special characters that are not to be used so that data will not be synced to view data in OTBI.Sunil Nukala2 1 view 2 comments 0 points Most recent by Sunil Nukala2 Oracle Transactional Business Intelligence
-
Banner on Reports & Analytics pageHi , We have noticed a new yellow banner at the top of the 'Home' page in all our environments on Reports & Analytics page since it got upgraded to 24D stating "The Mark…Neha Bhatt 1 view 1 comment 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence
-
OTBI Dashboard Dependent Prompt is not taking another prompt value in sql ?We are trying to create dependent prompt in OTBI. Dependent prompt is created using sql as we need to put some additional conditions. We are using following syntax but i…Ankur Jain--Oracle 1 view 2 comments 0 points Most recent by Ankur Jain--Oracle Oracle Transactional Business Intelligence
-
OTBI Query to Retrieve the Most Up To Date Record of a Learners Learning AssignmentI have been having issues with trying to pull the most up to date learning assignments for people for a report. I have been using WLF_ASSIGNMENT_RECORDS_F and it is all …marcfromhawaii 1 view 1 comment 0 points Most recent by marcfromhawaii Oracle Transactional Business Intelligence
-
Time Series Calculations - Using a Count Measure for YTDHello all, I'm attempting to create a measure using the time series calculation of TODATE to achieve YTD numbers. For example, if I need to achieve YTD invoice amounts t…Pete 17 1 view 2 comments 0 points Most recent by Pete 17 Oracle Transactional Business Intelligence
-
Setup IBAN for EMEA population in OracleSummary: We need to setup Banking Info within Oracle and unsure how to set this up for the EMEA population using “IBAN”. Can anyone guide me the process do the same? Con…Abinaya P 1 view 1 comment 0 points Most recent by Bianca Lei Villareal Oracle Transactional Business Intelligence