November 2008 - Posts

• AS2008 MDX: subselects and CREATE SUBCUBE in non-visual mode

  There were not very many changes to MDX syntax in AS2008, and Vidas Matelis described most of them in his blog here (for his list of all changes in AS2008 check this blog entry ). I just noticed that there is at least one more change which Vidas didn’t Read More... Posted Tuesday, November 04, 2008 12:22 AM by mosha | 3 Comments Filed under: mdx

• Custom filters with MDX subcubes

  Omniture Discover is not general purpose OLAP client tool. Rather it is specialized application that lets users to explore data from the Omniture’s Web Analytics product. But it does look and feel like an OLAP browser – which is not surprising, since Read More... Posted Monday, November 03, 2008 11:30 PM by mosha | 2 Comments Filed under: client apps, mdx

• Gross margin - dense vs. sparse block evaluation mode in MDX

  Gross margin (also known as Gross profit margin or Gross profit rate) is defined as (Revenue – Cost of Sales)/Revenue. In terms of Adventure Works sample database we can write this in MDX as [Gross Margin] = ( [Measures] . [Internet Sales Amount] - [Measures] Read More... Posted Saturday, November 01, 2008 4:23 PM by mosha | 2 Comments Filed under: mdx, performance