Popular Tags
- OTBI 1,492
- Reporting 1,414
- FDI 1,253
- Fusion AI Data Platform 1,048
- Analysis and Data Visualization 1,015
- BI Publisher 888
- Analysis 696
- Oracle Fusion Analytics 626
- OAC 570
- Administration 561
- OBIEE 443
- Fusion HCM Analytics 440
- Analytics 437
- Fusion ERP Analytics 433
- BI Publisher Data Models 366
- Security 311
- HCM 294
- BIP 272
- Oracle Analytics Cloud 271
- Answers 267
- Analyses 257
- Developers 249
- Fusion Data Intelligence 243
- Data Modelling and Datasets 237
- ERP Analytics Content 221
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Function
Discussion List
-
extract substring into new column FDIHi! I have this FDI subject area and was trying different types of SQL functions with not much success. Can you please help with this issue? I would like to extract from…Raluca Balan-Oracle 37 views 2 comments 1 point Most recent by RVohra Oracle Fusion Data Intelligence Forum -
6Filter Function for New Column in LSAIn creating a new column in a Localized Subject Area (LSA), we would like to be able to use the Filter() function. Currently it is not available within this area. -
Can we use LISTAGG function in OAC Dataflow inside Aggregate function?I came across a couple of blogs(below) on how to use LISTAGG function in dataflows. I am not getting LISTAGG in the dropdown as displayed in the first blog and even when… -
16New function that counts only business days in date calculationsWhen creating date calculations, sometimes including weekends causes the new measures to be inaccurate. For example, when counting the time in between a submission date …Caroline Blanchard 101 views 3 comments 16 points Most recent by Patrick Koob Oracle Analytics Idea Lab -
Filter function for date condition error in OAC calculationHello Group! I use the Filter function in OAC calculation,and use Date Related fields as the filter expression, but it shows the below error message,please help! Or any … -
Time series functions without date hierarchyHello all, I am trying to use functions like AGO() and TODATE() directly within DV calculations (not within the RPD) on direct database connections or "flat" datasets, b…
-
Case (IF) Errors with Invalid Expression, Syntax Error, ORA-01722: invalid numberHello, I'm trying to filter Service Count By 'Free Consultation' and 'Paid Consultation' from Service Type by this Expression Filter CASE WHEN Service Type = 'Free Consu…
-
Custom report to monitor login activityLeadership would like a custom report to monitor login activity. We'd like to know which users logged in last week and which application/function they used. Sample outpu…SUSAN SANDIFER 12 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Oracle Transactional Business Intelligence Forum -
Issue when subsequently calculating from formulas containing FILTER functionBackground I have a single Oracle DB table set up as a basic Subject Area, comprising of one row per person per calendar month, showing data as of the last day of the ca…Martin Lowe 21 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Oracle Transactional Business Intelligence Forum
-
Calculating days since the first record in fact tableHello, We have a fact table with the following records : We need to calculate the number of days since the first views (# Vues) of an content (Id Contenu) for each recor…Jean-Pierre Hoedenaeken 33 views 2 comments 0 points Most recent by Gianni Ceresa Oracle Analytics Forum -
Fusion Analytics -Locode :Windowing FunctionsLocode for FAW - This can be used as a powerful technique for data extraction from varied sources into FAW. The attached video discusses creating Windowing Functions.The…Abhishek Bajpai - CEAL Team-Oracle 1 view 1 comment 2 points Most recent by Abhishek Bajpai - CEAL Team-Oracle Oracle Fusion Data Intelligence Forum -
Fusion Analytics -Locode :User Defined FunctionsLocode for FAW - This can be used as a powerful technique for data extraction from varied sources into FAW. The attached video discusses creating User Defined Functions.…Abhishek Bajpai - CEAL Team-Oracle 46 views 1 comment 1 point Most recent by Abhishek Bajpai - CEAL Team-Oracle Oracle Fusion Data Intelligence Forum
-
7Adjustable DateTime Hierarchy Levels Within VisualizationsOrganization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Worthington Industries Description (R… -
How to manage weeks of different yearsHello, I need to compare numbers from same ISO weeks (beginning on monday) between two years. Example : Iso Week 28 - In 2023 from 10 to 16 of july - In 2022 from 11 to …Jean-Pierre Hoedenaeken 144 views 4 comments 0 points Most recent by Jean-Pierre Hoedenaeken Oracle Analytics Forum
-
How to filter to see only rows where the ID has the newest Date?I Have a Table as seen in the picture above. I only want to see the rows where the IDs have the newest Value. A seen in the Picture below:
-
How translate function LAG from discoverer to Oracle BI 12cIn Oracle Discoverer it is available the function LAG, that is used to compare values in different time periods . So, for example, if I want to translate LAG(field, 1) i…