Hi,

I need to make in vb code something to know the tables that are used in a
cube.

Does anybody have an example of how to know in vb.net the tables of the
cube?

I think that it must be easy because in the Analysis Manager appears the
fact table and the dimension table!!!

Thank's in advance.

Un saludo,

Enrique Barceló

I did something like that with ADOMD (not ADOMD.NET) but I think there's
surely the same properties even in the .NET version.
Any way, if you use ADOMD (VS 6.0) you can do something like that:

dim MyServer as Object
dim MyDb as Object
dim MyCube as Object

Set MyServer = New DSO.Server
MyServer.Connect "ServerName"
Set MyDB = MyServer.MDStores.Item("NameOfMyDb")
Set MyCube = MyDB.Cubes.Item("NameOfTheCube")
MsgBox MyCube.FactTable 'FactTable of the cube in the format user.table
MsgBox MyCube.FromClause 'List of every table and View used by the cube
in the format user.table
MsgBox MyCube.JoinClause 'Join clause of the fact table with its
dimensions

You've got the same propeties for dimensions if you need them.
As I said I didn't see ADOMD.NET but I'm sure that there's a DSO object with
properties like those.
Goo luck
Andrea

"KLEIOS" <ebarceloNOSPAM (AT) kleios (DOT) net> ha scritto nel messaggio
news:uYtwrpTIEHA.3356 (AT) TK2MSFTNGP11 (DOT) phx.gbl...