Hi Everyone, If there is any help in this regard, it will be highly appreciated.

Dear Christian I understood your point. Thanks

Hitting source DB always to get live data will not effect the source system or lock the tables? This is the only fear I have that creating BI report on top of direct source DB should not impact the source DB.

Hi Gianni, By live, I mean directly hitting the source DB instead of waiting for the ETL to load data into BI DWH. There is a specific requirement from the client where they want to see the status of a particular job on BI Dashboard which should refresh with the latest data as per source within 1 or 2 mins of time gap.They…

Hi Christian, I am not asking about the basic reports which are built on top of any data source but I am asking about the live/online reporting through OBIEE or BIP.(having no effect on the source system DB) How it can be done in BI enterprise ? It will be helpful if you can reply to my query. Abid

Hi, You solution was incomplete so I thought of completing it.

Hi, Go to Administration - Manage Privileges - scroll down to the end of the page and see the Subject Areas where you can grant or denied permission to group or role even user.(to individual Subject areas) Thanks, Abid