locked
ssas displaying latest dimension attribute RRS feed

  • Question

  • Hi,

    I have a cube with a fact table and 3 dimensions.  One of the dimensions is a type 2 and surrogate key is stored in fact table.  If i query the database, the dimension attributes display correctly, however the cube is always displaying the latest dimension attribute and not preserving the history.  

    The measures are correct for the time period displayed, but the dimension attributes always show the latest values.

    thanks

    Scott


    Tuesday, June 30, 2015 2:21 AM

Answers

All replies

  • Hi S,

    Are you sure that you have connected the measure group with the dimension using the surrogate key? If so, SSAS will use the attributes in your dimension.

    Another thing to check is that your attributes are "attributes" of the surrogate key, not "attributes" of the natural key. This is in the Attribute Relationship Editor of the dimension editor.

    You can be sure that SSAS will be displaying attributes that you have defined. If the above suggestions don't get to the cause, try, simply browsing the dimension using the surrogate keys. You might need to make the surrogate keys visible in the dimension.

    Hope that helps,


    Richard

    • Proposed as answer by RichardLees Wednesday, July 1, 2015 2:18 AM
    Tuesday, June 30, 2015 3:41 AM
  • Hi,

    if you  use surrogate key , when a new record arrive in dimension , old one is expired and new arrive attribute mark as a current and relationship between dimension attribute link with fact measures with new surrogate key so you always got new attribute data.

    please see

    ref-http://forum.kimballgroup.com/t1323-expired-records-breaking-ssas-cube-if-not-present

    ref-https://social.msdn.microsoft.com/Forums/sqlserver/en-US/d9a72867-d0bc-4587-bc5b-5f2614c8c9dc/trying-to-filter-out-some-expired-or-not-used-dimensions-in-data-source-view-error-processing?forum=sqlanalysisservices

    please correct me if i am not understand you problem

    Regards,

    Manish

    Tuesday, June 30, 2015 5:07 AM
  • I found my issue.

    I had an incorrect attribute relationship in the dimension that was causing duplicates.  I updated the key column to make the values distinct and that fixed it.

    For those who don't have it, the BIDS helper is a good tool to run against the dimensions to find these issues:

    http://bidshelper.codeplex.com/wikipage?title=Dimension%20Health%20Check&referringTitle=Documentation

    thanks

    Scott

    Tuesday, June 30, 2015 3:35 PM