dbTalk Databases Forums  

List of Databases on Analysis Server

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss List of Databases on Analysis Server in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Sumit Pilankar
 
Posts: n/a

Default List of Databases on Analysis Server - 12-06-2005 , 03:52 AM






Hi,

I am writing a custom application.

What i need to do is:
1. Provide a drop down to choose a SQL 2005 Analysis Server from the list of
Analysis Servers available on the network

2. Once a server is chosen, another drop down should be populated with list
on Databases on that Analysis Server

I need to know the way to get the list of Analysis Servers and list of
databases on the server

I am using VS 2005 and SQL Server 2005.

Thanks
Sumit Pilankar



Reply With Quote
  #2  
Old   
Dave Wickert [MSFT]
 
Posts: n/a

Default Re: List of Databases on Analysis Server - 12-07-2005 , 06:13 PM






Look in BOL at schema rowsets.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI Systems Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


"Sumit Pilankar" <sumit.pilankar (AT) gmail (DOT) com> wrote

Quote:
Hi,

I am writing a custom application.

What i need to do is:
1. Provide a drop down to choose a SQL 2005 Analysis Server from the list
of Analysis Servers available on the network

2. Once a server is chosen, another drop down should be populated with
list on Databases on that Analysis Server

I need to know the way to get the list of Analysis Servers and list of
databases on the server

I am using VS 2005 and SQL Server 2005.

Thanks
Sumit Pilankar




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.