SQL Server Performance

duplicate rows

Discussion in 'Analysis Services/Data Warehousing' started by california6, Nov 5, 2007.

  1. california6 New Member

    I did a usage based optimization against one of our production cube and now i see a duplicate rows in my cube. The underlying table doesnt have any duplicate cube and i dont know, where is AS reading this info from.
    Could someone please suggest, why do i see this duplicate rows?
  2. anandchatterjee New Member

    Let me drill down to the cube structure!
    Your cube is showing duplicate rows but how this is generated! So your dimention should have also duplicate record! Means you have modified this data and the dimention type is changing then it would contain both the record.
    Could you please verify it and let me know your dimention structure.
  3. satya Moderator

  4. california6 New Member

    We found out that, the light optimization job which runs failed and caused the duplicate rows to show on cube's. We were told by the application support, the light optimization failure caused the data to reside in temporary files and that was showing duplicate rows. i failed to understand. but they asked us to delete the tmp files from the OLAP Database folder and things are back to normal. weird.
    But thanks for all the answers. Satya and Anand thank you once again.

Share This Page