O'Reilly logo

Professional SQL Server™ Analysis Services 2005 with MDX by Stephen R. Quinn, Sivakumar Harinath

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

12.2. Online Mode

As an administrator you need to ensure databases and their objects are kept up to date. Otherwise, your end users will query out of date information. After creating an OLAP database in SSMS you can use the role dialog to create roles and provide permissions to specific users to be database administrators. To reduce confusion, deployed Analysis Services projects should be named the same as the database created by the server administrator. Once the database is created then the server or the database administrator can perform administrative operations using SSMS such as adding new roles, assemblies or processing objects periodically. There might be certain design changes which you will have to make to the database based on additional requirements from the end users. In such a circumstance you would not be able to make the changes in the original project and deploy that project to the Analysis Services instance since the new objects added to the database will likely be deleted. Analysis Services 2005 provides you two ways to make additional changes. You can connect to the Analysis Services database on the server directly through BIDS and then make the changes in a mode called "online mode". The second option is to import the database on your Analysis Services instance using the Import Analysis Services 9.0 project (one of the Business Intelligence Project templates that can be used from BIDS), make changes to the database in project mode and then re-deploy the project ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required