[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 = 
            if (measure.getFormula().getExpression() instanceof MemberExpr)
                currentMembers[0] = 
        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.


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

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