Popular Tags
- OTBI 1,393
- Reporting 1,364
- FDI 948
- Analysis and Data Visualization 940
- BI Publisher 814
- Analysis 660
- Administration 551
- Oracle Fusion Analytics 541
- OBIEE 420
- Analytics 339
- BI Publisher Data Models 335
- OAC 323
- Security 267
- Answers 260
- Analyses 253
- Developers 239
- HCM 236
- BIP 232
- Data Modelling and Datasets 217
- Data Connectivity 206
- 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
Discussion List
-
Need solution to create an OTBI report to find AHCS Subledger Entry's Line level informationHI All, I am working on AHCS/FAH module and need to create an OTBI report to fetch the Line level details for a transaction loaded to Oracle using AHCS template. The dat…Shiwani Shrivastava 23 views 1 comment 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence -
OTBI Logical SQL complex query assembler - Updated to 10 subject areasSummary Combine analyses from up to 10 different subject areas Content While building a report on OTBI, you will encounter some cases where the Subject Area will only pr…Maxime Pignot-Oracle 836 views 16 comments 1 point Most recent by Bhaskar Konar Oracle Transactional Business Intelligence
-
2Contact Date of DeathAdd Person Contact Date of Death to the Person Contact Relationship folder in 'Workforce Management - Person Real Time' and 'Benefits - Person Information Real Time' sub…lwoodworth 7 views 1 comment 2 points Most recent by MandeepGupta Oracle Transactional Business Intelligence Idea Lab -
Is it possible to remove a certain field/column from the output of CSV file in OTBI report?Hi, Good day! I have a problem with a business requirement where-in some IDs in the data model are being extracted when the report is exported in CSV file format. As you…Ivony Ann Paula Salango 32 views 8 comments 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence -
Does BICC supports any other encryption option other than GPG?We have created BICC reports and using UCM as a delivery location for the generated extracts. We are able to configure encryption on top of it and getting files generate…Dipendra 202 views 4 comments 0 points Most recent by Kalimuthu V GSC-Oracle Oracle Analytics Cloud and Server
-
Agent Condition Evaluates to False Despite Analysis Returning RowsHi everyone, I'm setting up an agent in Oracle BI with a condition based on an analysis. The configuration is as follows: Create condition based on: Analysis Condition D…Basti 11 views 1 comment 0 points Most recent by Bhaskar Konar Oracle Transactional Business Intelligence
-
Procurement - Buyer Productivity dashboard is not returning dataProcurement dashboard "/shared/Procurement/Dashboards/Procurement/Buyer Productivity" is not returning any data when we are passing the value for buyer parameter. Althou…Pankaj Pandey 41 views 14 comments 0 points Most recent by Bhaskar Konar Oracle Transactional Business Intelligence
-
How to have Action Link on Totals but not on detail rowsSo I have an OTBI Analysis which has navigation link on certain columns using the standard interactivability functionality on the column properties. I have enabled these…Robert of STAU 31 views 1 comment 0 points Most recent by Gaurav Bharadwaj-Oracle Oracle Transactional Business Intelligence
-
Subledger OTBI Analysis - Report ran for one transaction number spinning until time-outThe issue with this report is with applying a filter to this field: "Subledger Accounting - Journals Real Time"."Journal Details"."Transaction Number". This is not a new…User_5OKPE 25 views 7 comments 0 points Most recent by Bhaskar Konar Oracle Transactional Business Intelligence
-
I am trying to get first submission dateHello All, I am working on dashboard and I am trying to find the first submission date for the supplier registration. as you can see in the following picture. Procuremen…Khalid Aldosari-Oracle 21 views 3 comments 0 points Most recent by Bhaskar Konar Oracle Transactional Business Intelligence
-
How to Restrict Infolets for Business Unit(BU) created under Analytics in Oracle Fusion.How to restrict the Infolet for Business Units is there any EL expression for this? I trued to restrict it's Visibility for Role using EL Expression and it's working i.e…
-
10Ability to report on Calculation Card Association in OTBI.Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Northumberland County Council Descrip…Julie Watson 144 views 4 comments 10 points Most recent by MandeepGupta Oracle Transactional Business Intelligence Idea Lab
-
How to fetch Recipient details from Leave Donation Real Time Subject Areai was trying to fetch the absence donation Recipient details like (First name Last name of Recipient and Alias details ) i was not able to drag and drop those columns. I…MohammedAmeenmfp10 23 views 8 comments 0 points Most recent by MohammedAmeenmfp10 Oracle Transactional Business Intelligence
-
2Need Person level data- add Worker Dimension to Payroll-Payroll Costing Setup details Real Time SAOrganization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Hillsborough County Description (Requ…Laxmi Ghanta 15 views 2 comments 2 points Most recent by KSA-F15 Oracle Transactional Business Intelligence Idea Lab
-
How to fetch the Contribution requested by employee (Cash disbursement) in OTBICan someone help to fetch the details of the hours which are raised for cash disbursement in OTBIMohammedAmeenmfp10 11 views 2 comments 0 points Most recent by MohammedAmeenmfp10 Oracle Transactional Business Intelligence
-
DFF fetching only code in OTBIWe have many DFFs configured in HCM. On front end HCM, we can see the full description eg for local job title, but in OTBI the field only returns the job code. Is there …Swapna Govind 93 views 18 comments 1 point Most recent by MandeepGupta Oracle Transactional Business Intelligence
-
Hide Subject area and catalog folders which are not neededHi All, Can we hide the subject area while creating any new analysis in OTBI which are not relevant or client has not bought the license for that module ? Similarly , ca…Ankur Jain--Oracle 42 views 13 comments 0 points Most recent by Ankur Jain--Oracle Oracle Transactional Business Intelligence
-
OTBI Fields translation spreadsheet to BI FieldsHello! I have an outdated version (19C) of an excel spreadsheet of OTBI Subject Areas where you can find the column name/table in BI Publisher. Cover Page tab is titled …Lauren W 23 views 3 comments 0 points Most recent by Lauren W Oracle Transactional Business Intelligence -
Assistance Needed for Implementing Custom CSS in OTBI ReportsI am working on Fusion Application and I want to create a CSS file that I can use for custom styling in my analyses. Specifically, I want to utilize classes from this CS…Controlcard 40 views 2 comments 0 points Most recent by Bhaskar Konar Oracle Transactional Business Intelligence
-
Why is the modified date changing on the seeded OTBI reports?Hi, I have noticed that modified dates on the seeded OTBI reports are changing. I do know that whenever there is a patch applied to the instance the modified dates may c…Shravani 1 view 2 comments 0 points Most recent by MandeepGupta Oracle Transactional Business Intelligence