Best Practices and Performance Optimization

http://www.mssqltips.com/sqlservertip/2565/ssas--best-practices-and-performance-optimization--part-1-of-4/ 

Comments

Post a Comment

Popular posts from this blog

SSRS Report Design: Best Practices

Introduction Microsoft® SQL Server™ Reporting Services is a comprehensive reporting tool. In using Reporting Services, you can design and deliver a wide range of reports, from simple tables to online free-form reports with graphical items and interactive links. Reporting Services can render reports for a variety of client-viewing formats, including HTML, PDF, Excel, and image formats. The wide variety of options and choices can be problematic for report authors who must make numerous decisions when choosing how to lay out a report. This paper provides a few guidelines to make these decisions easier and answers common questions.
Read more

To improve MDX Query performance use NonEmpty Function and use filter instead of IIF( IS NULL)

To improve MDX Query performance use NonEmpty Function and use filter instead of IIF( IS NULL) Function and  in Calculated measure WITH MEMBER [TEST1] AS SUM(LastPeriods(12,[dimTimeDimension].[Month].&[2009]&[12]), [Measures].[Gross Written Premium]) MEMBER [TEST2] AS SUM(LastPeriods(12,[dimTimeDimension].[Month].&[2008]&[12]), [Measures].[Gross Written Premium]) MEMBER [TEST3] AS SUM(LastPeriods(12,[dimTimeDimension].[Month].&[2007]&[12]), [Measures].[Gross Written Premium]) MEMBER [TEST4] AS SUM(LastPeriods(12,[dimTimeDimension].[Month].&[2006]&[12]), [Measures].[Gross Written Premium]) MEMBER [TEST5] AS SUM(LastPeriods(12,[dimTimeDimension].[Month].&[2005]&[12]), [Measures].[Gross Written Premium]) MEMBER [R12 LR] AS ([Measures].[R12 Claims Incurred WO IBNR] / [Measures].[R12 Gross Earned Premium ]) select { [Measures].[R12 LR] } ON COLUMNS , TOPCOUNT(filter(NONEMPTY( [dimCustomerDimension].[Full Name].children * [dimChannelD...
Read more

Conceptual Framework for Business Intelligence

Image
Conceptual Framework for Business Intelligence The term Business Intelligence (BI) incorporates the concept of deriving useful information from the data in an organization. Designing a BI application involves multiple layers. The goal of this section is to provide a common framework for architects and developers. This framework is conceptual, technology agnostic, and covers the major phases, features, and functionality required to effectively implement a BI solution. The conceptual architecture in below Figure is comprised of five major areas and a set of cross-cutting concerns. Conceptual system architecture
Read more