Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Help: creating named calculation for sorting Expand / Collapse
Author
Message
Posted Tuesday, December 11, 2012 12:36 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, February 8, 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
Posted Wednesday, December 12, 2012 1:33 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, January 13, 2014 7:34 AM
Points: 117, Visits: 499
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 »

Add to briefcase

Permissions Expand / Collapse