Popular Tags
- OTBI 1,474
- Reporting 1,406
- FDI 1,199
- Fusion AI Data Platform 1,040
- Analysis and Data Visualization 1,004
- BI Publisher 875
- Analysis 687
- Oracle Fusion Analytics 612
- Administration 556
- OAC 530
- OBIEE 436
- Fusion HCM Analytics 427
- Analytics 419
- Fusion ERP Analytics 409
- BI Publisher Data Models 361
- Security 301
- HCM 280
- BIP 267
- Answers 266
- Analyses 255
- Developers 246
- Oracle Analytics Cloud 246
- Data Modelling and Datasets 231
- ERP Analytics Content 217
- Fusion Data Intelligence 215
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Report
Discussion List
-
11Add report indicator to show user when the workbook was last refreshedAdd Notification/Report Indicator on Workbook showing when the workbook was last refreshed from database to let the user know if it's using cache data OR using the lates…User_S1MKZ 31 views 0 comments 11 points Started by User_S1MKZ Oracle Fusion AI Data Platform Idea Lab -
3Set number of visible decimals of a measure via a calculationHi everyone, I'm currently building a report that has a varied audience from top level management to first line manager. The numbers we show range from a few k$ to m$. A…Alin-Oracle 33 views 3 comments 3 points Most recent by Luis E. Rivas -Oracle Oracle Analytics Idea Lab -
How to use multiple different Oracle subject areas in one report?I am currently trying to recreate a BI Publisher report that shows Sales and Gross Profit into FDI. We are pulling in fields from SCM-Sales Order, Financials-AR Transact…User_2G0X5 61 views 4 comments 1 point Most recent by User_2G0X5 Oracle Fusion AI Data Platform Forum -
Job change - OTBI reportHello, I would like to create an OTBI report to highlight the date of an employee's business title change. I don't want to use a specific reason code (ex promotion) beca…Jacqueline GRANDIN 41 views 3 comments 0 points Most recent by Bhaskar Konar Oracle Transactional Business Intelligence Forum -
3Report formatting issues in PPT outputWe have a report displaying Performance * Potential matrix of an employee in table layout. The direction of the text (letter Potential) changes from vertical to horizont…Gulani Simran-Oracle 3 views 1 comment 3 points Most recent by MandeepGupta Oracle Analytics Publisher Idea Lab -
I am trying to build an OTBI report that shows PRS with the statusI am trying to build an OTBI report that shows PRS with the status, if it's pending approval i need the name of the current assignee Is it applicable by OTBI ?Eyad Elgarhy 85 views 3 comments 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence Forum -
How to get other fields or more information from ERP fusion modulesI have the following business need: We want to create an AP report to have consolidated information when preparing payments. This report contains detailed information ab…SERGIO BARRETO 41 views 4 comments 0 points Most recent by Ram-Oracle Oracle Fusion AI Data Platform Forum -
HCM Extract failing with error "user: fusion_apps_hcm_ess_appid, permission: 2240"HCM Extract failing with error, please let me know how to resolve this issue: ================ BIPJobExecutable Execution failed with Client received SOAP Fault from ser…ArunBangalore-Oracle 242 views 2 comments 0 points Most recent by MandeepGupta Oracle Transactional Business Intelligence Forum -
Report UsageI've been tasked with establishing a report catalog for my company that shows reports used by the company and organized by functional area. I first need to identify repo…dperezichor 22 views 2 comments 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence Forum -
How can I reuse SQL code generated in OTBI in a Data Model (DM)Here’s the translation to English: I have a question regarding the execution of SQL generated via OTBI. I would like to reuse this report but include some additional ele…Kauan_Bohn 81 views 5 comments 0 points Most recent by Bhaskar Konar Oracle Fusion AI Data Platform Forum -
BIP: Procedure Call DM Error - PLS-00306: wrong number or types of arguments in call to CAST_TO_RAWAs elaborated in the article we are in the process of developing a BIP report identified as a Procedure Call. An input parameter of type String has been included in the …Pradeep Moganti 21 views 1 comment 0 points Most recent by MandeepGupta Oracle Transactional Business Intelligence Forum -
Is it true that oracle is planning to deprecate webservice datasets from BI Data Model?Is it true that oracle is planning to deprecate webservice datasets from BI Data Model? and if its true, what are all the dataset types that will be retained in the futu…Abhilash K - Deloitte USI 41 views 3 comments 0 points Most recent by Federico Venturin - Oracle Oracle Analytics Publisher Forum -
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 101 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 62 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 243 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 321 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 71 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 82 views 2 comments 0 points Most recent by Kauan_Bohn Oracle Transactional Business Intelligence Forum -
1Ability to upload .xlsm (macro enabled excel) file in EPM CloudBusinesses extensively utilize Macro enabled Excel (.xlsm) for ad-hoc reporting. Integrating Excel with SmartView functionalities addresses numerous ad-hoc reporting req…Shivangini Kotiyal 43 views 0 comments 1 point Started by Shivangini Kotiyal Oracle Analytics Idea Lab