OBIEE BI Administration Tool: Very slow connection to physical layer
760415Apr 30 2010 — edited May 10 2010Hi,
I've imported my AWM Cube in Administration Tool successfully, but when i retrieve data from an element or click on Update Row Count, system goes in loop.
Maybe there's any error in Connection Pool settings?
My tnsnames.ora file is:
MMGDWH =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.17.96)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
My Connection Pool settings are:
Call Interface: OCI 10G/11G
Data Source Name: mmgdwh
...
My database isn't local, but it is on a server. If I execute a query on database I have results in few minutes. So server connection works fine, in my opinion.
What's the problem?
Thanks
Giancarlo
P.S.: I've tried also with ODBC 3.5 call interface but results are the same.