On OBIEE there is no easy way to get where this report getting the data from or
in other words from which database data is pulling from.
If you want this information, you need to login to BI server then open RPD for that you need administrator password, then look at connection pools, all this will consume at least 2 mins to 5. More over many organizations will not provide BI server access or Administrator Password.
We can avoid all these by create a report which will provide all these information, something like below.
Create this report and store it some where on my folder, when ever you want database information just run the report.
BI Server Host
|
Database Host
|
BI Server Host and Domain
|
Database SID/Data base source Name
|
Database User
|
Your BI Server Name
|
Database Host
|
BI Server Domain and Host
|
BI_DATA_BASE
|
BI_USER
|
To get BI Server name create report with a column as below
CAST(Evaluate('SYS_CONTEXT(%1,%2)' ,'USERENV','TERMINAL' ) as VARCHAR(50))
To get Database host name use following formula in the attribute
CAST(Evaluate('SYS_CONTEXT(%1,%2)' ,'USERENV','SERVER_HOST' ) as VARCHAR(50))
To get Database SID or Database name use following formula in the attribute
CAST(Evaluate('SYS_CONTEXT(%1,%2)' ,'USERENV','INSTANCE_NAME' ) as VARCHAR(30))
To get Database user name use following formula in the attribute
CAST(Evaluate('SYS_CONTEXT(%1,%2)' ,'USERENV','SESSION_USER') as VARCHAR(30))
Note this will work only with Oracle as a backend database.
Hope this is informative to you.
