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

SSAS 2008 - Duplicated calculated measure values

SSAS 2008 - Duplicated calculated measure values

(OP)
We've got a couple cubes that have Invoice Line level data which includes an Item and Invoice Dollars.

There's an attribute of the Item dimension, a Y/N flag, that is used as a slicer in a calculated measure. Meaning that we only want Invoice Dollars for Items that have this flag set to N.

When I drill down to the Item level with the various Item Category hierarchies, I run into a problem of data that seems to be a sum of several Invoice Lines that then gets duplicated on multiple lines in the cube output.

When I compare the calculated measure to the base measure, I can see the Invoice Dollars and it seems like the calculated measure is the sum of multiple Items, but then there are even Items that have no Invoice Dollars that also show up with this calculated measure. The strange thing is that the subtotal for both the base and calculated measure are the same and equal the sum of the base measure.

Here's an example:

Item, Invoice Dollars (base measure), Finance Invoice Dollars (calculated measure)
A, 50, 125
B, 75, 125
C, ,125
D, 30, 30

SBTL, 155, 155

Any help is most appreciated!

Thanks!
 

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