Popular Tags
- Reporting 1,301
- OTBI 1,229
- Analysis and Data Visualization 816
- BI Publisher 689
- FDI 671
- Analysis 624
- Administration 516
- Oracle Fusion Analytics 475
- OBIEE 392
- BI Publisher Data Models 288
- Answers 253
- Analyses 247
- Developers 231
- Security 207
- Analytics 205
- Data Connectivity 198
- HCM 188
- Data Modelling and Datasets 187
- ERP Analytics Content 168
- Report Output 165
- BIP 153
- Agents 146
- BI Publisher Report Templates 143
- OAC 135
- Packaging and Licensing 128
Function
Discussion List
-
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…ashraf817 133 views 11 comments 0 points Most recent by Christian Berg -Oracle Oracle Analytics Cloud and Server -
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…SusanSandifer 12 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Oracle Transactional Business Intelligence -
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 25 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Oracle Transactional Business Intelligence
-
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 31 views 2 comments 0 points Most recent by Gianni Ceresa Oracle Analytics Cloud and Server -
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 -
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 31 views 1 comment 1 point Most recent by Abhishek Bajpai - CEAL Team-Oracle Oracle Fusion Data Intelligence
-
7New 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 41 views 1 comment 7 points Most recent by Gabby Rubin-Oracle Oracle Analytics Cloud and Server Idea Lab -
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…Will Wertz 44 views 1 comment 7 points Most recent by Michal Zima Oracle Analytics Cloud and Server Idea Lab -
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 114 views 4 comments 0 points Most recent by Jean-Pierre Hoedenaeken Oracle Analytics Cloud and Server
-
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:User_Y73CE 183 views 4 comments 0 points Most recent by User_Y73CE Oracle Analytics Cloud and Server
-
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…User_8PPKU 1 view 1 comment 0 points Most recent by Christian Berg-Oracle Oracle Analytics Cloud and Server