Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Change display order in hierarchy

Status
Not open for further replies.
Waynest

Waynest

Programmer
Jun 22, 2000
321
GB
Hi

(SQL Server 2005, BI Studio)

This is quite a simple problem (I hope)

Within one of my cube dimensions I've set up a 3 tier hierachy which is based on the description fields from 3 of my tables.

In the cube browser I can drag in the hierarchy & its working as intended. However, the descriptions are listed in alphabetical order & I would like them to appear in the order of the underlying key column.

How do I sort the decription attribute on its key colum please?



 
Status
Not open for further replies.

Similar threads

juanvg1972
  • Locked
  • Question
Problems linking dimension tables and fact tables in SSAS cube
Replies
0
Views
154
juanvg1972
juanvg1972
edvmat
  • Locked
  • Question
Error in the conversion sql query
Replies
2
Views
227
edvmat
edvmat
burakcan
  • Locked
  • Question
How to hide unwanted dimension values in SSAS cube
Replies
1
Views
287
Motlatjo
Motlatjo
burakcan
  • Locked
  • Question
How to rounding up to next integer value In MDX
Replies
0
Views
189
burakcan
burakcan
JP_Quinn
  • Locked
  • Question
Adding New Column to Dimension Table, Used in Other Cubes, Must I Update the Models of Other Cubes?
Replies
0
Views
186
JP_Quinn
JP_Quinn

Part and Inventory Search

Sponsor

Back
Top