SQL Power Software Forum

When I get back results from an MDX query using the following Measure definition

<Measure name="UNITS_ORDERED" column="QUANTITY" aggregator="sum"
datatype="Numeric" formatString="# ##0,###"/>
.. I get two results per cell, the unformatted and formatted values like so .

1000 1,000

Tom

This message was edited 1 time. Last update was at 2009-09-14 10:29:25

Hi Tom,

It looks as if your format string is being interpreted as two space-separated format strings: # and ###,###.

I'm guessing your format string is meant to cause the number 123456789.12345 to come out as 123 456 789,123 but you'll actually see 123456789 123,456,789.

Wabit actually relies on the olap4j driver to perform the formatting of values in OLAP result sets. Perhaps this is a bug in the Mondrian olap4j driver, or in Mondrian itself.

One workaround I could suggest would be to use a character other than space in your format string. Non-breaking space (Unicode 00A0) seems a good candidate: formatString="# ##0,###" [edit: escaped the ampersand--apparently JForum doesn't escape XML entity references]

You may also want to file a bug or ask about this on the Mondrian-users mailing list. Be warned, however, I have never received a reply to any question, bug report, or patch I have submitted to Pentaho as a "community" member. I've only been able to solicit responses from them within the context of being a business partner.

-Jonathan

Hi Jonathan,

Thanks for quick reply. That's the problem, my bad, for copying an existing simple "working" example to test out Wabit's OLAP functionality, should have written it from scratch

My experience of the Pentaho Forum was very positive, mind you, that was a few years back and mainly on Matt Caster's Kettle side, so things may have changed.

Like what I see of Wabit so far. Keep up the good work.

Tom

Ok, glad to hear you got it working.

My experiences with community failure were with JFreeReport, the overall Pentaho reporting platform, and the Mondrian users forum. I haven't used Kettle enough to patch bugs or require community support, but I'm glad to hear that the Kettle community (and Matt) is responsive.

About Mondrian, although we get the silent treatment when asking direct Mondrian questions on the Mondrian forums, I can vouch for Julian Hyde as being very conscientious and helpful when left to his own devices: he's always willing to help on they users and developers list of his olap4j project at sourceforge. But that project is not Pentaho-sponsored.

Thanks for your interest in Wabit! Please let us know if you run into any more bugs or misfeatures.

-Jonathan