Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Posts
    163

    Red face Unanswered: Please help me with this MDX

    Can someone please help me figure out this MDX.

    iif(Current dimension.name=Open Time dimension.name,null,(sum(ytd(Open Time dimension.currentmember),Length measure)-
    sum(ytd(parallelperiod(year,1,Open Time dimension.currentmember)),Length measure)))/
    sum(ytd(parallelperiod(year,1,Open Time dimension.currentmember)),Length measure)*100


    Is it returning the %age change from the same period last year, or the %age change from the previous period, or ???

    I'll appreciate your help.

    Thanks

  2. #2
    Join Date
    Apr 2004
    Posts
    11

    ?

    Call me stupid, but does that statement work? The key word CURRENT is normally used as SET.CURRENT. Is this using Microsofts Analysis Services?

    Ta
    Paul

  3. #3
    Join Date
    Oct 2003
    Posts
    163
    The backend (where the cube resides) is Analysis Services (as you correctly guessed).

    The front-end is MIcrosoft Data Analyzer (from where I did a copy/paste) of the MDX.

    In addition to replyig to my question can you also kindly provide me with a URL where they have good articles to learn MDX.

    Thanks.

Posting Permissions

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