Hi, Please use the "CAST" function to remove the timestamp from the date. Please find the below Example. CAST("Ledger"."Ledger Last Update Date" AS DATE) Please find the below image for Reference.

Hi, There is One Link Option In Left Bottom Of Dashabrod. using this when you click on the previous DB button it will redirect to the previous page. Please find the Screenshot with highlighted Part. .

Hi, You can use these 3 options to export the OTBI Analysis. 1. You can export this in Excel (.xlsx) format and after select the date column in excel and change the formatting of the column in excel. 2. You can export the analysis in MHTML(.mht) format then open the MHTML file in excel then you are able to see the date in…

Hi, Please find the Below Post Link, “How to add a deep link In OTBI Analysis?” https://jpulkit.wordpress.com/2021/07/15/how-to-add-a-deep-link-in-otbi-analysis/ Action Target Page in Fusion Apps URL Format Functional Overview Parameters View Invoice Details Manage Invoices in view mode…

Hi Amit, We can do the Analytics level of reporting using OTBI tools, but in OTBI you can only develop the analytics using Subject area columns. Its have many advantages and Disadvantages. For Example, OTBI Advantages : * You can easily find the Column and Joints In the subject area and Develop the analysis. * Using Drill…

Hi, Please try to develop The complete link in SQL Code. For Example, I have one report where I am showing Invoice BU, Supplier Related Data ( Supplier Wise Sum of invoice Amount), and Same I have another detailed report where I am showing complete detail of the Invoice. In this BIp report When I Click on a particular BU…

Hi, Right Now you are using the Analytics prompt In your OTBI Analysis. Analytics prompt we can only access when you are accessing the report from Catalog -> Analysis. but in your case you are accessing the analysis from the Dashboard page, for this, you need to develop one Dashabrod Prompt. after developing the dashboard…