Popular Tags
- OTBI 1,343
- Reporting 1,340
- Analysis and Data Visualization 880
- FDI 835
- BI Publisher 782
- Analysis 649
- Administration 535
- Oracle Fusion Analytics 519
- OBIEE 408
- BI Publisher Data Models 317
- Analytics 277
- Answers 258
- Analyses 249
- Security 243
- OAC 234
- Developers 234
- HCM 212
- Data Modelling and Datasets 207
- Data Connectivity 205
- BIP 201
- ERP Analytics Content 188
- Report Output 175
- BI Publisher Report Templates 174
- Agents 148
- Customizing Reports 137
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
SQL
Discussion List
-
DFF Lexicals in a Non-Standard SQL DataModelHi, We have the requirement to write our data model using the 'Non-Standard SQL' SQL type because we need the use of CURSOR statements to return data back in a nested st…
-
Count days function in subject areaHi Everyone, Is there a way to count days in the subject area? I'm working on a checklist subject area, where I want to count task-assigned days. The report count days l…
-
Fusion Analytics Autonomous database Series: Connecting via SQL developerThe video describes how users can connect to SQL Developer using wallet file Download Wallet file https://docs.oracle.com/middleware/1213/wls/JDBCA/oraclewallet.htm#JDBC…Abhishek Bajpai - CEAL Team-Oracle 75 views 0 comments 2 points Started by Abhishek Bajpai - CEAL Team-Oracle Oracle Fusion Data Intelligence
-
3Logical SQL Query WizardTo improve the experience for end users and to enable full utilisation of the Oracle Analytics self-service capabilities, it will be useful for functionality that enable…Joel Acha11111 21 views 3 comments 3 points Most recent by Bret Grinslade - Oracle Analytics-Oracle Oracle Analytics Cloud and Server Idea Lab
-
Filtering report data based on the time on or before the current date at either noon or midnightI have a small summary report of a few columns to make sure that the PVO data we extract for the SubledgerJournalDistributionExtract PVO matches up to what is in oracle.…Dave Kekish 124 views 1 comment 0 points Most recent by Dave Kekish Oracle Transactional Business Intelligence
-
1Attempting to create a lookup table, getting syntax errorI am attempting to use SQL to create a report that determines whether a procurement was completed late or not depending on a number of factors. Due to the many condition…Mariyam129 31 views 2 comments 1 point Most recent by Mariyam129 Oracle Transactional Business Intelligence Idea Lab
-
5Allow Developers to write SQL and preview data on the same screenWhen creating an SQL Data Model, I have to write my SQL in the "Diagram" tab, close the window go into the "Data" tab to see a preview of the results. Realize the change…User_315WR 51 views 2 comments 5 points Most recent by Bret Grinslade - Oracle Analytics-Oracle Oracle Transactional Business Intelligence Idea Lab
-
Regarding 2911553.1 SSL transport detected mismatched server certificateHi Team, For past few days we couldnt connect SQL Dev with ADW instance using wallet file because of the retired the Organizational Unit (OU) field in the tnsnames ora f…Sowmiya Ranganathan 82 views 7 comments 0 points Most recent by Gianni Ceresa Oracle Analytics Cloud and Server
-
How do I determine a person record is merged in Oracle HCM FusionWe have a series of outbound demographic files to third parties and we are paying thousands in additional licensing due to "merged" person records being included. For ex…
-
MCPD on Assignment - get top of stackWe are using the following qualifiers for getting a recent assignment. paam.primary_flag='Y', paam.assignment_type='E', paam.effective_latest_change='Y', paam.assignment…Wendy G 63 views 2 comments 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence