Popular Tags
- OTBI 1,514
- Reporting 1,429
- FDI 1,349
- Fusion AI Data Platform 1,054
- Analysis and Data Visualization 1,025
- BI Publisher 908
- Analysis 699
- Oracle Fusion Analytics 641
- OAC 628
- Administration 568
- Fusion HCM Analytics 477
- Fusion ERP Analytics 473
- Analytics 466
- OBIEE 446
- BI Publisher Data Models 372
- Oracle Analytics Cloud 317
- Fusion Data Intelligence 314
- Security 314
- Fusion Data Intelligence FDI 308
- HCM 301
- BIP 275
- Answers 267
- Analyses 258
- Developers 251
- Data Modelling and Datasets 242
Report
Discussion List
-
How to edit column formula to apply filter and save for reuse?I want to create a series of columns with filtering for my colleague's easy use. I know that filters can be saved, but I would like to explore how to set the filter in a…User_60BGL 186 views 10 comments 0 points Most recent by User_60BGL Oracle Transactional Business Intelligence Forum -
OBI TIMEZONE: OPERA CLOUD VS OPERA R&A Timing ARE NOT MATCHINGHi team, My time in Opera is Different from time in the report generated in R&A . R&A uses GMT time zone. I am based in Doha (GMT+3), so the report is showing data 3 hou…
-
How to confirm if email was successfully sent using BIP Bursting.We are looking at possible options available in Oracle Fusion to confirm if the email was successfully sent to recipients using BIP Bursting. This is from an audit stand…Suprit 132 views 1 comment 0 points Most recent by MandeepGupta Oracle Business Intelligence Applications Forum
-
Security on reporting OTBIGood morning, I hope this message finds you well. I would like to kindly ask if it’s possible to assign a user the BI Author role only for a specific group of Subject Ar…AM HRE 453 views 3 comments 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence Forum
-
Issue with Bursting Query in Oracle Report: "There is no data to process" ErrorI have created a report in Oracle that outputs data correctly when run on its own. However, when I attach a bursting query and run it through an ESS job, I receive the e…Sree29 495 views 1 comment 0 points Most recent by Pattabhi Chereddy Oracle Analytics Publisher Forum
-
How to get the last degree if the worker have 2 records in a Analysis and ReportHi @Everyone, How do we get the last degree if the worker has 2 or more records in an Analysis and Report? We need to get the last degree considering their last start da…Claudia Linares L 164 views 8 comments 0 points Most recent by Claudia Linares L Oracle Transactional Business Intelligence Forum -
Help with Transaction History Report in OTBI (DUE DATE and OUTSTANDING BALANCE)I aim to generate a comprehensive report of transaction history. I need the fields DUE DATE and OUTSTANDING BALANCE of the transaction to be displayed in my analysis. Fo…Kauan_Bohn 123 views 2 comments 0 points Most recent by Kauan_Bohn Oracle Transactional Business Intelligence Forum -
5Custom labels for bars visualizationsIn the current version we are not able to customized measure labels as it's possible in i.e. Pivot Tables with Custom Headers. Possible in Pivot Tables… …but not possibl… -
How can I possibly embed a report created from a data model in a dashboard?I am currently having performance issues when using 'Sales CRM - Customers' subject area when creating an analysis in OTBI. I am thinking to do a workaround by creating …Ivony Ann Paula Salango 13 views 1 comment 0 points Most recent by Alexandru Burcea-Oracle Oracle Transactional Business Intelligence Forum -
Why does the subject area 'Sales - CRM Customers' is not showing results promptly?Maybe you can help me identify the reason why the subject area for accounts is so slow at showing results. Or is it better to create a custom subject area?Ivony Ann Paula Salango 125 views 6 comments 0 points Most recent by Ivony Ann Paula Salango Oracle Transactional Business Intelligence Forum
-
Pivot row header nameI am trying to do a Pivot but the name is not appearing for the header. I am also trying the same in Pivot for bi publisher but not sure how to do it XML is attached. Co…Dhevina 31 views 1 comment 0 points Most recent by Hassan El Bouihi-Oracle Oracle Transactional Business Intelligence Forum
-
Oracle Analytics BICC vs BIPFrom Oracle documentation I understand that BI Publisher (BIP) and BI Cloud Connector (BICC) is used for exporting bulk data from ERP Cloud I have used BIP in the past a…JoyP 3K views 4 comments 1 point Most recent by C. Joseph Oracle Business Intelligence Applications Forum
-
How to call BIP report using REST API?Hi all, we want to call BIP report using rest api service, we were able to call it using soap using the Basic Auth however when using the rest api it's saying 404 not fo…mayank_tripathi 1.1K views 4 comments 0 points Most recent by Gianni Ceresa Oracle Analytics Publisher Forum
-
I need to Employee Signed Date and Manager Signed Date from the position description documenti need a SQL query to fetch the Employee digitally Signed Date and Managers digitally Signed Date from position description Document which is attached in DOR. Please let…Chetana2000 31 views 1 comment 0 points Most recent by RajeshPolavarapu-Oracle Oracle Fusion Data Intelligence Forum
-
OTBI Report : Department level DFF issueWe have an OTBI report which pulls the employment level details and department level details of an employee. We would like to pull certain detail of the departments base…Amulya Kadiyala 23 views 1 comment 0 points Most recent by John Hung-Oracle Oracle Transactional Business Intelligence Forum
-
Excel is not considering my date value as date even after I tried many formatting? Need suggestionI am creating a XML publisher report where the date in the excel output should be in 'MM/DD/YYYY' format. Here I am able to achieve this format in excel however my excel…User_90781 91 views 2 comments 0 points Most recent by Nehemias-Oracle Oracle Analytics Publisher Forum
-
What is the difference between Refresh Data and Reload Data within the functional areas?I would like to know the difference between these two options within the functional areas, because we made an update in the financial categories of the accounts but the …SERGIO BARRETO 175 views 1 comment 1 point Most recent by Sumanth V -Oracle Oracle Fusion Data Intelligence Forum -
Can you reference other parameters in the initial value's logical SQL?For our projects report, we'd like to create a project manager parameter where we set the the project manage equal to the display name so that when project managers acce…Caroline Blanchard 135 views 5 comments 1 point Most recent by David Saggioro Oracle Fusion Data Intelligence Forum -
2Not able to calculate aggregated amounts for 'Discount' Column in Purchase Order Line Detail FolderWe have a requirement to generate reports in FDI that display the following metrics for Purchase Orders (POs): PO amount before discount Discount amount PO amount after …
-
Bursting ReportHi everyone, I need your help regarding bursting report. I created two Data models G_1 and G_2. In G_1, The query fetches the list of employees whose probation is about …