Is there a possibility to sort Month Names in Date type dimention -
when I use QD.sort() - I get the following output -
Instead, as you all know that the correct order is
How do I accomplish this in OLAP4j - Any help ?????
If you are using Mondrian, set the ordinal property of the month level to the
ordinal of the month in the year (Jan=1, etc.), and the natural order of the
members of the month will be the correct one.
I understand that you are using the Query.java class as your base class for
your query and that by "QD" you means QueryDimension. I second Julian's
suggestion. The Query Model is not aware of the underlying meaning of string
literals (nor should it be). Your best solution is either to :
Whatever option you use, don't use QueryDimension.sort() and your members will
keep their natural order.
While reviewing the API, I nothced that the QueryAxis allows this kind of
custom sort operations while the QueryDimension object doesn't.
For example :
This method call would allow you to pass arguments to the sort method as :
Disregard the call to "Month" in this example though. I can't remember how to
do such operations in MDX at the moment, but the principle remains.
QueryDimension should have included such arbitrary sort manipulations.
I created a tracker item for that.
Thankyou Julian and Luc.
Yes, I am using Query.java and QD refers to QueryDimension. and we are using
Mondrian OLAP server.
In this case, I wolud prefer to go with Julians suggestion to have it modified
in my cube.xml and that will be of greate use if we can that in QD
I am really impressed with your quick response and am seriously considering
OLAP4j with FLEX frontend.
I have couple of other BLOCKERS which I vl post it here with clear
Sign up for the SourceForge newsletter:
You seem to have CSS turned off.
Please don't fill out this field.