Popular Tags
- Reporting 1,326
- OTBI 1,321
- Analysis and Data Visualization 864
- FDI 801
- BI Publisher 760
- Analysis 644
- Administration 530
- Oracle Fusion Analytics 508
- OBIEE 405
- BI Publisher Data Models 306
- Analytics 268
- Answers 258
- Analyses 249
- Security 236
- Developers 233
- OAC 222
- HCM 209
- Data Connectivity 203
- Data Modelling and Datasets 201
- BIP 193
- ERP Analytics Content 186
- Report Output 172
- BI Publisher Report Templates 169
- Agents 148
- Customizing Reports 136
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
SQL
Discussion List
-
HELP WITH SNAPSHOT TOO OLD ERRORMy table is updated with 36 parallel running oracle jobs all running at the same time. All these jobs update same table but each job deal with different sequence numbers…User_JKU92 21 views 2 comments 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence -
How to make prompts optional in Logical SQL based OTBI analysisHi Experts, We are trying to build OTBI analysis using logical SQL approach and there are few prompts required which are not a part of Select statement so we are trying …User_5BCP3 79 views 1 comment 0 points Most recent by Aaron Leggett Oracle Transactional Business Intelligence
-
Implement a dynamic default value for a DFF field based on another DFFCan anyone help with a SQL query - To implement a dynamic default value for a DFF field based on another DFF field in edit mode, ensuring that values captured in Task 1 …Krishna G 13 views 1 comment 0 points Most recent by John Hung-Oracle Oracle Transactional Business Intelligence
-
How can I join the DOO_HEADERS_ALL table with PO tables like PO_LINES_ALL in Oracle Fusion ?I’m working on a BI report for order and item details like order number and item number and description in Oracle Fusion, and I need to join the DOO_HEADERS_ALL table wi…User_IQZBR 306 views 1 comment 0 points Most recent by John Hung-Oracle Oracle Transactional Business Intelligence
-
How to Join DOO_HEADERS_ALL table with PO_HEADERS_ALL or PO_LINES_ALL table?I need Order number from DOO_headers_all, then item description from PO_LINES_ALL, also I need receipt_number and invoice number. HEADER_ID is not matching with PO_HEADE…User_IQZBR 323 views 1 comment 0 points Most recent by John Hung-Oracle Oracle Transactional Business Intelligence
-
What is the logic to add while creating the prompt in the Logical sql query in OTBISuppose a field/column- Effective Date of Balance in Payroll should be between two dynamic parameters such as Start date and end date. Start Date and End date will be as…Dona Das-Oracle 43 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Oracle Transactional Business Intelligence
-
Query to capture payment process request approver name,Number and approved DateHi Team, We have configured BPM rules for Payment process request and we need to capture approver records like approver name, approver number and approved date along wit…Muzaffaruddin 397 views 1 comment 0 points Most recent by Mallikarjuna Kuppauru-Oracle Oracle Fusion ERP Analytics
-
When ever apply some another column in sql it will automatically affected another measure columnHello Everyone, When ever apply some another column in sql it will automatically affected another measure column in sql report I want c1 is 15 value based on add another…User_HQ9TE 21 views 2 comments 0 points Most recent by Gianni Ceresa Oracle Analytics Cloud and Server -
Bi Publisher Data model returning error when run, after using system variable in the sql query.We created a data model and defined a condition in the sql query using the system variable ':xdo_user_roles' (which fetches all roles of the session user) and using it, …
-
Report output require in one rowHello Expert I have a problem with the output of the report. How can we obtain a single employee record in a row? If someone could help me with this, it would be greatly…