[Mondrian] Help - Visual Total Implementation

[Subramani(Adyar)]

                [X]
        Internal        Page 1 of 1
Hi,

Issue Description:

In the following Dimension Hierarchy,we would like to filter the data for Zonal Office='West Zone' and Zonal
Office='South Zone' and Regiona Office ='RO Chennai'.

Dimension Hierarchy:

Head Office

        Zonal Office

                Regional Office

                                Branch

In this case Grand total and Internediate totals are not reflecting the aggregation of filtered member data.
It is displaying Grand and intermediate totals as aggregation of all member data under that level.

Corporate Office                90 (It should be 80)

        West Zone               60

                B1              10
                B2              20
                B3              30

        South Zone              30 (It should be 20)

                RO Chennai      20
                ----------      X  (Filtered Data.)



We have applied VisualTotal function to correct this in MDX Query.
But following exception are displaying while executing the MDX Query.

1.The Mondrian XML: java.lang.UnsupportedOperationException

2.The Mondrian XML: mondrian.olap.fun.VisualTotalsFunDef$VisualTotalMember

Sample data


    Branch Hierarchy is selected in dimension member



                        [Branch Hierarchy.Branch Hierarchy].[Head Office].[Corporate Office] ,

                        [Branch Hierarchy.Branch Hierarchy].[Head Office].[Corporate Office].[North Zone] ,

                        [Branch Hierarchy.Branch Hierarchy].[Head Office].[Corporate Office].[South Zone],

                        [Branch Hierarchy.Branch Hierarchy].[Head Office].[Corporate Office].[North Zone].[RO, New Delhi],

                        [Branch Hierarchy.Branch Hierarchy].[Head Office].[Corporate Office].[North Zone].[RO, Old Delhi],

                        [Branch Hierarchy.Branch Hierarchy].[Head Office].[Corporate Office].[South Zone].[RO, Chennai],

                        [Branch Hierarchy.Branch Hierarchy].[Head Office].[Corporate Office].[South Zone].[RO, Coimbatore],

                        [Branch Hierarchy.Branch Hierarchy].[Head Office].[Corporate Office].[South Zone].[RO, Hyderabad],

                        [Branch Hierarchy.Branch Hierarchy].[Head Office].[Corporate Office].[West Zone]


MDX query


WITH

SET  [1] AS  '  {



                        VisualTotals

                        (

                                    {

                                                [Branch Hierarchy.Branch Hierarchy].[Head Office].[Corporate Office] ,

                                                [Branch Hierarchy.Branch Hierarchy].[Head Office].[Corporate Office].[North Zone] ,

                                                [Branch Hierarchy.Branch Hierarchy].[Head Office].[Corporate Office].[South Zone],

                                                [Branch Hierarchy.Branch Hierarchy].[Head Office].[Corporate Office].[North Zone].[RO, New Delhi],

                                                [Branch Hierarchy.Branch Hierarchy].[Head Office].[Corporate Office].[North Zone].[RO, Old Delhi],

                                                [Branch Hierarchy.Branch Hierarchy].[Head Office].[Corporate Office].[South Zone].[RO, Chennai],

                                                [Branch Hierarchy.Branch Hierarchy].[Head Office].[Corporate Office].[South Zone].[RO, Coimbatore],

                                                [Branch Hierarchy.Branch Hierarchy].[Head Office].[Corporate Office].[South Zone].[RO, Hyderabad],

                                                [Branch Hierarchy.Branch Hierarchy].[Head Office].[Corporate Office].[West Zone]

                                    }

                        )





                         }  '



SET  [2] AS  '  {  { [Branch Hierarchy.Branch Hierarchy] }  ,

HIERARCHIZE  (  INTERSECT  ( [1] ,  AddCalculatedMembers  ( [Branch Hierarchy.Branch Hierarchy].[Head Office].Members )  )  )  }  '


SET  [3] AS  '  { [2] ,

HIERARCHIZE  (      INTERSECT  ( [1] ,  AddCalculatedMembers  ( [Branch Hierarchy.Branch Hierarchy].[Zonal Office].Members )  )

) }'


SELECT   HIERARCHIZE  ( [3] )   ON 0, { [MEASURES].[Sanc Amt] , [MEASURES].[Count of Accounts]}

ON 1 FROM  [Loan Account Analysis]

Can any one help us to resolve the issue?


Regards
A.Subramanian




DISCLAIMER: 

Information transmitted by this e-mail may be proprietary to Ramco Systems Ltd., and / or the
authors of the information and is intended for use only by the individual or entity to which it is
addressed, and may contain confidential or legally privileged information. If you are not the 
intended recipient or it appears that this mail has been forwarded to you without proper authority, 
you are not authorised to access, read, disclose, copy, use or otherwise deal with it and any such 
actions are prohibited and may be unlawful. 

Internet communications cannot be guaranteed to be secure or error-free as information could be 
intercepted, corrupted, lost, arrive late or contain viruses. Ramco Systems Limited therefore does 
not accept liability for any errors, omissions, viruses or computer problems experienced as a 
result of this transmission.

If you have received this e-mail in error, please notify us immediately at 
mail to: mailadmin at rsi.ramco.com and delete this mail from your records. Notice is hereby 
given that no representation, contract or other binding obligation shall be created by this e-mail.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20100109/5b44b683/attachment.html