January 2005 - Posts

• What are the popular MDX functions ?

  There are many MDX functions. The exact number depends on how you count (are methods and properties are counted, what about operators, are polymorphic functions counted once or as many times are there are overloads, what version of the Analysis Services Read More... Posted Monday, January 31, 2005 10:55 AM by mosha | 1 Comments Filed under: mdx

• Analysis Services 2000 vs. 2005

  I have run across a presentation called “ Analysis Services 2000 vs. 2005 ” prepared by Jaimie Basilico and Mark Frawley (Jamie works in Microsoft as Senior Technology Specialist in the East Cost, and he is one of the best field people in Analysis Services Read More... Posted Sunday, January 30, 2005 11:19 PM by mosha | (Comments Off) Filed under: ssas

• Kerberos Authentication and Delegation in Analysis Services 2005

  Anybody who implemented multi-tier application which needs to access Analysis Services and tried to use Windows integrated security from end to end, has run into the issue of enabling delegation, which also meant forcing Analysis Services to use Kerberos Read More... Posted Tuesday, January 25, 2005 7:14 PM by mosha | 1 Comments Filed under: ssas

• Recursion in MDX - How deep can it go ?

  Recursive calculations are not uncommon in MDX. For example, one way to compute rolling sum over Time is to define calculated member as CREATE MEMBER [Measures].[RollingSales] AS ' [Time].PrevMember + [Measures].[Sales] ' To understand how this expression Read More... Posted Sunday, January 23, 2005 2:53 PM by mosha | 1 Comments Filed under: mdx

• Loading Aggregate Data with MDX Script in Analysis Services 2005

  Richard Tkachuk has just posted a new whitepaper on the www.sqlserveranalysisservices.com site called “ Loading Aggregate Data in Yukon ”. It discusses several scenarios when the data is already precomputed at the non-leaf cells and needs to be loaded Read More... Posted Thursday, January 13, 2005 6:55 PM by mosha | (Comments Off) Filed under: ssas