December 2004 - Posts

• Using Linear Regression MDX functions for forecasting

  MDX provides several functions for computing linear regression, however those functions are anything but intuitive or easy to use. This is definitely an area in MDX, that given a chance I would've done differently now. The problem is that when we designed Read More... Posted Tuesday, December 21, 2004 7:50 PM by mosha | (Comments Off) Filed under: mdx

• Dynamic Dimension Security in Analysis Services 2000

  Subject of security in Analysis Services is close to my heart (besides my regular responsibilities, I am also responsible for the overall security in Analysis Services). According to the OLAP Report , Analysis Services has most advanced security features Read More... Posted Thursday, December 16, 2004 5:05 PM by mosha | (Comments Off) Filed under: security

• Marrying ChartSpace and XMLA to produce cool OLAP charts for free

  Chris Harrington is a true beleiver in power of XML for Analysis standard (check out some of his quotes in this recent article in Enterprise Systems). He was early adopter of this technology, and he started a blog in 2003 about all kinds of interesting Read More... Posted Tuesday, December 07, 2004 7:45 PM by mosha | (Comments Off) Filed under: client apps

• ADOMD.NET source code for querying KPIs in Ananlysis Services 2005 in ASP.NET

  One of the more publicized features of Analysis Services 2005 is the intrinsic support for the KPIs (for more information on Analysis Services 2005 check out http://www.mosha.com/msolap/yukon.htm ). KPIs are defined by cube designer and any client application Read More... Posted Monday, December 06, 2004 7:31 PM by mosha | (Comments Off)