Popular Tags
- OTBI 1,428
- Reporting 1,383
- FDI 1,061
- Analysis and Data Visualization 976
- BI Publisher 840
- Analysis 673
- Oracle Fusion Analytics 577
- Administration 555
- OBIEE 429
- OAC 405
- Analytics 382
- BI Publisher Data Models 346
- Security 288
- Answers 264
- HCM 256
- Analyses 253
- BIP 247
- Developers 243
- Data Modelling and Datasets 223
- Data Connectivity 208
- ERP Analytics Content 205
- BI Publisher Report Templates 201
- Report Output 183
- Oracle Analytics Cloud 168
- Customizing Reports 156
Welcome to the Oracle Transactional Business Intelligence Community Forum!
Whether you're a seasoned user or just starting your journey with OTBI, the solution for transactional reporting in Fusion Apps, this forum is your go-to for questions and discussions. Connect with experts, seek advice, share insights, and post product recommendations in the Idea Lab.
If you're new to OTBI, visit our Doc Library and OTBI Resources pages for more details and answers to common questions - links to these and more are available in the Knowledge Base: https://community.oracle.com/products/oracleanalytics/kb/articles/62-resources-for-oracle-transactional-business-intelligence-otbi
For OTBI inquiries on subject areas and use cases, please direct your questions to one of our OTBI pillar forums (HCM, ERP, SCM, Sales, Field Service) on Customer Connect to receive tailored assistance.
Whether you're a seasoned user or just starting your journey with OTBI, the solution for transactional reporting in Fusion Apps, this forum is your go-to for questions and discussions. Connect with experts, seek advice, share insights, and post product recommendations in the Idea Lab.
If you're new to OTBI, visit our Doc Library and OTBI Resources pages for more details and answers to common questions - links to these and more are available in the Knowledge Base: https://community.oracle.com/products/oracleanalytics/kb/articles/62-resources-for-oracle-transactional-business-intelligence-otbi
For OTBI inquiries on subject areas and use cases, please direct your questions to one of our OTBI pillar forums (HCM, ERP, SCM, Sales, Field Service) on Customer Connect to receive tailored assistance.
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Oracle Transactional Business Intelligence
Discussion List
-
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… -
Budgetary Control Results Report by TransactionWhat are the tables that contain transactional information pertaining to budget control data? Could we have query of "Budgetary Control Results Report by Transaction" re…
-
Oracle Fusion Budgetary Control Transaction Subject Areas.Hi, I use the budgetary control transaction subject area to show a transaction with purchase order transaction type. I want to display the item number of the purchase or…
-
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 … -
Where to find Taxable Benefit, Associations, Tax Reporting Unit, Effective Start dateHi, I'm attempting to extract the Effective Date of the Tax Reporting Unit in Associations for a Taxable Benefit in OTBI. I'm using Subject Area Payroll - Calculation Ca…
-
Disable auto run in OTBI analysisHi Team, OTBI analysis report running automatically without giving parameters and getting results which creates confusion to business/user. So could you please try to he…
-
OTBI Dashboard Prompt Timestampadd Formula for Default End Date Covering through EOD 11:59:59pmI needed to default the begin and end date dashboard prompt for First Day of Previous Month through Last Day of Previous month using the following timestamp formulas res…
-
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…
-
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…
-
"sensitive data access audit real time" subject area does not show resultsWe are recently searching for audit information and found the subject area "sensitive data access audit real time", however, no results are shown.I searched the document…
-
Data Model with single parameter not returning sql query resultsi am trying to create a very, very simple data model, to turn into a bip report, that contains one parameter. the data model query works independently of the parameter (…
-
Replace function is not working in OTBI Dashboard PromptHi Team , we have created dashboard prompt where we have two parameters . Parent department and Child Department. Parent department is sql result type and have presentat…
-
BI FTP Server setup screen missing Test connection buttonI am trying to 'Add Server' under Manage Publisher > FTP. The screen allows me to input all the details but 'Test Connection' and 'Apply' buttons are missing. I have emp…
-
Report 2x - 5xing values when using the hierarchical tiersI'm having issues trying to get the right data when using the object 'Level 22 Value' in Natural Account Segment under the General Ledger - Transactional Balances Real T… -
Display of Total Row Cell at the Top of the Data TableIs it possible to display the Total Row Cell at the top of the table instead of last row in the data table. Currently, there are only 2 options displayed when hovering o…
-
How to use multiple aggregates In OTBIHello, I am brand new to OTBI, and am having a little bit of difficulty providing the analysis that my business is requesting of me. The end result should look like this…
-
Logical SQL analysis- Prompt error -Failed to load(Error during query plrocessing (SQLExecDirectW).)Dear experts, I have created a logical SQL analysis and created column prompt for Requisition Number and getting below error, it is displaying the results when i go to r…
-
Where can i find incumbent details dates allocated in position through Subject Area OTBI?We created BI using the subject area” Workforce Management – Position Real Time” , but don’t find the “Position Entry Date” and “Position Exit Date”
-
Workforce Management - Worker Assignment Real Time: pulling Active and inactive assignment statusesHow to get the current assignment status of worker using "Workforce Management - Worker Assignment Real Time" , it is showing both inactive and active assignment statuse…
-
OTBI - Exported XML Data Model is not show in lower caseHello When exporting a report in XML format through BI, the XML tags are in upper case and not lower case. Please could you confirm if this behavour system?