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
-
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…
-
How to create an RTF TemplateHi all I've tried to create a RTF template but I have a problem with the first step about the guide. I don't understand what it means " To obtain the sample XML file, su…
-
How to archive whole catalog (Shared and Users)?With an administrator role, I would like to archive the whole analytics catalog to backup all Analytic Objects (even the objects in users folders). During P2T or when a …
-
Compare two fields from different Subject Areas in OTBII have written an OTBI analysis containing several fields however I am having an issue when I create a field with a Case statement to compare the below fields. Subject A… -
Calculating wrong values in Subtotals.As I calculate the subtotals in the tabular report for which I work as a BI developer, the calculation is automatically producing incorrect results.
-
How to Fetch more than 1000 records with BIP or OTBI reportSummary: Fetch more than 1000 records with BIP or OTBI report. Content (required): Hi, How to fetch more than 1000 records with BIP or OTBI report. I tried with Paramete…
-
Oracle BICC SOAP based extractionWe are trying to run a BICC extracts via SOAP API, Is it mandatory to have WSA-Addressing in header of the SOAP API payload? submitRequest 1234567 As per oracle document…