How to Handle Non additive measures

• Sriram-288748

  SSCrazy

  Points: 2874

  More actions

  April 13, 2009 at 11:47 pm

  #199445

  hi,

  how do I handle non additive measures in ssas, I have tried with the "NONE" aggregate function and dont see any data...whereas my fact table has data in that particular column...

  Regards,

  Sriram

  Sriram

• freeman.e.l

  SSC Veteran

  Points: 249

  More actions

  December 24, 2009 at 3:57 pm

  #1096423

  Try LastNonEmpty and such. What are you using the non-additive measure for?

• becklery

  Hall of Fame

  Points: 3315

  More actions

  January 1, 2010 at 9:56 am

  #1098097

  Hi.

  Please refer to the url below:

  http://www.bipminstitute.com/olap/non-additive-measures-facts.php

  I wish it will be helpful.

  Regards,

  becklery.

  RAQ Report: Web-based Excel-like Java reporting tool[/url]