.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Aggregation design

Posted By:      Posted Date: April 14, 2011    Points: 0   Category :

hello all,

I'm tuning up aggregations, The wizard doesn't create all the necessary ones. Lets say I've a time Dim and attribute relationships defined for the hierarchy from Year - Month - day. I've partitioned the cube by year.  [2011 partition] has 26 aggregations built, The advanced view of Aggregation shows that it has built 26 aggregation for (Time intelligence) attribute but non on Year, Month or day attribute.

I cleared the cache and ran the profiler and drop the Time dimension hierarchy in excel 2007and see Query Begin and Query End events and I don't see any events for  'Get data from aggregations' and duration for query was 8000 ms.

What should I do next?

Since I have 26 aggregations built for that partition,

How many aggregations do I need to add for the Year Attribute?  Same,how many aggregations do I need to add for Month .......?

I see when I put 4 aggregations for the Year, its been picked up by 'Get data from aggregations' event. Do I need to start from 1, 2,3...and so on until it gets picked? (my question is how much is too 'less' and too 'much'? how can I determine this?)

I would appreciate anyone who can help me understand this..


View Complete Post

More Related Resource Links

Explanation on Aggregation Design Tab in BIDS for SSAS 2008?

Is there info on how the new aggregation design TAB in BIDS for SSAS 2008 works? It looks great but I have no idea what it does and how to use it. Is that just me?

aggregation design wizard is unstable?


hi all,

i lauched the aggregation design wizard, on the Set Aggregation Options page, i chose the 'I Click Stop' option,

and clicked Start, it ended up with a performance gain of 30% and 100 aggregations,

i then clicked Reset and then Start, however, this time it ended up with a performance gain of 40% and 122 aggregations.

curiously, i clicked Reset and then Start, and i found it always ended up with different results each run.

is aggregation design wizard designed to behave in this way?

seems the underlying aggregation design algorithm is NOT stable.


any suggestions will be appreciated.




BI, Data Mining, Analytical CRM

Abstract Factory Design in C# , Vb.NET

Provide an interface for creating families of related or dependent objects without specifying their concrete classes

Prototype Design Pattern in C#. Vb.NET

Specify the kind of objects to create using a prototypical instance, and create new objects by copying this prototype

Adapter Design Pattern in C#, VB.NET

Convert the interface of a class into another interface clients expect. Adapter lets classes work together that couldn't otherwise because of incompatible interfaces.

Singleton Design Pattern in C#, Vb.NET

Ensure a class has only one instance and provide a global point of access to it.

Solidify Your C# Application Architecture with Design Patterns

design pattern can solve many problems by providing a framework for building an application. Design patterns, which make the design process cleaner and more efficient, are especially well-suited for use in C# development because it is an object-oriented language. Existing design patterns make good templates for your objects, allowing you to build software faster. This article describes several popular design patterns you can use in your own applications, including the singleton, the decorator, the composite, and the state classes, which can improve the extensibility of your applications and the reuse of your objects.

What Are Design Patterns and Do I Need Them?

Software professionals may be familiar with the term "Design Patterns," but many have no idea of where they come from and what they truly are. Consequently, some do not see the value and benefits design patterns bring to the software development process, especially in the areas of maintenance and code reuse.

Design Patterns for .NET

It is not the intent of the Design Pattern Series to focus on providing a theoretical knowledge dump of all there is to know about design patterns. There are many books that do that already. Instead, this series will focus on providing lots of practical examples. However, there will be some theory to help address important points concerning design patterns. I use the theory of design patterns mostly as a guide and instead make references to good design pattern books for more detail explanation.

Singleton Design Pattern in Asp.net using C#

When we want to make a only one instance of a class and also making sure that there is a global access point to that object then the design pattern we user is called Singleton. The pattern ensures that the class is instantiated only once and that all requests are directed to that one and only object.

The Factory Design Pattern

Software architects generally think in terms of high-level abstractions rather than low-level programming details. Representing a system in terms of high-level abstractions promotes understanding of the system and reduces its perceived complexity. One such set of abstractions is software design patterns. They have been successfully applied in the past to simplify and solve recurring problems in software design.

Abstract Factory Design Pattern (Sample in C# and VB .NET)

An abstract factory provides an interface for creating families of related objects without specifying their concrete classes. Sometimes one wants to construct an instance of one of a suite of classes, deciding between the classes at the time of instantiation. In order to avoid duplicating the decision making everywhere an instance is created, we need a mechanism for creating instances of related classes without necessarily knowing which will be instantiated.

GOF Creational Design Patterns with C#

The GOF design patterns help address the following challenges :

design ready to accommodate change & growth

design flexible systems which come ready to handle reconfiguration and run time tailoring

code in manner to facilitate reuse during the development and extension phases ... ie. both external and internal reuse, so that we are rewarded by efficiencies as the project progresses, coming from investments made earlier in the project.

implement change in a way that doesn't overly shorten the system's useful lifespan

Design Patterns - Using the State Pattern in C#

What is the State Pattern?

The State Pattern is a behavioral pattern that can be used to alter the behavior of an object at run time. As the state of an object changes, the functionality of the object can change drastically. This change of behavior is hidden from the Client and the Client interfaces with a wrapper object known as the Context. The State Pattern is a dynamic version of the Strategy Pattern.

Design Patterns

gives Total Idea About Design Patterns

Need help for Architecture design


I need help to make decision for making framework for new project.
Project is financing (banking) project. It'll b using .net 3.5 sp1 with sql server 2005.
I want to know what should be best approach for framework? Mean to use LINQ or go with Stored procedure way with 3 tier architecture?
or anything else?

For current financing project the framework is done by one of MVP. He used LINQ to all things.
But we facing problem of w3wp process hang. We cant go for web gardening or farming bcz LINQ objects cnt be serialized to store in Session etc.
Difficult to use Transactions in LINQ. Have to use TransactionScope lead to MSDTC problems etc.

Please give your opinion.

database interface design question


For handy database interface, is it good to use SqldataSources exclusively intead of EntLib functions?

Thanks for any feedback.

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend