Hi. I just noticed that when I expand my self referencing employee dimension rows and employee name was chosen as the attribute, the sort order appears to be the PK of the employee star table. I played with the OrderBy and KeyColumns
in the properties of the name attribute to no avail. At the moment the Key in this attribute's properties is the employee name itself and the OrderBy is Key.
How can we order expanded attribute rows by name when name is chosen?
We run STD 2008. I cant afford to renumber pks every time an employee is added. At the moment there is no user defined ssas hierarchy in this dim's designer panel. My recollection is that a hierarchy here might interfere with the security
and/or self referencing behavior but I may be mistaken about that and would have to reread some old notes if that becomes an issue.
View Complete Post