<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns="http://www.w3.org/TR/REC-html40" xmlns:o =
"urn:schemas-microsoft-com:office:office" xmlns:w =
"urn:schemas-microsoft-com:office:word"><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.6001.18063" name=GENERATOR>
<STYLE>
<!--
/* Font Definitions */
@font-face
        {font-family:Garamond;
        panose-1:2 2 4 4 3 3 1 1 8 3;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
        {margin:0in;
        margin-bottom:.0001pt;
        font-size:12.0pt;
        font-family:"Times New Roman";}
a:link, span.MsoHyperlink
        {color:blue;
        text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
        {color:purple;
        text-decoration:underline;}
span.EmailStyle17
        {mso-style-type:personal-compose;
        font-family:Arial;
        color:windowtext;}
@page Section1
        {size:8.5in 11.0in;
        margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
        {page:Section1;}
-->
</STYLE>
</HEAD>
<BODY lang=EN-US vLink=purple link=blue>
<DIV dir=ltr align=left><SPAN class=677521217-04072008><FONT face=Verdana
color=#000080 size=2>The logic is in RolapCell:</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=677521217-04072008><FONT face=Verdana
color=#000080 size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=677521217-04072008><FONT face=Verdana
color=#000080 size=2> /**<BR> *
Returns whether it is possible to drill through this
cell.<BR> * Drill-through is possible if the measure is
a stored measure<BR> * and not possible for calculated
measures.<BR> *<BR> * @return
true if can drill through<BR> */<BR>
public boolean canDrillThrough() {<BR>
// get current members<BR> final
Member[] currentMembers =
getMembersForDrillThrough();<BR> //
First member is the measure, test if it is stored measure,
return<BR> // true if it is, false if
not.<BR> return (currentMembers[0]
instanceof RolapStoredMeasure);<BR> }<BR></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=677521217-04072008><FONT face=Verdana
color=#000080 size=2> private Member[]
getMembersForDrillThrough() {<BR>
final Member[] currentMembers = result.getCellMembers(pos);</FONT></SPAN></DIV>
<DIV><FONT face=Verdana color=#000080 size=2></FONT> </DIV>
<DIV dir=ltr align=left><SPAN class=677521217-04072008><FONT face=Verdana
color=#000080 size=2> // replace
member if we're dealing with a trivial
formula<BR> if (currentMembers[0]
instanceof RolapHierarchy.RolapCalculatedMeasure)
{<BR>
RolapHierarchy.RolapCalculatedMeasure measure =
<BR>
(RolapHierarchy.RolapCalculatedMeasure)currentMembers[0];<BR>
if (measure.getFormula().getExpression() instanceof MemberExpr)
{<BR>
currentMembers[0] =
<BR>
((MemberExpr)measure.getFormula().getExpression()).getMember();<BR>
}<BR>
}<BR> return
currentMembers;<BR> }<BR></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=677521217-04072008><FONT face=Verdana
color=#000080 size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=677521217-04072008><FONT face=Verdana
color=#000080 size=2>We currently only allow drill through on stored measures or
trivial calc measures. </FONT></SPAN><SPAN class=677521217-04072008><FONT
face=Verdana color=#000080 size=2>We could enhance this to handle certain other
expressions. For example, [Measures].[X] + [Measures].[Y] should be drillable if
X and Y come from the same fact table.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=677521217-04072008><FONT face=Verdana
color=#000080 size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=677521217-04072008><FONT face=Verdana
color=#000080 size=2>SJ, or someone, please log an RFE for this. Contributions
welcome.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=677521217-04072008><FONT face=Verdana
color=#000080 size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=677521217-04072008><FONT face=Verdana
color=#000080 size=2>Julian</DIV></FONT></SPAN>
<DIV dir=ltr align=left><SPAN class=677521217-04072008><FONT face=Verdana
color=#000080 size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=677521217-04072008><FONT face=Verdana
color=#000080 size=2></FONT></SPAN> </DIV><FONT face=Verdana color=#000080
size=2></FONT><FONT face=Verdana color=#000080 size=2></FONT><FONT face=Verdana
color=#000080 size=2></FONT><FONT face=Verdana color=#000080 size=2></FONT><BR>
<BLOCKQUOTE dir=ltr
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>Jayachandran,
Sivagnanamoorthy<BR><B>Sent:</B> Tuesday, July 01, 2008 9:28 AM<BR><B>To:</B>
mondrian@pentaho.org<BR><B>Subject:</B> [Mondrian] Drill through icon is
disabled - because of coalescefunction in mdx<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV class=Section1>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">On clicking through "Drill
through" icon in the mondrian tool bar in the report page ,the
drilldrown arrow icon is not enabled.<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">When i delete the calculated
numbers the drilldrown arrow icons are enabled.<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">When i created two calculated
members, the icon is enabled.<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">But when i use coalesce statement
in MDX, the arrows icons are not enabled.<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">The enablement of the icon is
apoint to be argued based on either large number of
calculated<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Members or coalesce empty
function.<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><B><FONT face=Garamond color=gray size=3><SPAN
style="FONT-WEIGHT: bold; FONT-SIZE: 12pt; COLOR: gray; FONT-FAMILY: Garamond">Thanks
& Regards,<o:p></o:p></SPAN></FONT></B></P>
<P class=MsoNormal><B><FONT face=Garamond size=3><SPAN
style="FONT-WEIGHT: bold; FONT-SIZE: 12pt; FONT-FAMILY: Garamond">Sivagnanamoorthy
j.<o:p></o:p></SPAN></FONT></B></P>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"><o:p> </o:p></SPAN></FONT></P></DIV><PRE>
This message contains information that may be privileged or confidential and is the property of the Capgemini Group. It is
intended only for the person to whom it is addressed. If you are not the intended recipient, you are not authorized to
read, print, retain, copy, disseminate, distribute, or use this message or any part thereof. If you receive this message
in error, please notify the sender immediately and delete all copies of this message.
</PRE></BLOCKQUOTE></BODY></HTML>