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
-
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 238 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 21 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 97 views 2 comments 1 point Most recent by David Granholm-Oracle Oracle Fusion Data Intelligence
-
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.3K 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 41 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.2K 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 293 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 81 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 91 views 6 comments 0 points Most recent by Raghavan p-Oracle Oracle Transactional Business Intelligence