PDA

View Full Version : RE: [Mondrian] Formatted Value always present in XMLA ExecuteResponse.



Julian Hyde
05-07-2007, 03:31 PM
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
FROM [SALES]
CELL PROPERTIES FORMATTED_VALUE

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
correctly.

I have logged bug 1714525
<http://sourceforge.net/tracker/index.php?func=detail&aid=1714525&group_
id=35302&atid=414613> Return <fmtValue> only if FORMATTED_VALUE
requested.

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.


Julian


_____

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



Hi,

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.

Regards,
Shishir


_______________________________________________
Mondrian mailing list
Mondrian (AT) pentaho (DOT) org
http://lists.pentaho.org/mailman/listinfo/mondrian