SQL
Discussion List
-
How to override NULL valuesSummary How to override null value with values from another column in OBIEE AnalysisContent When building an analysis in OBIEE, what would be the code to enter into the …User_2025-02-06-00-08-33-553 49 views 6 comments 0 points Most recent by User_2025-02-06-00-08-33-553 Reporting and Analytics for SCM -
Need A SQL query to get the supplier contact address detailsSummary Need A SQL query to get the supplier contact address detailsContent Need A SQL query to get the supplier contact address details Here I have attached the screens…Koteswararao Yenikepalli 339 views 1 comment 0 points Most recent by Siva Kumar-Oracle Reporting and Analytics for SCM -
How to display only most recent records in an analysisSummary How to output only the most recent records in "Inventory - Onhand Balance" analysisContent In OBIEE, Is there a way to modify the pre-built analysis "Inventory -…User_2025-02-06-00-08-33-553 62 views 1 comment 3 points Most recent by User_2025-02-06-00-08-33-553 Reporting and Analytics for SCM
-
Security In Data ModelSummary How to restrict user by not getting data of other BU in BIP ReportContent Hi Champs, Let's say my user 'A' has access to only 'X' Business Unit. How should BIP d…Manish Pesswani 129 views 2 comments 2 points Most recent by Mrigank Sharma Reporting and Analytics for SCM -
Pixel perfect PDF reportsSummary Pixel perfect PDF reportsContent We need some inputs on best practices / recommendations for developing pixel perfect PDF reports. Context: The implementation sc…Mirza Nasir Beg -Oracle 48 views 0 comments 0 points Most recent by Mirza Nasir Beg -Oracle Reporting and Analytics for SCM -
Customization on the AP invoiceSummary Customization on the AP invoiceContent Is it possible to do a customization on the AP invoice to validate certain fields and making some fields required based on…Mohammad Alhindawi 53 views 1 comment 2 points Most recent by User_2025-02-04-07-16-12-621 Reporting and Analytics for SCM
-
Need A Report To Find Out The PR Is Pending With Whom And Its HistoryContent We are looking for some SQL query to find out the requisition is currently pending with whom and what is the history of the approval To achieve this requirement …Koteswararao Yenikepalli 53 views 1 comment 4 points Most recent by User_2025-01-30-02-57-36-931 Reporting and Analytics for SCM
-
Need info on inventory adjustment for all material transactionsSummary Need info on inventory adjustment for all material transactionsContent Hi Experts, I am looking for any BI or OTBI reports to get inventory adjustment for all ma…