October 2006 - Posts

• Time calculations in UDM: Parallel Period

  Comparing current data to the data in the same unit (day, month, week) in the previous period (year, quarter, semester) is one of the most fundamental tasks in the OLAP system. In MDX this is usually archived through the ParallelPeriod function. However, Read More... Posted Wednesday, October 25, 2006 10:07 AM by mosha | 6 Comments

• Querying dimensions in MDX

  In this article we will discuss and evaluate different methods Analysis Services 2005 provides for accessing dimension members. Requirements, flexibility and performance tradeoffs will be discussed. In the OLAP system, the primary object for storing data Read More... Posted Wednesday, October 11, 2006 5:34 PM by mosha | 2 Comments Filed under: mdx

• MDX: NonEmpty, Exists and evil NonEmptyCrossJoin

  When NonEmptyCrossJoin was introduced in AS2000 it made a lot of people happy. Indeed, this function seemed to be almost magic. It worked wicked fast and seemed to solve all the performance problems with. While the original intention was to be used in Read More... Posted Monday, October 09, 2006 11:25 PM by mosha | 3 Comments Filed under: mdx

• XAML based PivotTable control

  Some people think that "the world doesn't need another OLAP client". I disagree. We are still far away from the intuitive, powerful OLAP client which generates clean and efficient MDX. But it is true that there are plenty of existing clients. Read More... Posted Sunday, October 08, 2006 6:04 PM by mosha | 5 Comments Filed under: tools

• Member Caption Translations in MDX

  Analysis Services 2005 has strong support for translations. Most of the translation support is about metadata translations, i.e. names of cubes, hierarchies, measures etc. But there is also a way to specify translations for the attribute members. For Read More... Posted Saturday, October 07, 2006 8:29 PM by mosha | 2 Comments Filed under: mdx