Sort order for customer hierarchy dimensions

[paul_harrison2]

I am using custom hierarchies in a universe and have created several calendar hierarchies as follows:

Year

Quarter

Month Name

When drilling in WEBI the Month Name is sorted alphabetically. Is there a way to display month name, but sort by month number (as there is for LoVs)?

I would prefer to use month name in the hierarchy rather than month number as this is more informative to the user.

[paul_harrison2]

I am assuming that, as no-one has answered, that this is not possible.

[Former Member]

Hi,

WebIntelligence only provides alphabetical order (ascending or descending) and custom sort.

So for dates it is recommended to concatenate the month number and the month name to have an sort working.

Otherwise I recommend to do a custom sort in the document.

Didier