Hi !
I want to retrieve all "Named Sets" defined to a cube with ADO MD -
OpenSchema() method.
How can I do that?

To get dimensions I do:
OpenSchema(adDimensions, Array(DatabaseName,'',CubeName), EmptyParam,
ADODataset)

I tried:
The following example retrieves all of the mining models that exist in the
FoodMart 2000 database:
Const DMSCHEMA_MINING_MODELS = "{3add8a77-d8b9-11d2-8d2a-003029144fde}"
'Open the MINING_SERVICES schema rowset. Assume the existence of an ADO
'connection (cn) and an ADO recordset.
Set rst = cn.OpenSchema(adSchemaProviderSpecific,Array("Food Mart
2000",Empty,Empty), DMSCHEMA_MINING_MODELS)But it doesn't work too!!!
Thanks===========================================C ristiano Moraes da
SilvaSIG Soluções em Informática e Gestão LTDASanta Maria - RS -
Brasilcristiano (AT) sigbrasil (DOT)...gbrasil.com.br+55 552268699

Hello, I was having the same trouble.

I find a way to get the named set with DSO and the Commands collection of
the cube.

there is MDSCHEMA_SETS .. i have'nt test it

Best Regards,

Patrice

"Cristiano Moraes da Silva" <cristiano (AT) sigbrasil (DOT) com.br> a écrit dans le
message de news:OHddmv5XEHA.712 (AT) TK2MSFTNGP11 (DOT) phx.gbl...

Ok....
How can I do to install DSO, because my machine use a remote Analysis
Services server!

thanks


"Patrice Lamarche" <patrice_lamarche (AT) gcomnitech (DOT) com.nospam> escreveu na
mensagem news:%23VUh275XEHA.3012 (AT) tk2msftngp13 (DOT) phx.gbl...

Here

oConn.Open "Provider=MSOLAP.2;Integrated Security=SSPI;Persist Security
Info=False;Data Source=localhost;Initial Catalog=foodmart 2000;Client Cache
Size=25;Auto Synch Period=10000"
Set rst = oConn.OpenSchema(adSchemaSets)

Best Regards,


"Cristiano Moraes da Silva" <cristiano (AT) sigbrasil (DOT) com.br> a écrit dans le
message de news:uhyR7D6XEHA.3420 (AT) TK2MSFTNGP12 (DOT) phx.gbl...

I've got an error with this code:

"Invalid field size" in the "OpenSchema()" line.


"Patrice Lamarche" <patrice_lamarche (AT) gcomnitech (DOT) com.nospam> escreveu na
mensagem news:%23vvgbZ6XEHA.2344 (AT) TK2MSFTNGP11 (DOT) phx.gbl...

Try this:

rst = con.OpenSchema(43, Array(database, null, cube));
if (rst.RecordCount>0) {
while (! rst.EOF) {
if (rst.fields.Item("EXPRESSION").value.search("Creat eVirtualDimension") < 0) {
Response.Write(rst.fields.Item("SET_NAME");
}
rst.movenext;
}
}
rst = null;


************************************************** ********************
Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...