Post reply

Aggregation Function in SSAS Store only Last Value for Measure

  • December 8, 2011 at 5:01 am

    #253266

    We have a requirement that SSAS cube store only the last value of a measure.

    Currently we are using LastNonEmpty Aggregation and it is causing a bug

    The measure here is pivoted on dimension Time and Product

    So suppose in Database

    ON Day 1

    ----------

    Product - A

    Time - 20110108

    Value in Db - 3

    After Processing Incremental

    Value in Cube = 3

    On Day 2

    ---------

    Product - A

    Time- 20110108

    Value in DB- 2

    After processing Incremental

    Value in Cube = 3 + 2 = 5

    But here we want the Value in Cube = 2

    What are the options we can look at?

  • December 8, 2011 at 8:11 am

    #1418699

    Your example doesn't indicate this, but you may be seeing the aggregation at the parent level of children that you weren't expecting. This blog post[/url] shows this reasonably well.

    Steve.

  • December 12, 2011 at 1:07 am

    #1419882

    Thank you so much for your post.

    __________________

    Watch Sherlock Holmes: A Game of Shadows Online Free[/url]

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply