Popular Tags
- OTBI 1,336
- Reporting 1,336
- Analysis and Data Visualization 876
- FDI 824
- BI Publisher 773
- Analysis 648
- Administration 533
- Oracle Fusion Analytics 514
- OBIEE 406
- BI Publisher Data Models 312
- Analytics 273
- Answers 258
- Analyses 249
- Security 240
- Developers 234
- OAC 229
- HCM 211
- Data Modelling and Datasets 207
- Data Connectivity 204
- BIP 198
- ERP Analytics Content 186
- Report Output 173
- BI Publisher Report Templates 171
- Agents 148
- Customizing Reports 136
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Function
Discussion List
-
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…ashraf817 168 views 11 comments 0 points Most recent by Christian Berg-0racle 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 21 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 32 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 43 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 41 views 1 comment 7 points Most recent by Michal Zima Oracle Analytics Cloud and Server Idea Lab