Hi,

I have a table called Age Band which looks like this:

ID Description
1 0-5
2 0-5
3 0-5
4 0-5
5 0-5
6 6-10
.. .
.. .
.. .

I use the Descrption column in as an attribute in a Dimensional table
in the cube. Unfortunately when I browse the cube the description is
not sorted right - for example:
40-50
5-9
55-60

How can I solve this? I saw that the dimensionattributes can be ordered
by key, name and attributekey,attributename

Assuming that the "Age Band" table is in SQL Server,
you could replace the table with a Named Query in the Data Source View,
like:

(select min(ID)
from [Age Band] ab2
where ab2.Description
= ab1.Description) as BandID
from [Age Band] ab1
Then define BandID as the key for the Description attribute, and it can
be ordered by key.


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***