Andyblg's Blog

July 1, 2009

Some words about measures and hierarchies

Filed under: DW — andyblg @ 13:12
Tags: ,

Measure – metrics used to analyze business performance

  • Additive
  1. can be summed across all dimensions
  2. sales dollars
  • Semi-additive
  1. cannot be summed across some dimensions
  2. bank account balance snapshots across time
  3. balance at the end of the month is not equal to the sum of daily balance
  • Non-additive
  1. cannot be summed across any dimensions
  2. account numbers, invoice numbers, cannot be summed, even if they are numeric



  • Natural hierarchies contain attribute relationships between each pair of level

(Product category->Product subcategory->Product name)

  • Attribute hierarchies expose a single attribute

(Product name)

  • User hierarchies expose multiple levels, but do not include relationships between all attributes

(Gender->Income level)


  1. Awesome site you have here but I was curious about if you knew of any user discussion forums
    that cover the same topics talked about here? I’d really love to be
    a part of online community where I can get suggestions from
    other experienced people that share the same interest.

    If you have any suggestions, please let me know. Thanks a lot!
    here maybe this also click here and website

    Comment by here — December 6, 2014 @ 13:40 | Reply

  2. Great post! I’ll subscribe right now wth my feedreader software!

    Comment by LnddMiles — July 22, 2009 @ 05:02 | Reply

  3. The best information i have found exactly here. Keep going Thank you

    Comment by buy_vigrxplus — July 15, 2009 @ 00:43 | Reply

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Create a free website or blog at

%d bloggers like this: