Results 1 to 2 of 2

Thread: MDX Time Issue

  1. #1
    Join Date
    Nov 2008

    MDX Time Issue

    Hi, I have a fairly simple cube (in SSAS2005) containing measures for revenue and margin, dimensions for brands, Sku, time, etc. I need to calculate current Year YTD revenue as a factor of the total revenue from all periods in the previous year. E.g.

    Revenue Nov 2008 YTD = 1,500,000
    Revenue Nov 2007 Prior YTD = 1,250,000
    Revenue All periods Prior Year (Nov 2007 > Oct 2008) = 18,500,000

    Result = 8.1%

    Is this possible without having to "hard code" years into the MDX?

    Thanks in advance. . .

  2. #2
    Join Date
    Jun 2004
    Atlanta and Manhattan

    Take a Look at My "Time" Articles ...


    Lots of info surrounding what you need, with multiple working examples, in these articles:

    MDX Time Series Functions, Part II: The OpeningPeriod () and ClosingPeriod() Functions

    MDX Time Series Functions, Part III: The LastPeriods() and ParallelPeriod() Functions

    Also, many other articles in my monthly MDX Essentials column deal with MDX time functions.

    HTH. Let me know if I can answer further questions.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts