Error Processing Dimensions

Hi,

I'm getting an error when processing a Dimension (translated from german):

Origin German Error Message:

Fehler im Back-End-Datenbankzugriffsmodul. OLE DB hat den unbekannten Status '' für die 1-Spalte gemeldet. Fehler im OLAP-Speichermodul: Fehler beim Verarbeiten des RATED CDR-Attributs der RATED CDR-Dimension aus der CubeTest2-Datenbank.

Translation:

Error in the Backend Data Access Module: OLE DB has returned the unknown Status '' for column 1. Error in the OLAP Storagemodule: Error in processing the rated_cdr Attribute of Rated_cdr dimension from CubeTest2 Database.

We're trying to read the Dimension Data from an IBM DB2 Database. All Access rights to the database are given to the running user.

I have no idea what the reason for this Problem could be.

Any ideas?

Thanks.

Ertan

Try and see if you can access data in DB2 through the BI Dev Studio DSV editor. Right click on the DSV table->Explore data.
This is going to test whether current user can access DB2 data through OLEDB provider.

After that you need to make sure Analysis Server's service account has the same privileges as the user accessed data from BI Dev Studio.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Yes I can access the data through DSV. Also the AS Service account is the same as what is used in DSV.

The same Cube based on a SQL Server Database is not returning any Problems. Could it be a Problem with the DB2 OLE DB Driver itself?

Any other ideas?

Ertan

|||

Ertan,

I have the same errors, also using DB2. Did you get your problems fix? I can also browse data from table.

Rue

sql