Popular Tags
- OTBI 1,429
- Reporting 1,384
- FDI 1,064
- Analysis and Data Visualization 976
- BI Publisher 841
- Analysis 673
- Oracle Fusion Analytics 577
- Administration 555
- OBIEE 429
- OAC 409
- Analytics 384
- BI Publisher Data Models 346
- Security 288
- Answers 264
- HCM 256
- Analyses 253
- BIP 249
- Developers 243
- Data Modelling and Datasets 224
- Data Connectivity 208
- ERP Analytics Content 205
- BI Publisher Report Templates 201
- Report Output 183
- Oracle Analytics Cloud 170
- Customizing Reports 156
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
OTBI
Discussion List
-
Alter OTBI column properties on multiple columns in one actionIn an OTBI Analysis, is it possible to change the column properties on multiple columns (without having to access column properties on each column separately) - IE; can …C Hammond 22 views 5 comments 0 points Most recent by C Hammond Oracle Transactional Business Intelligence -
Create Customer Statements Seeded Bursting Logic Fails for International CustomersHi, is anyone experiencing this error? ####[2025-09-09T17:48:48.847+00:00] [INFO] dummy file is deleted ================ BIPJobExecutable Execution Started ============ … -
199Report that provides a list of permissions for all folders in BI CatalogOrganization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Oracle Description (Required): There …Saloni Gupta-Oracle 4.1K views 102 comments 199 points Most recent by Ray Switzer Oracle Transactional Business Intelligence Idea Lab
-
24Access Oracle ATP Cloud as a Data Source in BI Publisher in Oracle Fusion Apps CloudOrganization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Deloitte Description (Required): BI P…Kaushik Pola 1.8K views 16 comments 24 points Most recent by LJ_IQPC Oracle Analytics Publisher Idea Lab
-
How do I change YTD to FYTD in a measure column?In the General Ledger Transactional Balances Real Time, there are measures for "Entered YTD CR" and "Entered YTD DR". This gives totals for the calendar year. How do I u…
-
Need 'PO First Approved Date' in the OTBI Subject AreaPlease guide me where we can find in report “PO first approved date”. Because the current reporting is completely wrong since it is always giving the “PO last approved d…Anick B Augustin_SAMC 17 views 2 comments 0 points Most recent by Anick B Augustin_SAMC Oracle Transactional Business Intelligence
-
While creating a credit memo in oracle fusion in credit transactions i am facing the below error.You can't overapply this transaction. (AR-855287) The transaction type assigned to the transaction doesn't allow overapplication. You can only apply a credit or receipt …SAITEJA_01 228 views 3 comments 0 points Most recent by MandeepGupta Oracle Transactional Business Intelligence
-
OTBI analysis - problem with left outer joinHi, I tried this query but it seems that it's not working. It's throwing an error (Formula syntax is invalid). I'm using this query to determine if employees have submit…User_RD03L 73 views 2 comments 0 points Most recent by JustinLitalien Oracle Transactional Business Intelligence
-
3Dynamic display of sets of columns in OTBI or BIP reporting tools depending on run locationOrganization Name Marriott Description Hi We have a gap in our requirements where we need the reports to only display country specific columns. We want our reports (BIP …Michael John Sabaco 14 views 2 comments 3 points Most recent by Rodrigo Baca Oracle Transactional Business Intelligence Idea Lab
-
111Use .xlsx Excel templates in BI PublisherDescription Currently only .xls Excel templates are available. The idea is to support .xlsx Excel templates as well in BI Publisher. Use Case and Business Need If .xlsx …timvanlith1 3.3K views 56 comments 111 points Most recent by NicolòD Oracle Analytics Publisher Idea Lab
-
18Ability to go back to prompt screen on BI Answers - OTBIDescription Once users run a BI answer (based on a subject area) in OTBI, users cannot go back to the prompt screen. When they go back, they have to reenter all the para…Shince Francis-18657 193 views 7 comments 18 points Most recent by Bhaskar Konar Oracle Transactional Business Intelligence Idea Lab
-
7Enabling DFFs on Value Set Values in OTBIOrganization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): アクセンチュア株式会社 Description (R…Risa Fujita 251 views 6 comments 7 points Most recent by Niru - Startek Oracle Transactional Business Intelligence Idea Lab
-
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 653 views 11 comments 0 points Most recent by User_0GPX5 Oracle Analytics Publisher -
Access procurement approval workflows in OTBIHello, Is it possible to access the requisition/order approval workflows to add into an OTBI analysis, the people that a requisition/order is pending to be approved? Tha…Sara González-Gaggero 334 views 14 comments 0 points Most recent by Craig W NNL Oracle Transactional Business Intelligence
-
13Restricting data access in OTBI and BIP Reports using AoR'sOrganization Name Tesco Description Hi Oracle Team, We have a requirement where we need to restrict the employees data related displayed in the OTBI Analysis by specific…C.R.Balaji 491 views 9 comments 13 points Most recent by GPOtimization Oracle Transactional Business Intelligence Idea Lab
-
Field Location Help (License/Cert - Item Code )Summary: I am trying to add the 'Item Code' for license/certifications. I have gone through all the fields under Workforce Profiles - Person Profile Real Time related to…Andrew Mc 117 views 7 comments 0 points Most recent by Mahesh Sharma Oracle Transactional Business Intelligence
-
Delay in syncing data for OTBI real time usage subject area?I Have developed an OTBI report (Analysis) to get the Audit data like usage of OTBI reports in last 6 months using OTBI Real time usage subject Area. but to test that I …Asritha 63 views 8 comments 0 points Most recent by GPOtimization Oracle Transactional Business Intelligence
-
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 61 views 9 comments 0 points Most recent by MandeepGupta Oracle Transactional Business Intelligence -
1Allow the Create Analysis feature to also access data models and not just subject areas.Could you please extend the analysis functionality to also be able to use data models. We find when creating operational working dashboards the analysis works better for…Hylton 6 views 0 comments 1 point Started by Hylton Oracle Transactional Business Intelligence Idea Lab
-
17OTBI Link to Payables Invoice ImageOrganization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Wincanton Description (Required): I a…DennisOliver 426 views 8 comments 17 points Most recent by srirams Oracle Transactional Business Intelligence Idea Lab