AS/400 DB2 and Analysis services

I am trying to build a cube.

The data is on the AS/400

I can make a successful connection and can see the table.

When I pull the tables in a Data Source View and try to make my own relationships,

there is no columns. In fact when I try to Explore data, it return an error:

Object reference not set to an instance of an object.

Can someone tell me how to resolve this?

Hi,

Can you please tell me if this happens with Analysis Services SP1 and using Microsoft's OleDB provider for DB2 (that is the only provider supported)? Also, in case you tried, does it work against UDB?

--
Raymond

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

Hi,

Try to use the IBM Client Access ODBC Driver.

Regards, Christian

|||

Looks like I don have the proper version. I download the Microsoft OLEDB Provider for DB2.

Went to install it and got this:

Setup cannot continue because a supported version of SQL Server 2005 is not installed. Supported versions include Enterprise, Developer, or Enterprise Evaluation.

Thanks.

BTW I did try the IBM DB2 UDB version 5.x and that is what I was trying to use. Apparently, IBM has reported a bug. They working on it and it won't be available until the next fix. Whenever that will be.....