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 convert field [Recruiting-Recruiting Real Time] from Date to Date & Time in OTBI?We would like the time associated with the job application in the field 'Job Application - Electronic Signature' Can I convert this field to date & time instead? If so, …Wendy G 21 views 2 comments 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence
-
Extract all the SQL queries of different BI Publisher reportsHello, I have many reports and I want to extract all the Sql queries of their data model. I can't do it manualy because I have more than 100 reports. Can I find a way to…Sherazad Melili 31 views 3 comments 0 points Most recent by Mallikarjuna Kuppauru-Oracle Oracle Analytics Publisher
-
how can I display days off for an employee when there is neither time in nor time out on these daysI have an issue that I need to display employee days off as "day off". For example, I have an employee whose days off are from 10:00 to 18:00 (Friday & Saturday), and hi…Salma Ashraf 11 views 1 comment 0 points Most recent by Mallikarjuna Kuppauru-Oracle Oracle Analytics Publisher
-
ORA-01427: single row subquery return more than one rowWhen I run the mapping in ODI it will getting the issue ORA-01427: single row subquery return more than one row And am add rownum=1 in join condition interface successfu…User_HQ9TE 21 views 1 comment 0 points Most recent by SteveF-Oracle Oracle Analytics Cloud and Server
-
How to merge rows if their 2 columns are the same in OTBI Analysis?Hello, I have an analysis where I'd like to merge multiple rows if they share the same value for "Item Description" and "Unit Price". Example: | Item Description | Unit …Rojhat Sinan Balka 62 views 2 comments 0 points Most recent by Rojhat Sinan Balka Oracle Transactional Business Intelligence
-
OAS/OAC - using a parameter in a dynamic SQL query.Hi, I have a workbook containing a table/graph that has been generated by a SQL query, connecting to some Oracle database tables. The SQL query is hardcoded to pull data…Paula McMahon 403 views 8 comments 0 points Most recent by Christian Berg-0racle Oracle Analytics Cloud and Server
-
24B: BIP - What is the subject area or tables to get transaction approvers from Learning?Please provide the subject area or an SQL tables to retrieve transaction approvers from the Learning module (24B). I have tried using this one, but it doesn't return any…Nipon 31 views 1 comment 0 points Most recent by Rajesh L-Oracle Oracle Business Intelligence Applications
-
ZMM Notes columns - SOURCE_OBJECT_CODE, SOURCE_OBJECT_UID in Receivables - Transactions Real Time?Summary: Is anyone familiar with the subject area - Receivables - Transactions Real Time? I am looking for the equivalent of SOURCE_OBJECT_CODE, SOURCE_OBJECT_UID column…Scott McAnally 1.6K views 4 comments 0 points Most recent by Robert of STAU Oracle Transactional Business Intelligence
-
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…SUSAN SANDIFER 11 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Oracle Transactional Business Intelligence
-
need to add item number with item class and item category in bipneed to add item number with item class and item category in bip, How can I join EGP_SYSTEM_ITEMS_B table with EGP_ITEM_CLASSES table and EGP_ITEM_CATEGORIES_TABLE ? The…User_IQZBR 23 views 1 comment 0 points Most recent by John Hung-Oracle Oracle Transactional Business Intelligence