Solved

SQL Server SSAS Questions

Posted on 2011-03-03
2
221 Views
Last Modified: 2016-02-14
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
Comment
Question by:mystudent
2 Comments
 
LVL 10

Accepted Solution

by:
itcouple earned 500 total points
ID: 35035129
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
 

Author Closing Comment

by:mystudent
ID: 35100689
Thanks, Emil.
0

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now