INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

YTD - Measure oddity

YTD - Measure oddity

(OP)
Hello All -
I have an issue with a YTD measure.  Being pretty new to MDX I found several examples and they all look pretty much the same.  Here is my code:

Sum(YTD([Time].[Year Quarter Month].CurrentMember),[Measures].[Pounds])

When analyzing YTD-Pounds by ProductType July-07 & July-08 in ProClarity (creating this measure in ProClarity, not using the SSAS YTD Measure), I return all 8 product types and the pounds for each unique month. - Perfect.

When using the SSAS version of YTD-Pounds (created as a Calculated Member) for this analysis, one ProductType does not return.  I have determined that choosing only the month of July is part of the problem because the only sale of the missing product type was in April.  If I select January through July, then of course I see the number.  

I want to believe that a YTD measure will give exactly that:  Year to Date, no matter what point in time is selected.  Thus April is before July and if I choose July then I get Jan-July YTD values. Am I wrong here?

The only other thing that is unique here is that the ProductTypes are defined in the Data Source View as a Named Calculation in a Case statement and this AWOL ProductType happens to be a subset of a top level group.  

Is there limitations to using Named Calculations that I need to keep in mind?  I read as much as I could find on these and did not find references to short commings.  This is the cleanest way for me to determine this ProductType at this time, without going back to the ETL process and reworking.

Thanks in advance for any ideas and I apologize for the lengthy post!

Scottie

 

RE: YTD - Measure oddity

paste your MDX stored in th cube.  My hunch is that adding an IIF to convert null pounds to 0 will solve the problem, but I want to see what you are doing.

Paul
---------------------------------------
Shoot Me! Shoot Me NOW!!!
                           - Daffy Duck

RE: YTD - Measure oddity

(OP)
Paul - thanks for taking a look.  Here is the MDX for my YTD-Pounds measure:

Sum(YTD([Time].[Year Quarter Month].CurrentMember),[Measures].[Pounds])

scottie

RE: YTD - Measure oddity

I don't have food mart on my system here so I will look at it tonight.

Paul
---------------------------------------
Shoot Me! Shoot Me NOW!!!
                           - Daffy Duck

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close