June 2007 - Posts

• MDX is like chess. Are you ready to play against Grandmaster ?

  Warning: This post carries no or very little practical value. It is mostly obscure. However, if you are MDX junkie, you may find it interesting. I read this post by Panorama employee Oz Shal-Bar. It is very well written - it talks about non-trivial issues Read More... Posted Saturday, June 09, 2007 12:01 AM by mosha | (Comments Off)

• Katmai June CTP - Attribute Relationships tab

  As everybody knows by now, the first widely public CTP of Katmai has been released on Microsoft connect site . It is accompanied by documentation about what are the new features expected in SQL 2008. But this documentation is a little bit too high level, Read More... Posted Thursday, June 07, 2007 8:41 PM by mosha | (Comments Off) Filed under: katmai

• Notes about Notes from Microsoft BI Conference

  I was reading the blog post " My notes from Microsoft BI Conference " by Vidas Matelis. It is a collection of notes recorded at different presentations, chalk talks etc. I felt that I agree with some of them, disagree with some, and have no opinion about Read More... Posted Saturday, June 02, 2007 12:16 AM by mosha | 1 Comments Filed under: mdx, performance, ssas

• Counting 'in-flight' events in MDX

  Time dimension has special meaning in OLAP and DW. The classic problems involve looking at previous period, parallel period, computing moving averages and running sums. Today we will look into less common, but nevertheless interesting problem of 'in-flight' Read More... Posted Friday, June 01, 2007 7:20 PM by mosha | 4 Comments Filed under: mdx