Hi all,

Is it possible to use Adomd.Net to call Discover method of XMLA against SSAS
?

So far, i was only able to call Execute method.

The real problem behind this is that i need to retrieve a list of roles and
members from a SSAS database.

Any suggestions ?

TIA,
rud

hello Rud,

look into AdomdConnection.GetSchemaDataSet method i think it might help.
(for members retrieval adomd.net also exposes GetMembers and GetChildren
methods that might be of interest.)

-- mary
--
This posting is provided "AS IS" with no warranties, and confers no rights.
--
"Rud" <x@x.x> wrote

Thanks Mary,

This is what i have been looking for.

GetSchemaDataSet returns a dataset with a single cell table containing all
the needed data in XML format.

thanks again
Rud

"Mary Potapova [MS]" <marypo (AT) online (DOT) microsoft.com> wrote

There are a couple of ways of executing discover commands.

1. Using AMO, you can use the Execute method of the Server object. (Of
course you can also iterate through the AMO objects directly to examine
roles and members)

The ascmd program that was released with the SP1 samples uses this
method. see: http://msdn2.microsoft.com/en-us/ms365187.aspx

2. There is a Microsoft.AnalysisServices.Xmla library that does not
appear to be documented anywhere, but it does have an Execute and a
Discover command. I have a couple of examples on my blog.

I have an example of calling the discover method on the XMLA library
here (in powershell, but it's pretty close to .net code)
http://geekswithblogs.net/darrengosb.../PowershellAnd
Xmla.aspx

And here
http://geekswithblogs.net/darrengosb.../xmlaClient.as
px


--
Regards
Darren Gosbell - SQL Server MVP
Blog: http://www.geekswithblogs.net/darrengosbell

In article <uTCCu5i3GHA.4748 (AT) TK2MSFTNGP04 (DOT) phx.gbl>, x@x.x says...