[Mondrian] Seeking advice on sorting the catalog list
wgorman at pentaho.com
Tue Jun 22 14:48:52 EDT 2010
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.
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.
> From: mondrian-bounces at pentaho.org
> [mailto:mondrian-bounces at pentaho.org] On Behalf Of Rui
> 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
> (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.
> Rui Gonçalves
More information about the Mondrian