May 2007 - Posts

• Counting Days in MDX

  Time dimension is special in OLAP. Many MDX functions usually only make sense when applied to Time dimension (PrevMember, Lag, ParallelPeriod, PeriodsToDate, ClosingPeriod etc); semiadditive measures work differently with Time etc. Today, however, we Read More... Posted Sunday, May 27, 2007 6:15 PM by mosha | 2 Comments Filed under: mdx

• I need your help or how to make multiselect work seamlessly in MDX

  This post is unusual for me. In this post I am not going to give information to my readers. I am going to ask my readers to give information to me. For quite a some time now I have been looking into problem of interaction between MDX calculations and Read More... Posted Wednesday, May 23, 2007 7:46 PM by mosha | 2 Comments

• How to get the today's date in MDX

  The question in the title of this post is a popular one. There are many scenarios, where it is desirable to navigate to the member of the Time hierarchy which corresponds to the current day, month or year. Sometimes, there is a desire to set the default Read More... Posted Wednesday, May 23, 2007 11:39 AM by mosha | 4 Comments Filed under: mdx