Solved

How are the values Aggregated in ASO?

Posted on 2009-07-08
2
415 Views
Last Modified: 2012-05-07
How are the values Aggregated in ASO? Is there any command that you run to aggregate the values in ASO?
0
Comment
Question by:AJITPADHY
2 Comments
 
LVL 5

Accepted Solution

by:
garycris earned 500 total points
ID: 24807843
Kind of trick question.  Why do I get the sense you are studying for something?

ASO cubes are technically, fully dynamic.  You load data to level 0 and can immediately query to see consolidated results.

For performance enhancement, you can materialize aggregations which will create views that help queries to run faster.
0
 

Author Closing Comment

by:AJITPADHY
ID: 31600989
thanks
0

Featured Post

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

1. Set up your parameter at the report level as usual, check the box Multi-value, and set the Data Type to String 2. Set the Stored Procedure Parameter to varchar(max)  --<---- This part here is the key to it's success Example:    @cst_key var…
I recently went through setting up a JasperReports Server using the AWS EC2 instance, and this article will cover some basic administration tasks I had to perform.
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

825 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