Popular Tags
- OTBI 1,407
- Reporting 1,365
- FDI 986
- Analysis and Data Visualization 953
- BI Publisher 820
- Analysis 663
- Administration 553
- Oracle Fusion Analytics 550
- OBIEE 421
- Analytics 347
- OAC 338
- BI Publisher Data Models 335
- Security 273
- Answers 261
- Analyses 253
- Developers 240
- HCM 239
- BIP 233
- Data Modelling and Datasets 218
- Data Connectivity 206
- ERP Analytics Content 199
- BI Publisher Report Templates 185
- Report Output 180
- Agents 151
- Customizing Reports 146
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
SQL
Discussion List
-
sql query to get recorded absences on their time cards in oracle fusion cloudHi All, SQL query to get recorded absences on their time cards in oracle fusion cloud hcmmist123 25 views 1 comment 0 points Most recent by MandeepGupta Oracle Transactional Business Intelligence -
Logical SQL in calculation validated ok but Query Error in Visualization.Hi Group, I've tried a Logical Sql in calculation in OAC, it showed validate OK,like below part1, but have Query Error in visualization like below part2. And if we use V… -
Error in SQL query from a connection to Fusion ERPI established a connection with Fusion ERP, I want to make a manual query through SQL but when I try to do it I get the following message: "There was an unexpected error…SERGIO BARRETO 82 views 15 comments 0 points Most recent by SERGIO BARRETO Oracle Fusion ERP Analytics -
Which Oracle Fusion Cloud GL tables do I join to get YTD nominal balances?Trying to build an opex report but only getting the current period values not year to date. Do I have to add multiple rows of sql into the data model to add all the peri…Lynda G 82 views 7 comments 0 points Most recent by Lynda G Oracle Transactional Business Intelligence
-
Time Card StatusHi everyone, I am trying to create a BIP report for Time Card Change History which includes both "Time Entry" and "Time Card Status". For Time Card Status, I am trying t…Candy Miles Domingo 161 views 1 comment 0 points Most recent by Kaustubh Deshmukh Oracle Transactional Business Intelligence
-
3Restrict BIP access (table access) for person, sensitive dataWhen creating or editing a data model it should be possible to restrict data access to certain tables that contain person sensitive data such as Ethnicity etc. The secur…Vina Vyas 42 views 3 comments 3 points Most recent by MandeepGupta Oracle Transactional Business Intelligence Idea Lab
-
Query for Issue description and resolution in transaction consoleDears , I am working on a query to get issue description and resolution , I found them but I could not exact fault message for transaction. Here is the code I am using .…Beshoy Hakim-Oracle 21 views 2 comments 0 points Most recent by MandeepGupta Oracle Transactional Business Intelligence
-
Please can someone provide me the SQL to split out "Worker"."Employee Mailing Postal Code" AS IncodeHi, i am tyring to use a calculated measure to split the "Worker"."Employee Mailing Postal Code" (Workforce Management - Person Real Time Folder) to show a column with j…MLowe3639 11 views 2 comments 0 points Most recent by MLowe3639 Oracle Transactional Business Intelligence
-
Is it possible to fetch dynamic columns based on lookups in BIP report for aging purposeI had a requirement to have a different set of buckets for inventory aging reports, is this achievable?Jayant Ajayrao Deshmukh 11 views 1 comment 0 points Most recent by Mallikarjuna Kuppauru-Oracle Oracle Analytics Publisher -
Query to get fetch Archived Transaction Summary dataHi Expert, Does anyone have a query to fetch the Archived Transaction Summary data? I would really appreciate it if you could share a BI query here. Thank you in advance…Saher 35 views 3 comments 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence
-
SQL code runs fine in SplashBI SQL Connect tool but times out in Oracle BIP Data ModelHi all - I have a SQL query that runs within a few seconds in my Splash BI (SQL Connect) query tool, however when I use this same code in the Oracle Data Model in BIP it…KDR 36 views 3 comments 0 points Most recent by Mallikarjuna Kuppauru-Oracle Oracle Analytics Publisher
-
Where do I find DFF's in subject area Workforce Management - Documents of Record Real TimeSummary: I am attempting to build a report using the Workforce Management - Documents of Record Real Time I have managed to get to the Document Type Vacation Carryover A…PamS 221 views 7 comments 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence
-
BI Cloud Connector support custom offerings for extract?Content Looking into using the BI Cloud Connector(BICC) for extraction of data sets for integration with our E-Business Suite custom product. The BI Cloud Connector offe…KristopherN 146 views 6 comments 0 points Most recent by S Raj Shekhar Oracle Transactional Business Intelligence
-
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 75 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 645 views 8 comments 0 points Most recent by [Deleted User] 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 33 views 1 comment 0 points Most recent by Rajesh L-Oracle Oracle Business Intelligence Applications