OTBI dashboard prompt daily rate

Question

Hi,

I am trying to create prompt "presentation variable" and insert under "default selection"  the below SQL which should return the Rate amount

(in BIP i can see the value) ,but after insert the SQL to the prompt i didn't get any value , please advice?

SQL:

select gd.conversion_rate

from gl_daily_rates gd

where gd.conversion_type='Corporate'

and gd.from_currency='USD'

and gd.to_currency='TWD'

and gd.conversion_date=TO_DATE('21-01-2024','DD-MM-YYYY')

Prompt :

result :"test" field is null.

John Hung-Oracle · Answer

Hi, To better serve you, please post this question in the Reporting and Analytics for ERP forum since its specific to Financial subject areas/use cases. Thank you.