SQL Server Analysis Services slicing and dicing

Published 27 January 08 05:08 AM | SQL Master 

I was going through Books Online in learning the concepts of slicing of data within Analysis Services for the new project that is upcoming, all these years I have basic knowledge of SSAS and with latest available features in SQL Server 2005 Analysis Services there is more to learn from there.

Slicing is the one that is most useful when you have a huge analysis services database as you can use this view to examine the structure of a cube and to check data, calculation, formatting, and security of database objects. You can quickly examine a cube as end users see it in reporting tools or other client applications. When you browse cube data, you can view different dimensions, drill down into members, and slice through dimensions.

Further information on this subject can be found from SSAS Partition Slicing link.

 

Comments

# SSQA.net - SqlServer-QA.net said on January 27, 2008 6:01 AM:

I was going through Books Online in learning the concepts of slicing of data within Analysis Services

# Other SQL Server Blogs around the Web said on January 27, 2008 10:11 PM:

I was going through Books Online in learning the concepts of slicing of data within Analysis Services

# TrackBack said on February 11, 2008 6:46 AM:
Anonymous comments are disabled

About SQL Master

**__________________________________** SQL Server MVP, Sr. DBA & industry expert. - Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it. It is also a power and you will gain by sharing it.

Search

Go

This Blog

«January 2008»
SMTWTFS
303112345
6789101112
13141516171819
20212223242526
272829303112
3456789

Syndication