Update the TNS entry at location
and Import Metadata or else
use tns entry at Data Source Name at connection pool using OCI 10/11g
(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) (CONNECT_DATA =(SERVER = DEDICATED) (SERVICE_NAME = XE) ) )
If helps Pls mark correct or helpful
Select Start > Programs > Oracle Business Intelligence > BI Administration to open the Administration Tool.
Select File > New Repository
Enter a name for the repository. Leave the default location as is. It points to the default repository directory
Leave Import Metadata set to Yes.
Enter and retype a password for the repository
Change the Connection Type to OCI 10g/11g. The screen displays connection fields based on the connection type you selected.
Enter a data source name (You can go for any of one what i mentioned earlier). In this example the data source name is orcl. This name is the same as the tnsnames.ora entry for this Oracle database instance.
Enter a user name and password for the data source
Accept the default metadata types and click Next
In the Data source view,
The Connection Pool dialog box appears. Accept the defaults and click OK
The Importing message appears
If helps, Pls mark correct or helpful