Showing posts with label amo. Show all posts
Showing posts with label amo. Show all posts

Saturday, February 25, 2012

Creating Named Query in Analysis Services Using AMO

Hello,

Is there an example somewhere that shows how to create a named query in DSV based on an existing table in the DSV using AMO?

Thank you so much,

Sincerely,

Annie

This may help:

http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=727220&SiteID=17

Also, if you install the SQL Server Samples, the following path will have a bit of a more comprehensive example of creating a DSV. Though it doesn't create any named queries, it may be helpful:

C:\program files\Microsoft SQL Server\90\Samples\Analysis Services\Programmability\AMO\AMOAdventureWorks\CS\AmoAdventureWorks