Popular Tags
- OTBI 1,451
- Reporting 1,395
- FDI 1,132
- Analysis and Data Visualization 988
- BI Publisher 862
- Analysis 683
- Oracle Fusion Analytics 595
- Administration 555
- OAC 470
- OBIEE 433
- Analytics 405
- BI Publisher Data Models 359
- Security 296
- HCM 271
- BIP 265
- Answers 264
- Analyses 255
- Developers 246
- Data Modelling and Datasets 229
- Data Connectivity 211
- Oracle Analytics Cloud 210
- ERP Analytics Content 210
- BI Publisher Report Templates 205
- Fusion Data Intelligence 193
- Report Output 184
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
SQL
Discussion List
-
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 115 views 0 comments 2 points Started by Abhishek Bajpai - CEAL Team-Oracle Oracle Fusion AI Data Platform -
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 38 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 138 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 45 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 60 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 120 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 80 views 2 comments 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence
-
Can you get data from data model or report (not analysis) thought web service (XmlViewService) ?Summary: We need to get the data displayed in a data model or report in an web service (for further integrations). The web service is XmlViewService which allows Execute…maria.stanciu 277 views 4 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Oracle Transactional Business Intelligence
-
SQL Syntax for Max Salary Record?We would like the most recent salary amount. We used the query below but when we run the SQL we get the error that ORA-00923: FROM keyword not found where expected. Is t…Wendy G 37 views 2 comments 0 points Most recent by Wendy G Oracle Transactional Business Intelligence
-
Where to access Logical SQL queries for parameter creation?In many of the instructional videos about parameters, the Logical SQL query is simply pasted into the box without the video creator mentioning where to access it. Or if …Caroline Blanchard 137 views 2 comments 1 point Most recent by David Granholm-Oracle Oracle Fusion AI Data Platform -
BIP SQL low performanceWe have two instances with same transaction data. And we released the same data model and report in the two instances. Instance 1 has good performance(100s) but instance…
-
Using an SQL Date Formula in OBIEE ReportSummary How do I display previous 30 days of data Content Could someone please show me how to tweak the below formula. I’d like to pull data from the previous 30 days; h…3371114 1.4K views 8 comments 0 points Most recent by 3371114 Oracle Transactional Business Intelligence
-
Any one help Skills ReportSummary: Hi Team, we need skills report in Bi or OTBI Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets…AjayKumar Maddipati 52 views 1 comment 0 points Most recent by Gaurav Bharadwaj-Oracle Oracle Transactional Business Intelligence
-
how to put a Countif in a unique field in an OTBI reportSummary: In my report, I have Person Number field which is unique, however the report has some duplicate entries. I only need to understand how do I get a count to see h…Abhishek Bagh 1.3K views 8 comments 0 points Most recent by Amrita Gupta-Oracle Oracle Transactional Business Intelligence
-
SQL/report to get the list of consultants (not having Person ID)We are looking for a user/role report that list users firstname/lastname/email and roles. The report we have only lists if they are linked to a person record. We have co…Vijay Ramani VJ 334 views 4 comments 0 points Most recent by Vijay Ramani VJ Oracle Transactional Business Intelligence
-
How to default an OTBI SQL in a Data Model to Table View?Summary: How to default an OTBI SQL in a Data Model to Table View? Content (required): Does anyone know if it's possible to default the Data tab of an OTBI Data Model to…Mike Burnett 98 views 3 comments 0 points Most recent by Mike Burnett Oracle Transactional Business Intelligence
-
Is there a way to find what reports/anaylsis are set up for Bursting?Summary Is there a way to find what reports/anaylsis are set up for Bursting? Content Hello I need to find out what reports/analysis have been created and set to burst o…Helen Thomas-53877 119 views 6 comments 0 points Most recent by Raghavan p-Oracle Oracle Transactional Business Intelligence
-
Help with an OTBI or SQL query to produce a list of all job codes with Grade informationSummary: Hi All, I am hoping someone can help me - I have been struggling with a report request for a while now and I didn't think it was going to be this hard Our busin…PamS 2.1K views 16 comments 0 points Most recent by MandeepGupta Oracle Transactional Business Intelligence