Popular Tags
- OTBI 1,429
- Reporting 1,383
- FDI 1,062
- Analysis and Data Visualization 976
- BI Publisher 840
- Analysis 673
- Oracle Fusion Analytics 577
- Administration 555
- OBIEE 429
- OAC 408
- Analytics 382
- BI Publisher Data Models 346
- Security 288
- Answers 264
- HCM 256
- Analyses 253
- BIP 248
- 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 169
- 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
-
Table Location of To/From Dates for Talent RatingsI am looking to find the the save table location for the To/From dates for the Talent Rating module. This is for a BI publisher report using a Data Model. The associated… -
Why this field is empty?I have created a report from the subject area "Workforce Performance - Performance Rating Real Time", in which it's extracted the field "- Rating Level"."Rating Level Co…
-
Formula to Calculate Between Two DatesI've added a column to my OTBI analysis to calculate the days between when a Requisition is approved to when the corresponding Purchase Order is approved. Since the date…
-
Hi, i'm new to Fusion, coming from PeopleSoft. Does Fusion use the CEMLI tool to migrate processes?if not, what tools are available to migrate processes (i.e. SQL, etc) from one instance to another? we are developing with OTBI thanks Fred
-
OTBI - Edit column formula to include a filterIs it possible to edit the column formula so that it will only show values with specific criteria? More specifically, I'm trying to add in AOR Responsibility information…
-
OTBI Analysis - Convert Datetime value to Date (only)How do I convert a datetime value to a date only value: "10/16/23 9:24 PM" to "10/16/23" Should be simple, right? 😏
-
Extract Data Stores for the Shared HR and Projects in BICC (Business Intelligence Cloud Connect)Hello....we are looking for the "Extract Data Stores" to create a Business Intelligence Cloud Extract for the Fusion Projects and Shared HR modules. Can you advise if an…
-
How to change the week definition to ISO-8601 (1st day of the week being a Monday)In OTBI the week definition is using the American standard, Week = Sunday - Saturday. But in Europe we do use ISO-8601. Week = Monday - Sunday. Also week number itself c…
-
I'm currently working on a OTBI report with a requirement of Plan Participation Details.Question: I need the Purchase Plan Hours , Plan Current Balance Hours & Plan Used Hours. Upon building the report I encounter some issue if the employee have a multiple …
-
How to extract OTBI reports with HTML FormattingHi Experts, I need your assistance. I need HTML PAGE formatting in my OTBI report XML format. As you can in see the first picture, I have set formatting for internal des…
-
Extracting all Columns from BIP Query without creating layout?Content Hi Guys I have to extract all the columns from 11 different tables for our finances guys to sift through and see what data they want. Some of these tables have 1…
-
Extract Data with HTML formattingHello Experts, I need your assistance regarding fetching data with HTML formatting in the OTBI Report. Currently, I'm working on the 'recruiting - recruiting real time' …
-
We have created few OTBI Infolets and enabled it through sandbox at Sales InfoletsHi Experts, We have created few OTBI Infolets and enabled it through sandbox at Sales Infolets, but these sales infolets are not visible to other users. We need to enabl…
-
Restrict the view of a OTBI report only for a RoleWe wanted to restrict the view of a OTBI report only for a role - Field Service Administrator. This role has the BI Consumer Role added to it already. But when we added …
-
How to change the default date format from MM-DD-YYY (American) to DD-MM-YYYY (European) in OTBIThe default date-format in OTBI is MM-DD-YYY. In Europe we use DD-MM-YYYY. Now we need to modify all date columns and change the format of the column. But if we could ch…
-
Build a OTBI analysis using 2 subject areas but results is giving blank table.I am trying to build a OTBI analysis in oracle fusion application using two subject areas ' Risk Management Cloud - Advanced Financial Controls Real Time ' and ' User Sy…
-
IPEDS reporting in Oracle Cloud HCMThe IPEDs report is a mandatory report for US higher education. Is this delivered in Oracle Cloud HCM? I see references to IPEDs in certain Oracle Cloud documentation bu…
-
Pivot Online template for BIP report- Column Heading setupI created a BIP datamodel and tried to create pivot online template but i am unable to set BIP report Column Heading for Online Pivot template created. Pivot is working …
-
-
Can we zip the OTBI output file and emailHi All, We have a requirement to zip the output CSV file of an OTBI analysis before emailing it. Is it achievable?