Popular Tags
- OTBI 1,448
- Reporting 1,394
- FDI 1,123
- Analysis and Data Visualization 988
- BI Publisher 856
- Analysis 682
- Oracle Fusion Analytics 591
- Administration 555
- OAC 454
- OBIEE 433
- Analytics 403
- BI Publisher Data Models 356
- Security 293
- HCM 268
- BIP 264
- Answers 264
- Analyses 255
- Developers 246
- Data Modelling and Datasets 229
- Data Connectivity 210
- ERP Analytics Content 210
- BI Publisher Report Templates 204
- Oracle Analytics Cloud 197
- Fusion Data Intelligence 187
- Report Output 184
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
-
Is there any possibility to get latest job change date in OTBI ReportHi Experts, Good Day!! Can someone please let me know how to get the latest job change date in OTBI Report For Example, one employee Job changed from "AA" to "BB" on 01-… -
Is there a way to add calculated row in the pivot table (OTBI Analysis)Summary: Is there a way to add calculated row in the pivot table (OTBI Analysis) Content (required): I am trying to create an analysis like below using pivot table funct…
-
Link Payroll Run Results Real Time and Payroll Flows Real Time for Processed Date from Payroll FlowsSummary: We have a supplemental payroll cycle that runs weekly. During the Payroll Flow set up the Payroll staff uses the "Override" date on the flow parameters in order…
-
OTBI report gives an error when add Workforce Management - Person Real time subjectDear , I have an OTBI report which works fine on subject Workforce Management - Worker assignment Real time but i need two more column which is in Workforce Management -…
-
Is write back supported in OTBI in SaaS?See https://docs.oracle.com/middleware/12211/biee/BIESG/GUID-6F16F7CA-E525-4569-A5A0-C1C0F851F57E.htm#BIESG1354 Is this functionality also available in OTBI in the SaaS?
-
Invalid date in BIP report for some usersHello, We have an issue where some of our users are seeing invalid dates in the BIP report. e.g. actual date in table (at db level) is 15-Nov-21 but certain users are se…
-
How do we create a role to view OTBI analysis for a user that doesnt have transactional access?Summary: We have users that dont work with AR, but we want them to be able to open OTBI analysis made with AR subject areas. We tried creating a Financials role with the…
-
How can you edit the subject area of a report?Summary: Can I edit the subject area/column of a report? I only want a portion of the information to appear on the report. Content (required): Version (include the versi…
-
Prompt on empty datesSummary: We need to have a prompt where you can not only filter on a date range but also on the empty date fields Content (required): We want to filter in the prompt on … -
How to link Receivables - Customer Real Time and Receivables - Payment Schedules Real Time in OTBISummary: I am wanting to create a report with certain bill-to customer information that is not located within the Receivables - Payment Schedules Real Time subject area,…
-
How to verify and validate correct date formats in OTBI where the column is supporting references.Summary: We have a scenario where we are using a supporting reference column and casting it as date. But due to multiple formats of date being entered in the column with…
-
REST API for Oracle BI Publisher not working in 22AHi Everyone, Tried calling REST API for Oracle BI Publisher from postman but got error from Oracle Public cloud with 404 code and page not found error message. Not sure …
-
Oracle Autonomous Data Warehouse (ADW) and OTBISummary: Hi, I would like to understand if we can integrate ADW with OTBI. Our client currently uses ADW functionality and would like to understand if they can access th…
-
Hide Seeded Folders from Reports and AnalyticsSummary: We are able to hide customs Folders by Using Shell role and and Permission feature. However While trying the same with Seeded Folders or the folders within them…Shashank Verma-Oracle 151 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle
-
Calculated column with interval between start and end dates selected in promptSummary: When i select the start and end dates in a prompt, i want to have a calculated column that shows the interval between the start and end dates, i want to use thi…
-
OTBI Report running into error when I add Sum on a column-Sort has no work space in the work directoSummary OTBI Report running into error when I add Sum on a column-Sort has no work space in the work directory. Content Hi, I have an OTBI Report running into error when…
-
Text AnalyticsSummary step by step procedure to proceed Text Analytics in OBIEE 11g Content Hi, I need step by step procedure to proceed Text Analytics in OBIEE 11g. I'll be happy to …
-
how to auto run an analysis with promptSummary: I have created an analysis with prompts. I want that when an analysis is run, it should display the output with default prompt option 'All Column Values'. Curre…
-
Why does the table edit page return results but the results page error?Summary: I have created a case when clause in my OTBI report which should return a column of show or group based on the criteria. When I see it in the table edit view, i…
-
R13 21D Financials OTBI database mapping with ViewObjectsSummary: Where can we find R13 21D Financials OTBI database mapping with ViewObjects? Content: Where can we find R13 21D Financials OTBI database mapping with ViewObject…