How do I sort month hierarchy in the time dimension? My months are displayed
as March, Jan, Feb. instead of Jan, Feb, March. The tutorials in ssas2k5 do
address this issue at the following link:
http://msdn2.microsoft.com/en-us/lib...8(SQL.90).aspx

But its not working for me.
Please help...
TIA..

Hi,

What attributes do you have included in your dimension and in the
relevant hierarchy?

Generally speaking, you can you the "OrderBy" property to order the
members in an attribute in a particular order: you can use the "Key",
which is the key column of the attribute, or the "AttributeKey", which
is the key column of another attribute which has a attribute
relationship with this attribute, or the "AttributeName", which will be
the member name of an attribute, again, with an attribute relationship
to this attribute.

Thanks for responding. Your suggestions were mentioned in the tutorial and I
did follow them but still the month hierarchy of the dimension would not sort
correctly. I don't know how to script out my cube code so that it would be
easy for us to see what I am doing wrong. Is there any online article that
would show how to script out the cube code?

TIA..

"yaniv.mor (AT) mail (DOT) com" wrote:

What are the key and name columns for your month attribute?
Also, when you're saying "month hierarchy" do you mean the month
attribute hierarchy or the month attribute included in a more elaborate
hierarchy?

Inside my CalendarTime dimension, I have attributes called Year, Quarter,
Trimester, Month etc. For the month attribute column info is as follows:

KeyColumns: CalendarTime.Month
NameColumn: Source: TableID: CalendarTime, ColumnID: Month

Month is my Month attribute included in a Hierarchy level.

If I could script out my entire cube, it would be very much easier to explain.

TIA...


"yaniv.mor (AT) mail (DOT) com" wrote:

What you need to do is this:
If you don't have it yet, create a new column in your dimension table
(or you can create a new named calculation in your data source view)
which will represent the number figure of each month (January = 1,
February = 2 etc.). Add this new column as a new attribute in your time
dimension. Add this new attribute as an "Attribute Relationship" to
your "Month" attribute. Set the "OrderBy" property of the "Month"
attribute to "AttributeKey" and set its value to your newly created
"MonthValue" attribute (The [1,2,3....12] attribute). This should sort
your month members in the correct order.
Also, if the "Month" attribute is part of a more general hierarchy, you
may want to add the "Year" column as a key column to your "Month"
attribute, so each month within a year will be unique.

HTH,
Yaniv