Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

SQL Server SSAS Questions

Posted on 2011-03-03
2
224 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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL Server 2012 r2 Make faster Temp Table 17 113
MS SQL Update query with connected table data 3 38
query optimization 6 14
SQL Recursion schedule 13 15
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
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…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

860 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