Platinum Sponsor

Attribute Relationships, Aggregations and writing high performance MDX

Setting proper relationships for the attributes of a dimension is essential from a query performance point of view. It is one of the most important things while dimensional modelling.
Aggregations are pre calculated summaries of cube data that help enable Microsoft SQL Server 2005 Analysis Services (SSAS) to provide rapid query responses. Aggregations are like fact table data grouped and aggregated to a higher level in the Hierarchy. Building the correct aggregations can greatly enhance query performance.
MDX Studio can be used to analyze complex MDX expressions, monitor performance characteristics of MDX queries and get insight into how MDX interacts with other UDM features such as attribute relationships. MDX Studio provides unique visualization representation of MDX expression and allows the user to interact with different stages of MDX execution. It is built by Mosha Pasumansky, who is inventor of MDX and one of the Architects of Microsoft Analysis Services.
Presented by Ashwani Roy at SQLBits VI
Tags (no tags)
  • Downloads
    Sorry, there are no downloads available for this session.
  • SpeakerBIO
    ashwani_roy.jpg
    I am SQL Server MVP and SQL Server Business Intelligence and C# consultant at CodePerfect Limited .  I am also a regular speaker in SQL Server and BI conferences in UK.
    I have worked with SQL Server BI stack since 2003 and I am Microsoft Certified IT Professional. My main field of expertise are SQL Server Analysis Services, MDX, SQL Server Database Engine, T-SQL, and SSIS and C #.
    http://codeperfect.co.uk
  • Video
    The video is not available to view online.