[Mondrian] Drill through icon is disabled - because of coalescefunction in mdx
Julian Hyde
jhyde at pentaho.com
Fri Jul 4 13:15:58 EDT 2008
The logic is in RolapCell:
/**
* Returns whether it is possible to drill through this cell.
* Drill-through is possible if the measure is a stored measure
* and not possible for calculated measures.
*
* @return true if can drill through
*/
public boolean canDrillThrough() {
// get current members
final Member[] currentMembers = getMembersForDrillThrough();
// First member is the measure, test if it is stored measure, return
// true if it is, false if not.
return (currentMembers[0] instanceof RolapStoredMeasure);
}
private Member[] getMembersForDrillThrough() {
final Member[] currentMembers = result.getCellMembers(pos);
// replace member if we're dealing with a trivial formula
if (currentMembers[0] instanceof
RolapHierarchy.RolapCalculatedMeasure) {
RolapHierarchy.RolapCalculatedMeasure measure =
(RolapHierarchy.RolapCalculatedMeasure)currentMembers[0];
if (measure.getFormula().getExpression() instanceof MemberExpr)
{
currentMembers[0] =
((MemberExpr)measure.getFormula().getExpression()).getMember();
}
}
return currentMembers;
}
We currently only allow drill through on stored measures or trivial calc
measures. 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.
SJ, or someone, please log an RFE for this. Contributions welcome.
Julian
_____
From: mondrian-bounces at pentaho.org [mailto:mondrian-bounces at pentaho.org] On
Behalf Of Jayachandran, Sivagnanamoorthy
Sent: Tuesday, July 01, 2008 9:28 AM
To: mondrian at pentaho.org
Subject: [Mondrian] Drill through icon is disabled - because of
coalescefunction in mdx
On clicking through "Drill through" icon in the mondrian tool bar in the
report page ,the drilldrown arrow icon is not enabled.
When i delete the calculated numbers the drilldrown arrow icons are enabled.
When i created two calculated members, the icon is enabled.
But when i use coalesce statement in MDX, the arrows icons are not enabled.
The enablement of the icon is apoint to be argued based on either large
number of calculated
Members or coalesce empty function.
Thanks & Regards,
Sivagnanamoorthy j.
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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20080704/57df9a01/attachment.html
More information about the Mondrian
mailing list