[Mondrian] Formatted Value always present in XMLA Execute Response.

Julian Hyde julianhyde at speakeasy.net
Mon May 7 15:22:15 EDT 2007

That does indeed sound like a bug.
I think you mean that the result will contain <fmtValue> iff the
FORMATTED_VALUE member property is requested, e.g.
SELECT {[Measures].[Unit Sales]} on COLUMNS,
 {[Gender].[M]} on ROWS
Today, Mondrian parses the 'CELL PROPERTIES property [, ...]' clause but
ignores it. You will need to change XmlaHandler to look for that
particular property.
Please also add a testcase to XmlaBasicTest, and a testcase to
ParserTest to ensure that CELL PROPERTIES and PROPERTIES are parsed
I have logged bug 1714525
id=35302&atid=414613> Return <fmtValue> only if FORMATTED_VALUE
If Cognos/Simba are generating very idiosyncratic MDX, also consider
adding a new suite XmlaCognosSimba containing some of the queries it
generates. LucidEra did this with their clearview tests, and it is an
effective early-warning system for changes to mondrian which would break
their app.


From: mondrian-bounces at pentaho.org [mailto:mondrian-bounces at pentaho.org]
On Behalf Of Shishir Das
Sent: Monday, May 07, 2007 5:48 AM
To: mondrian at pentaho.org
Subject: [Mondrian] Formatted Value always present in XMLA Execute


XMLA 1.1 specification, Section-CellInfo Standard Elements states -
"Whether or not <fmtValue> is returned for any particular query depends
on the query itself". 

AS2005 returns <fmtValue> property for the result cells only if the mdx
query itself has "FORMATTED_VALUE" parameter specified. Mondrian always
returns the fmtValue. For us, this is causing output formatting problem
while using Cognos 8.2, Simba and Mondrian together. 

We propose to fix this issue. Requesting comments, suggestions. 


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20070507/d35227b7/attachment.html 

More information about the Mondrian mailing list