Business Analytics

Optimising Aggregations in Analysis Services 2008

In Analysis Services 2008, query and process performance can be optimised by looking at aggregations. I've distilled the main points from the SQL Server Best Practices guide in order to obtain the main points, and added in some other details. To add this post to Twitter, please click here.An aggregate is a data structure that… Continue reading Optimising Aggregations in Analysis Services 2008

Business Analytics, Business Intelligence

Comparison between Parent-Child and User Hierarchies in Dimensions

In SQL Server Analysis Services 2008, hierarchies are important because they are critical to optimising dimensions, and thus improving the performance of the solution as a whole. Hierarchies are collections of levels, which allow users to browse cubes in a way that they will find easy to understand.Some hierarchies are natural; this means that the… Continue reading Comparison between Parent-Child and User Hierarchies in Dimensions

Business Analytics, Business Intelligence

Type 1 and 2 Relationships and Dimension Design in SSAS 2008

In the current blog, there is a summary of Type 1 and Type 2 attribute dimension changes in terms of their implementation of attribute relationships in Analysis Services 2008. Attribute relationships are an important part of dimension design for a number of reasons:Correct attribute relationships help the server to optimize data storage Define referential integrity… Continue reading Type 1 and 2 Relationships and Dimension Design in SSAS 2008

Business Intelligence

Dimensional Modelling: application to the life of King Henry VIIIth

Here, I will discuss the various types of Slowly Changing Dimensions have been discussed using the example of the marital activities of King Henry VIIIth, along with various suggestions of how the SCD technology might be used to implement these technologies using Microsoft SSIS 2008.When we model environments, how is it possible to record a… Continue reading Dimensional Modelling: application to the life of King Henry VIIIth