Popular Tags
- OTBI 1,456
- Reporting 1,398
- FDI 1,146
- Analysis and Data Visualization 991
- BI Publisher 865
- Analysis 684
- Oracle Fusion Analytics 597
- Administration 557
- OAC 481
- OBIEE 434
- Analytics 410
- BI Publisher Data Models 360
- Security 299
- HCM 269
- BIP 265
- Answers 265
- Analyses 255
- Developers 246
- Data Modelling and Datasets 229
- Oracle Analytics Cloud 219
- ERP Analytics Content 215
- Data Connectivity 212
- BI Publisher Report Templates 205
- Fusion Data Intelligence 196
- Report Output 184
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 31 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 …SumukhaMohan 161 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 41 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 493 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 462 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 41 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 611 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… -
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…
-
How to limit Prompts to Yes/No in Dashboard?I have a requirement to develop a table with yes/no prompts for ex: the contracts for the suppliers if the user select yes, it will retrieve all the suppliers who has th…User_1EN5M 31 views 2 comments 1 point Most recent by Rich Merkel Oracle Transactional Business Intelligence
-
Employee signature picture in reportHello Everyone, Can anyone tell me how I can show an employee's handwritten signature in my report? Thank you.
-
Number columns are in text format in Excel exportHi, when our users export the data from Business Intelligence Publisher report to Excel, they want to perform additional analyses. Hence, they need to perform calculatio…Ante Obradović 682 views 2 comments 0 points Most recent by Ante Obradović Oracle Transactional Business Intelligence
-
The columns like BANK_NAME and BANK_BRANCH_NAME are blank in iby_ext_bank_account tableWe have a requirement to generate a report retrieving the details of changes made by an employee to their bank details in the payment methods page. We have created a use…Anusha B S 71 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Oracle Transactional Business Intelligence
-
Calculated Field in OTBI PromptSummary: Wish to have Calculated field in OTBI prompt. I want to have 3 prompts based on the given table data below: Assignment Last Update Date Grade Change Flag Grade …Pradnya_Pampatwar 1 view 0 comments 0 points Started by Pradnya_Pampatwar Oracle Transactional Business Intelligence
-
Pending Transaction next ApproverHello, using oracle cloud BI (SQL), i'm trying to write a datamodel that pulls the pending transaction data and i need information such as the pending with who (current …Hussain Ghuloum 31 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Oracle Fusion HCM Analytics
-
Accounted VAT queryHi, I have a data model which works for the majority of Accounts Payable Invoices in Fusion Financials, but I have isolated tax lines which do not appear. Taking my more…Robert of STAU 341 views 1 comment 0 points Most recent by Sinduja Sekar-Oracle Oracle Fusion ERP Analytics
-
We have requirement for SQL Query to find open transfer orders for create shipmentHi Everyone, We are trying to get All open transfer orders for create and completion shipment against the Sales Order Lines in current quarter. Getting failed to derivin…Srinivas_VNM 221 views 1 comment 0 points Most recent by Sinduja Sekar-Oracle Oracle Analytics Publisher
-
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 21 views 1 comment 0 points Most recent by Sinduja Sekar-Oracle Oracle Business Intelligence Applications
-
DFF Lexicals in a Non-Standard SQL DataModelHi, We have the requirement to write our data model using the 'Non-Standard SQL' SQL type because we need the use of CURSOR statements to return data back in a nested st…