<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.6000.16414" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=093505618-07052007><FONT face=Verdana
color=#000080 size=2>That does indeed sound like a bug.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=093505618-07052007><FONT face=Verdana
color=#000080 size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=093505618-07052007><FONT face=Verdana
color=#000080 size=2>I think you mean that the result will contain
<fmtValue> iff the FORMATTED_VALUE member property is requested,
e.g.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=093505618-07052007><FONT face=Verdana
color=#000080 size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=093505618-07052007><FONT face=Verdana
color=#000080 size=2>SELECT {[Measures].[Unit Sales]} on
COLUMNS,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=093505618-07052007><FONT face=Verdana
color=#000080 size=2> {[Gender].[M]} on ROWS</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=093505618-07052007><FONT face=Verdana
color=#000080 size=2>FROM [SALES]</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=093505618-07052007><FONT face=Verdana
color=#000080 size=2>CELL PROPERTIES FORMATTED_VALUE</FONT></SPAN></DIV>
<DIV><FONT face=Verdana color=#000080 size=2></FONT> </DIV>
<DIV><SPAN class=093505618-07052007></SPAN><FONT face=Verdana><FONT
color=#000080><FONT size=2>T<SPAN class=093505618-07052007>oday, Mondrian parses
the 'CELL PROPERTIES property [, ...]' clause but ignores it. You will need
to change XmlaHandler to look for that particular
property.</SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face=Verdana><FONT color=#000080><FONT size=2><SPAN
class=093505618-07052007></SPAN></FONT></FONT></FONT> </DIV>
<DIV><FONT face=Verdana><FONT color=#000080><FONT size=2><SPAN
class=093505618-07052007>Please also add a testcase to XmlaBasicTest, and a
testcase to ParserTest to ensure that CELL PROPERTIES and PROPERTIES are parsed
correctly.</SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face=Verdana><FONT color=#000080><FONT size=2><SPAN
class=093505618-07052007></SPAN></FONT></FONT></FONT> </DIV>
<DIV><FONT face=Verdana><FONT color=#000080><FONT size=2><SPAN
class=093505618-07052007>I have logged bug <TD nowrap="nowrap"><FONT
color=#000000><FONT size=3><FONT face="Times New Roman">1714525
</TD><TD></FONT></FONT></FONT><A
href="http://sourceforge.net/tracker/index.php?func=detail&aid=1714525&group_id=35302&atid=414613"><!-- google_ad_section_start --><FONT
face="Times New Roman" size=3>Return <fmtValue> only if FORMATTED_VALUE
requested</FONT></A></TD>.</SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face=Verdana><FONT color=#000080><FONT size=2><SPAN
class=093505618-07052007></SPAN></FONT></FONT></FONT> </DIV><FONT
face=Verdana><FONT color=#000080><FONT size=2><SPAN class=093505618-07052007>
<DIV><FONT face=Verdana><FONT color=#000080><FONT size=2><SPAN
class=093505618-07052007>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.</SPAN></FONT></FONT></FONT></DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>Julian</SPAN></FONT></FONT></FONT></DIV>
<DIV><BR></DIV>
<BLOCKQUOTE
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000080 2px solid; MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> mondrian-bounces@pentaho.org
[mailto:mondrian-bounces@pentaho.org] <B>On Behalf Of </B>Shishir
Das<BR><B>Sent:</B> Monday, May 07, 2007 5:48 AM<BR><B>To:</B>
mondrian@pentaho.org<BR><B>Subject:</B> [Mondrian] Formatted Value always
present in XMLA Execute Response.<BR></FONT><BR></DIV>
<DIV></DIV><BR><FONT face=sans-serif size=2>Hi,</FONT> <BR><BR><FONT
face=sans-serif size=2>XMLA 1.1 specification, Section-CellInfo Standard
Elements states - "Whether or not <fmtValue> is returned for any
particular query depends on the query itself".</FONT> <BR><BR><FONT
face=sans-serif size=2>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.</FONT>
<BR><BR><FONT face=sans-serif size=2>We propose to fix this issue. Requesting
comments, suggestions.</FONT> <BR><BR><FONT face=sans-serif
size=2>Regards,</FONT> <BR><FONT face=sans-serif
size=2>Shishir</FONT></BLOCKQUOTE></BODY></HTML>