Popular Tags
- OTBI 1,450
- Reporting 1,395
- FDI 1,130
- Analysis and Data Visualization 988
- BI Publisher 858
- Analysis 682
- Oracle Fusion Analytics 593
- Administration 555
- OAC 467
- OBIEE 433
- Analytics 404
- BI Publisher Data Models 358
- Security 295
- HCM 270
- BIP 265
- Answers 264
- Analyses 255
- Developers 246
- Data Modelling and Datasets 229
- Data Connectivity 210
- ERP Analytics Content 210
- BI Publisher Report Templates 205
- Oracle Analytics Cloud 202
- Fusion Data Intelligence 193
- Report Output 184
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
OTBI
Discussion List
-
OTBI access queryHi I have the access for Subject Area in OTBI but the metrics are showing zero while creating report you had any idea , what kind of access is missing for meSumanth Nimmagadda 16 views 2 comments 0 points Most recent by RVohra Oracle Fusion Data Intelligence -
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 223 views 22 comments 0 points Most recent by RVohra Oracle Transactional Business Intelligence -
Fixed Assets - Columns: "Net Book Value" vs "NBV Before Impairment"We are currently implementing Fixed Assets in Oracle Fusion ERP and would like assistance from FA SMEs as we have begun work on OTBI dashboards and reports: The 23B Data…Chris Pfeifer 77 views 2 comments 1 point Most recent by RVohra Oracle Transactional Business Intelligence -
4OTBI - Accounting Period Number - General Ledger - Balances Real TimeOrganization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Guys and St Thomas NHS Foundation Tru…Narinder Sian 28 views 1 comment 4 points Most recent by Eirik Stoltz Oracle Transactional Business Intelligence Idea Lab -
Create custom app tile for OTBI DashboardWe created a dashboard that is used by Recruiters. They access this by going to Tools → My Reports → and navigating to the appropriate tab. I was wondering if it is poss…MarkS 151 views 10 comments 0 points Most recent by Robert M Bell Oracle Transactional Business Intelligence -
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 6 views 0 comments 0 points Started by Anick B Augustin_SAMC Oracle Transactional Business Intelligence -
Person Records Secured By AOR Does Not Restrict Data Reflected In OTBI ReportsSummary: Hello Everyone ! I am trying to secure the data returned by HR_ANALYST job role by using an AOR with a scope of Department. Although, it works fine in the HCM U…Maruvada Sanat Kumar-Oracle 924 views 14 comments 0 points Most recent by MandeepGupta Oracle Transactional Business Intelligence -
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 776 views 12 comments 0 points Most recent by Vanitha Kundaram Oracle Analytics Publisher -
20Ability 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 245 views 8 comments 20 points Most recent by Ruchika Gujarathi Oracle Transactional Business Intelligence Idea Lab -
Time Card StatusHi everyone, I am trying to create a BIP report for Time Card Change History which includes both "Time Entry" and "Time Card Status". For Time Card Status, I am trying t…Candy Miles Domingo 208 views 2 comments 0 points Most recent by Kaustubh Deshmukh Oracle Transactional Business Intelligence -
51Access Output files from ESS jobs submitted by a different user without BI Administrator RoleOrganization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Deloitte Description (Required): User…User_D2ACY 1.3K views 23 comments 51 points Most recent by Anjula Mittal Oracle Transactional Business Intelligence Idea Lab -
2Change the Toggle Maintenance Mode DesignOrganization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): American Express Description (Require…AprilMaurer 37 views 1 comment 2 points Most recent by User_MW0AT Oracle Transactional Business Intelligence Idea Lab -
48OTBI Analysis Export to Excel or CSV limitationHi Team, The OTBI Report export to excel or csv limited to 250k rows.This Limit is very small for business requirements .It's better to provide some configuration to inc…Namratha Cheeti 1.5K views 7 comments 48 points Most recent by KarthikDamamkar Oracle Transactional Business Intelligence Idea Lab -
6Enable email domain restriction option for OTBI report as wellHello, We need an option to enable the email domain restriction for OTBI report. For BIP Reports we may restrict the "Allowed Email Recipient Domains" to our internal do…UchihaItachi 14 views 0 comments 6 points Started by UchihaItachi Oracle Transactional Business Intelligence Idea Lab -
117Use .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.9K views 57 comments 117 points Most recent by NicolòD Oracle Analytics Publisher Idea Lab -
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 36 views 5 comments 0 points Most recent by C Hammond Oracle Transactional Business Intelligence -
25Access 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.9K views 16 comments 25 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… -
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 248 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 121 views 2 comments 0 points Most recent by JustinLitalien Oracle Transactional Business Intelligence