Post reply

Help: creating named calculation for sorting

  • December 11, 2012 at 12:36 pm

    #267413

    please help me

    i need to create an Employee attribute (named calculation) that displays employees’ first and last names, but sorts their names by last name and then by first name

    note i use analysis services 2008.

  • December 12, 2012 at 1:33 am

    #1567741

    Sounds a bit wierd...

    Anyway, in your employee dim view create two columns - one that is Surname, FirstName & one that is FirstName Surname

    Add these to your employee dimension (don't fortget to refresh the DSV) & hide the column you want to use as the sort (properties of the attruibute --> AttributeHierchyVisible --> False). Do you have an employee id? If so I would make that the key of the attrubutes

    In the attribute relationship make your sorting column an attribute of your reporting column.

    In the properties of the reporting column, change the OrderBy property to be AttributeName and OrderByAttribute to be the reporting column

    Mack

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

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