Does order of Key Columns(collection) inside dimention editor matter? RRS feed

  • Question

  • hi guys, I've a simple dimention Date, and a few attributes like year, month, day. In order to avoid duplicate attribute key errors,

    I need to have composite key for month and day... Does the order of attribute name when defining the key column matter? 


    --Currently using Reporting Service 2000; Visual Studio .NET 2003; Visual Source Safe SSIS 2008 SSAS 2008, SVN --

    Thursday, March 20, 2014 10:26 PM


  • Hi,

    With a composite key, the ordering of the member keys is based first on the value of the first member key, and then on the value of the second member key.

    Look at this article (the end of it) from multidimensional tutorial. 

    Best regards.

    • Marked as answer by cat_ca Friday, March 21, 2014 6:36 PM
    Friday, March 21, 2014 11:31 AM