Popular Tags
- Reporting 1,330
- OTBI 1,327
- Analysis and Data Visualization 869
- FDI 811
- BI Publisher 764
- Analysis 645
- Administration 532
- Oracle Fusion Analytics 512
- OBIEE 405
- BI Publisher Data Models 306
- Analytics 271
- Answers 258
- Analyses 249
- Security 236
- Developers 234
- OAC 222
- HCM 210
- Data Modelling and Datasets 205
- Data Connectivity 204
- BIP 195
- ERP Analytics Content 186
- Report Output 173
- BI Publisher Report Templates 170
- Agents 148
- Customizing Reports 136
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
SQL
Discussion List
-
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 22 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 114 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 31 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 13 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 12 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 21 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 25 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 211 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 142 views 6 comments 0 points Most recent by S Raj Shekhar Oracle Transactional Business Intelligence