Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2008
    Posts
    11

    Unanswered: Mtd() On Report Date In Mdx

    I actually found the problem but could not find the code to it.

    I have reporting month which starts every 28th of the month and end 27th of next month. but when i try to get the running balance which is MTD() for it , it still takes the calander month in consideration. and when i specify the report hirerarchy , i get a #value error message throught.

    please advise

    the current code which i was using was

    SUM(MTD(),
    Measure.Q1_AVG
    (

    for report , i was trying to provide a hirerarchy was

    SUM(MTD(ReportMonth.CurrentMember),
    Measure. Q1_avg
    please help

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    We need the DDL for your tables. Some sample data would be nice too.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  3. #3
    Join Date
    Mar 2008
    Posts
    11

    Mtd()

    I am not using this as DDL

    I am trying to create a measure using a function, because i would be using those measure to pull data into report.

  4. #4
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

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