Dimension property : OrderBy Key

  • Hi guys,

    I'm a newbie in development of Sql Server Analysis, I would like to ask some guidance. It's a basic really.

    I have a Date Dimension with one of the attribute is Month.

    temp

    Question is in that property OrderBy there are 4 options :

    • Key
    • Name
    • Attribute Key
    • Attribute Name

    The default is Name, but if I change to Key, what key exactly it referring to ? Is it the underlying table's Key ? what if there are multiple keys, how we select which key

    Thanks,

  • It's whatever you designated as the key in the source.  If you scroll down to the bottom of the properties menu you are in, you will see it.  In the case of Months, the key is either 1-12 or a unique number with month one of the data warehouse being 1.  The months can't be in name order because the names are not chronological.

    (PS, I have not been able to see my own posts since the site changed, so if you see this, please let me know.)

  • It's whatever key you defined for that specific attribute, and it has to be a single column.

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

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