Popular Tags
- OTBI 1,433
- Reporting 1,386
- FDI 1,087
- Analysis and Data Visualization 981
- BI Publisher 845
- Analysis 676
- Oracle Fusion Analytics 579
- Administration 555
- OBIEE 432
- OAC 426
- Analytics 395
- BI Publisher Data Models 350
- Security 291
- Answers 264
- HCM 257
- Analyses 254
- BIP 253
- Developers 244
- Data Modelling and Datasets 226
- Data Connectivity 211
- ERP Analytics Content 208
- BI Publisher Report Templates 204
- Report Output 184
- Oracle Analytics Cloud 177
- Customizing Reports 159
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
-
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?
-
Disable or Hide Email option on the results page of an OTBI ReportWhen we click on the Email option that appears along with Export, Print, Copy on the Results page of an OTBI report, the raw data is dumped to the email address. This is…
-
Automatic Backup of All Custom BI Reports and AnalysesFusion Applications BI - How To Take a Automatic Backup of All Custom BI Reports and Analyses Hello, We want to take backup of All Custom BI Reports and Analyses & custo…
-
Usage of PVOs GLOBALPERSONPVOVIEWALL and PERSONDETAILSPVOVIEWALLWe are building a BICC extract to extract person and their assignment data, wanted to understand when should we use GLOBALPERSONPVOVIEWALL and PERSONDETAILSPVOVIEWAL
-
is it possible to copy all users' reports from their own folders to the Share folder?Summary: Hi, Who can advise: is it possible to copy all users' reports from their own folders to the Share folder? For example, I have created a report and saved it in M…