Tuesday, 7 December 2010

OBIEE Direct Database Requests

 Direct Database Requests.
Simple Stuff...

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}'

No comments:

Post a Comment

Google Big Query Clone / Copy DataSets / Tables - PROD --> TEST --> DEV Projects

Google Big Query Cloning of Datasets & Tables across GCS Projects. We searched the internet and could not find a simple cloning / ...