[Mondrian] Seeking advice on sorting the catalog list

[Will Gorman]

Hi Rui,

Because Mantle transmits the list over to the browser as a HashMap, you
are stuck with either changing Mantle to pass an ordered list or to sort
the list on the client.

Will

On Tue, 2010-06-22 at 11:28 -0700, Julian Hyde wrote:
> If PUC were using olap4j to get its catalog list, this would be a
> question for the olap4j list. I'd be able to give you a 'clear up or
> down vote' about whether the driver complied with the olap4j spec. But
> sadly I don't think it is, and PUC is using its own ad hoc mechanism
> to get catalogs.
>  
> Will, can you ask one of the PUC team to answer this question.
>  
> Julian
> 
>         
>         ______________________________________________________________
>         From: mondrian-bounces at pentaho.org
>         [mailto:mondrian-bounces at pentaho.org] On Behalf Of Rui
>         Gonçalves
>         Sent: Tuesday, June 22, 2010 11:13 AM
>         To: Mondrian developer mailing list
>         Subject: [Mondrian] Seeking advice on sorting the catalog list
>         
>         
>         
>         
>         In PUC, the "New Analysis View" dialog schema list is not
>         sorted. When you have several schemas is quite difficult to
>         find the desired one.
>         I'm not familiarized with the mondrian source code neither
>         with mantle source code. 
>         Didn't seem to find any way of sorting the schema list through
>         configuration, is there any?
>         
>         Assuming there isn't, I need some code modification.
>         
>         There are some possibilities to do it, each one with specific
>         implications. Not knowing the API's, I would like some advice
>         on where to apply the modification.
>         The possibilities to sort the list that I have observed are:
>         1 - sort  catalogCubeHashMap in
>         org.pentaho.mantle.server.MantleServlet.getMondrianCatalogs
>         (doesn't seem a very good idea, but seems to be PUC only), or;
>         
>         2 - in
>         org.pentaho.platform.plugin.action.mondrian.catalog.MondrianCatalogHelper.transformIntoCatalogList, sort the variable localCatalogs on MondrianCatalog.name (seems better but don't really know the impact of doing it here), or;
>         
>         3 - is there a way to retrieve
>         org.pentaho.platform.plugin.action.mondrian.catalog.MondrianCatalogHelper.readDataSourcesContent in an ordered way (what?) or at least in the same order that the catalogs are in the datasource file, or;
>         
>         4 - ... and now for something completely different ...
>         
>         Any advice would be welcome.
>         Thank's
>         Rui Gonçalves