[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

SQL Server SSAS Questions

Posted on 2011-03-03
2
Medium Priority
?
230 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
[X]
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
2 Comments
 
LVL 10

Accepted Solution

by:
itcouple earned 2000 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

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.

Question has a verified solution.

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

     When we have to pass multiple rows of data to SQL Server, the developers either have to send one row at a time or come up with other workarounds to meet requirements like using XML to pass data, which is complex and tedious to use. There is a …
Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…

650 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