I have a default instance Sql Server 2000sp3 and the same version analysis
services on the same machine. The problem is with the OLE DB data source
connected to this sql server. It is defined OK, but when I try to create a
cube based on it every table in every database yields a message "the
selected table lacks required numeric columns" and the tables won't browse.
When I connect a data source to a remote SQL Server everything works fine.
Who can help?

Oleg,
is it possible, that your database tables does not
contain numeric values, i.e. all numbers are stored as
strings?

You'll need at least one numeric value in the fact table-
otherwise you cannot start creating a cube.

HTH Lutz

Lutz,
No that's not the reason. The tables contain all the nesessary columns. I
connect to Northwind locally and remotely and obtain different results. I
already found out that this is the sql server who is the culprit, not the
analysis service.
Thank you.
"Lutz Morrien" <nospam.lutz.morrien (AT) ocb (DOT) com> wrote