Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  Analysis Server and Reporting Services (2005)  Using XMLA to Discover Mining Model Metadata

Author  Topic  ebt5 Starting Member 1 Post Posted - 2009-01-07 : 14:59:15 I'm new to analysis services and I have just built a linear regression model and deployed it to the server. I can use DMX to return predicted values, but I'm having trouble uncovering statistics about the regression model (intercepts, coefficients etc.) which I understand are in mining data schema rowsets and are obtained using XML Disover methods. But when I try any discover statement at all, for example <Discover xmlns="urn:schemas-microsoft-com:xml-analysis"> <RequestType>MDSCHEMA_CUBES</RequestType> <Restrictions> <RestrictionList> <CATALOG_NAME>Dogwood</CATALOG_NAME> </RestrictionList> </Restrictions> <Properties> <PropertyList> <Catalog>Dogwood</Catalog> <Format>Tabular</Format> </PropertyList> </Properties> </Discover> (the database name is "Dogwood") I get an error: The Discover element at line 7, column 72 (namespace urn:schemas-microsoft-com:xml-analysis) cannot appear under Envelope/Body/Execute/Command. I execute the above code from Sql Server Management Studio in an Analysis Services session. It is likely I'm attempting something absurd here as I am new to XML and analysis services. Any help would be greatly appreciated.