Hi,

Is it possible to get a list of available OLAP cubes on an Analysis Services
server, while using ado.NET and not using adoMD?

Thanks in advance,

Charlie.

Hello Charlie,
you can get a list of all cubes and much more using
the schemaRecordsets of the Analysis Services or
try to work with ADOMD.NET

HTH
Jörg



"Charlie" wrote:

Charlie,

Here you go. This requires a reference to adodb, but you should get the
general idea.

Keith

using System;

using ADODB;

namespace RawADOConsole

{

/// <summary>

/// Summary description for Class1.

/// </summary>

class Class1

{

/// <summary>

/// The main entry point for the application.

/// </summary>

[STAThread]

static void Main(string[] args)

{

//

// TODO: Add code to start application here

//

ADODB.Connection conn = new ADODB.Connection();

conn.Open("provider=msolap; Datasource=LocalHost; Initial Catalog=FoodMart
2000;","","", (int)ADODB.CommandTypeEnum.adCmdUnspecified);

ADODB.Recordset rs = conn.OpenSchema(ADODB.SchemaEnum.adSchemaCubes, null,
System.Reflection.Missing.Value);

while (!rs.EOF)

{

Console.WriteLine(rs.Fields["CUBE_NAME"].Value);

rs.MoveNext();

}

Console.ReadLine();

conn.Close();

}

}

}

"Charlie" <nospam (AT) nospam (DOT) nospam> wrote

Thanks guys.

Is the same way apply for getting a list of Member Properties for a member?

Thanks!

"Keith" <keith (AT) alh (DOT) com> wrote