Help: creating named calculation for sorting

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Data Warehousing » Analysis Services » Help: creating named calculation for sorting

Help: creating named calculation for sorting

Rate Topic

Display Mode

Topic Options

Author

Message

el_masry200

Posted Tuesday, December 11, 2012 12:36 PM

Forum Newbie

Group: General Forum Members
Last Login: Friday, February 08, 2013 11:08 AM
Points: 1, Visits: 7

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.

Post #1395280

Mackers

Posted Wednesday, December 12, 2012 1:33 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, May 17, 2013 3:58 AM
Points: 117, Visits: 458

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

Post #1395489

« Prev Topic | Next Topic »

Permissions