Posts

Showing posts from February, 2012

Best Practices and Performance Optimization

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

Order by in MDX

WITH MEMBER  [Measures].[ParameterCaption]  AS  [ReInsurer].[Re  Insurer Name ]. CURRENTMEMBER . MEMBER_CAPTION MEMBER  [Measures].[ParameterValue]  AS  [ReInsurer].[Re Insurer Name]. CURRENTMEMBER . UNIQUENAME MEMBER  [Measures].[ParameterLevel]  AS  [ReInsurer].[Re Insurer Name]. CURRENTMEMBER . LEVEL . ORDINAL SELECT  {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]}  ON   COLUMNS ,  ORDER ([ReInsurer].[Re Insurer Name]. CHILDREN ,[Measures].[ParameterCaption], BASC )  ON ROWS FROM   [CBProcedeReporting]
Post a Comment
Read more