Creating a Direct Database Request and using Variables within A Direct Database Request.
Make Sure Administration/Manage privileages/Direct database privileage is there for user or Group.
So that when you login to answers you can see the link for Creating a Direct Database Request.
Take Note of Connection Pool Name from RPD (OBIEE Administrator)
This will be needed to create a direct database request
select process_area from my_table
where trigger_date between '@{startdate}{2010-01-01}' and '@{enddate}{2010-12-01}'
