TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
C# Corner
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Connect in Online Mode to an Analysis Services Database using (BIDS)
Mukesh Kumar
Jun 20, 2011
5.6
k
0
0
facebook
twitter
linkedIn
Reddit
WhatsApp
Email
Bookmark
Connect in Online Mode to an Analysis Services Database using (BIDS).
You can connect directly to an existing Microsoft SQL Server Analysis Services (SSAS) database and directly modify objects within that database. When you connect directly to an Analysis Services database, changes to objects occur immediately and no Analysis Services project is created within Business Intelligence Development Studio.
Follow these steps to connect in online mode:
Click on Microsoft SQL Server 2005/2008 > SQL Server Business Intelligence Development Studio from the Programs menu to launch Business Intelligence Development Studio.
On the File menu, click on Open and then click Analysis Services Database.
On Connect To Database Dialog box Select Connect to existing database.
Specify the server name and the database name.
Click OK.
You are working online now, any change you make to the metadata is immediately reflected in the production server. There is no deploy option available on the project, cube, or dimension menus in Solution Explorer. Also, the title bar of BIDS shows the name of the SSAS database and then names of the SSAS server, for example, Adventure Works DW 2008R2 (YourServerName), to reflect the fact that you are working online.
Next Recommended Reading
SQL Server Analysis Services (SSAS) Storage Modes