Analysis Services 2005 defines for peak performance

Analysis Services 2005 in SQL Server improves cube design and performance. Learn how attribute relationships advise Analysis Services how data should be rolled up.

What is the default service name for Analysis...

What is Analysis Services in SQL Server 2005?

Check out our Top 10 tips on Analysis Services 2005 that will help you navigate through the features and functionality of this priceless Business Intelligence tool.

Scale-Out Querying with Analysis Services

This white paper describes how to set up a load-balanced scalable querying environment for Microsoft SQL Server 2005 Analysis Services so that you can handle a large number of concurrent queries to your Analysis Services servers. Load-balanced querying ensures that readers of OLAP cubes can consistently query for the latest aggregations throughout the day and distribute the load of all queries among the available servers. This scale-out querying architecture optimizes cube processing time, increases the frequency of cube update, and makes processing more robust as you can afford more frequent processing and transparent error recovery.

By default in SQL Server 2005 Analysis Services,...

What types of authentication exist in SQL Server...

You create a SQL Server 2005 Analysis Services...

Conditional Formatting in the Analysis Services Layer

Support conditional formatting for enterprise reports from the Analysis Services layer of the integrated Microsoft business intelligence solution.

You have installed a new SQL Server 2005...

Synchronising Databases in SSAS 2005

Planning for disaster recovery in SQL Server Analysis Services can be tricky. Fortunately SQL Server 2005 introduces the concept of a database synchronization, allowing you to transfer information and meta data from one server to another. Yaniv Mor brings us a look at this feature.