Cannot connect BI to TimesTen

Ray Kelly

I am having trouble connecting OBIEE to TimesTen. I am using OBIEE 11.1.1.6 and TimesTen 11.2.2. I created the TimesTen datastore. Configured the odbc.ini and the sys.odbc.ini for the new datastore. I creating all of the objects in the TimesTen database from the Oracle database. I created a new ODBC connection on my local machine (MYSCHEMA_DSN). I create a new repository with a new Database using TimesTen V11 as the Database Type. I created a connect pool using Default ODBC 3.5 as the Call Interface. I tried using TimesTen ODBC 3.5 but when I use that and try to import metadata, it says TimesTen ODBC 3.5 Import is not supported. I changed the Call Interface to ODBC 3.5 and used MYSCHEMA_DSN as the Data Source Name (all other options were left as default). Using ODBC 3.5, I was able to import metadata from the TimesTen database. I created a BMM and Subject Area and deployed the repository. I open analytics and created a new analysis. When I go to the results tab, I get the following error: Odbc driver returned an error (SQLExecDirectW). Error Details Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P State: HY000. Code 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 14080] One of the unavailable physical database schemas ("ORADB".."SCHEMA1", "ORADB".."SCHEMA2") may have been required to answer this query. [nQSError: 14020] None of the fact tables are compatible with the query request TABLE1.COLUMN1. (HY000) I followed the steps at the following URL: http://www.rittmanmead.com/2012/07/exalytics-timesten-and-obiee-connectivity/ I tried multiple datastores against multiple oracle database schemas. Same problem. Any help would be appreciated.

Thomas Dodds

You might have a good connection, this error is often associated with the content levels set on logical table sources ... try setting the ones you need at their appropriate grain, then set the rest to their total levels.

Ray Kelly

Thomas, thanks for the response but you might as well have been replying in Greek.  I have no idea what any of that means.  Can you point me to a website that may be able to enlighten me?

Thomas Dodds

" I created a BMM and Subject Area and deployed the repository."

In the BMM you need to create the appropriate dimensional hierarchies and then set your logical dimensions' and facts' Logical Table Sources' content levels to the appropriate level.  This set the grain for the tables, so that the BI server knows how to craft the appropriate call to the data base for data.