Tag Archive

Issue with invalid or corrupted repository joins

Published on April 12, 2013 By Ignacio de la Torre
Share

Symptom: The following error message is displayed: [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 46043] Internal error: No matching table for expr D_OPER_UNIT_XL.OPER_UNIT_SID, File .\Src\SQOSPSimplifyJoin.cpp, line 118. Cause: This symptom is associated with corrupted physical layer join relationships. The best way to test for a root cause is to isolate the […]

Como modificar el valor de una variable de sesion globalmente

Published on November 12, 2011 By ignacio
Share

I recently needed to update the value of a session variable beyond a prompt’s scope, I played a bit with the NQSSetSessionValue() ODBC function

OBIEE Repository Reporting

Published on December 25, 2010 By Ignacio de la Torre
Share

Extracting lists of OBI repository objects

OBIEE Logical Table vs Logical Table Sources – Best Practice

Published on December 15, 2010 By Ignacio de la Torre
Share

The difference between Logical Tables, Logical Table Sources (LTS) and the physical tables that compose a Logical Table Source, here are some basic guidelines that have helped me get this concept to seat more clearly in my mind.

Configure your database to host your Informatica Repository (Oracle 11g)

Published on September 16, 2010 By Ignacio de la Torre
Share

The Informatica repository is designed to reside in a database system, for my local test environment I will be hosting it in an Oracle 11g database. Here are two design principles that need to be taken into consideration when setting up the database that will host your repository: Creating a dedicated tablespace for your repository […]

OBIEE MUDE Repository Life Cycle

Published on July 4, 2010 By Ignacio de la Torre
Share

The attempt today was to illustrate in a very simple diagram the metadata development process in a OBIEE multi-user development environment (MUDE).