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
-
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ć 479 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 61 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 3 views 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 32 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 314 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 196 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