September 2007 - Posts

• How to detect subselect inside MDX calculations (aka Multiselect in Excel 2007)

  The subject of multiselect friendly calculations is a popular one in forums. I have written about it before here , here and here . In February 2008 I will write a blog which will give a definite answer on how AS2008 will deal with it (which is follow Read More... Posted Wednesday, September 26, 2007 8:38 PM by mosha | 2 Comments Filed under: mdx

• MDX Studio forum

  Two dot releases of MDX Studio generated unusually high level of feedback both in email and in the comments in both mirrors of my blog (at sqljunkies and at sqlblog ). In order to keep these and future discussions more structured and not to pollute my Read More... Posted Wednesday, September 19, 2007 6:02 PM by mosha | (Comments Off)

• MDX Studio v0.1.1 update

  Yesterday announcement of MDX Studio has generated lots of feedback, and I would like to thank everybody for taking your time to try this early version. Below I address most of the comments I received: 1. The error that got reported most is "Category Read More... Posted Wednesday, September 19, 2007 9:50 AM by mosha | 3 Comments

• Announcing MDX Studio CTP1 (v0.1 Alpha)

  Redmond, WA September 18, 2007 - Mosha Pasumansky today announced the immediate availability of MDX Studio Community Technology Preview (CTP) 1, version 0.1 Alpha. MDX Studio is tool which helps users of Microsoft Analysis Services to analyze complex Read More... Posted Tuesday, September 18, 2007 11:39 PM by mosha | 9 Comments Filed under: mdx

• PASS Presentation canceled :(

  I am very upset about it, but my tomorrow's PASS preconference presentation isn't going to happen. My flight to Denver today was canceled, after having spent few hours in Seattle airport I realized that there was absolutely no way for me to get to Denver Read More... Posted Sunday, September 16, 2007 10:10 PM by mosha | 13 Comments

• Outline of the 'Deep dive to MDX' PASS presentation

  My PASS presentation is quickly approaching. Currently there are about twice as many people registered for it than I thought there will be. I am getting a little nervous about it. After all, 7 hours is a lot of time, and I am not sure what people expect Read More... Posted Thursday, September 06, 2007 12:05 AM by mosha | 3 Comments

• Moving averages in MDX

  Moving averages is an important statistical technique for analyzing time series data. It is often used to do forecasting or trend estimations , and it is especially popular for analyzing financial data. There are many different types of moving averages, Read More... Posted Tuesday, September 04, 2007 2:29 PM by mosha | 3 Comments Filed under: mdx