Stairway to MDX - STEP 2: The Ordinal Function

  • Comments posted to this topic are about the item Stairway to MDX - STEP 2: The Ordinal Function

  • Excellent article, thanks!

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Another quite good lesson:

    http://www.learn-with-video-tutorials.com/mdx-video-tutorial-free

    https://www.youtube.com/user/learnwithtutorials/playlists

  • Hi All,

    Although this has been highly regarded by some users,

    as a complete beginner to MDX I am finding the tutorials very difficult to follow.

    That being said these tutorials are giving me a valuable insight into MDX and how they work and will continue on with the hope that somewhere along the series everything will click into place...hopefully

  • Although this has been highly regarded by some users,

    as a complete beginner to MDX I am finding the tutorials very difficult to follow.

    waqqas.zia-

    Honestly, I wouldn't start here as a complete beginner. The book "SQL Server 2008 MDX" will help you build a solid foundation. "Practical MDX Queries: For Microsoft SQL Server Analysis Services 2008" has a lot of good drills to reinforce the syntax. For me, it took getting use to the rules for creating sets on the axes before getting familiar with all the things you can do with calculated members (as discussed in this stairway). These sets (of tuples) define the context for the cell/calculated members evaluation.

  • Level 1 in the series showed a basic SELECT statement and Lesson 2 starts with calculated members and using .CURRENTMEMBER, etc... Was looking for a tutorial that progressed by introducing new concepts, etc... Reccommendations?

    Thanks : )

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply