Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 240
  • Last Modified:

SQL Server SSAS Questions

Hi, Can someone answer the following questions for me:

1. For SSAS partitions, one can build aggregations for them. What exactly has been done after aggregations were built? Are they new tables with summary data and where I can locate them?

2. Aggregation takes up storage spaces, but what exactly taking up the spaces? Are the indexes used to calculate the summary data taking up the spaces or something else?

3. Are the indexes created for aggregation using index intersection or compound key indexes?

4. A cube with MOLAP and ROLAP type of partitions, where do the summary tables stored? the AS database or on the data source?

5. One can use SQL Profiler to catch MDX queries. How can it be helpful for AS to create proper indexes to facilitate the response time of frequently used queries?

6. Does AS engine create aggregations based on hierarchy?

7. There are options to give percentage to build for aggregation. What is the percent referring to? Percent of total combination of foreign keys of a measure group?

Thanks,
0
mystudent
Asked:
mystudent
1 Solution
 
itcoupleCommented:
Hi

This might help http://msdn.microsoft.com/en-us/library/ms174912(v=sql.90).aspx

The link is for 2005 but it still should be relevant. The same should be available for 2008 on microsoft side somwhere.

Regards
Emil
0
 
mystudentAuthor Commented:
Thanks, Emil.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now