[Mondrian] help

[subramanian arumugam]

Hi,

We have the requirement to filter the data in the dimension. Assume that 
following is the Dimension Hierarchy. Head Office (Level 1),Zonal Office 
(Level 2),Regional Office(Level 3),Branch (Level 4). In this case we would 
like to filter the data in the hierarchy as Zonal Office='West Zone' and Zonal 
Office='South Zone' and Regiona Office ='RO Chennai'.
We are using the Measure "No of Accounts"(Aggregated Type).
When we submit the following MDX query to Mondrain, Grand total and 
Intermediate total results are not proper.
WITH SET [0] AS ' { { [Branch.Branch].[Head Office].[Corporate Office] 
, [Branch.Branch].[Head Office].[Corporate Office].[South Zone] , 
[Branch.Branch].[Head Office].[Corporate Office].[South Zone].[RO, 
Chennai],[Branch.Branch].[Head Office].[Corporate Office].[South Zone].[RO, 
Chennai].children , [Branch.Branch].[Head Office].[Corporate Office].[West 
Zone],[Branch.Branch].[Head Office].[Corporate Office].[West Zone].children } 
} ' SET [HIDDEN_TOTAL_0] AS ' VISUALTOTALS ( [Branch_Branch_Head 
Office_1] ) ' SET [HIDDEN_TOTAL_1] AS ' VISUALTOTALS ( [0] ) ' SET 
[Branch_Branch_Head Office_1] AS ' { { [Branch.Branch] } , HIERARCHIZE ( 
INTERSECT ( [0] , AddCalculatedMembers ( [Branch.Branch].[Head 
Office].Members ) ) ) } ' SET [Branch_Branch_Zonal Office_2] AS ' { 
[Branch_Branch_Head Office_1] , HIERARCHIZE ( GENERATE ( INTERSECT ( [0] 
, AddCalculatedMembers ( [Branch.Branch].[Head Office].Members ) ) , 
INTERSECT ( [0] , AddCalculatedMembers ( DESCENDANTS ( 
[Branch.Branch].CURRENTMEMBER , [Branch.Branch].[Zonal Office] ) ) ) ) ) 
} ' SET [Branch_Branch_Regional Office_3] AS ' { [Branch_Branch_Zonal 
Office_2] , HIERARCHIZE ( GENERATE ( GENERATE ( INTERSECT ( [0] , 
AddCalculatedMembers ( [Branch.Branch].[Head Office].Members ) ) , 
INTERSECT ( [0] , AddCalculatedMembers ( DESCENDANTS ( 
[Branch.Branch].CURRENTMEMBER , [Branch.Branch].[Zonal Office] ) ) ) ) , 
INTERSECT ( [0] , AddCalculatedMembers ( DESCENDANTS ( 
[Branch.Branch].CURRENTMEMBER , [Branch.Branch].[Regional Office] ) ) ) ) 
) } ' SET [Branch_Branch_Branch Office_4] AS ' { [Branch_Branch_Regional 
Office_3] , HIERARCHIZE ( GENERATE ( GENERATE ( GENERATE ( INTERSECT 
( [0] , AddCalculatedMembers ( [Branch.Branch].[Head Office].Members ) ) , 
INTERSECT ( [0] , AddCalculatedMembers ( DESCENDANTS ( 
[Branch.Branch].CURRENTMEMBER , [Branch.Branch].[Zonal Office] ) ) ) ) , 
INTERSECT ( [0] , AddCalculatedMembers ( DESCENDANTS ( 
[Branch.Branch].CURRENTMEMBER , [Branch.Branch].[Regional Office] ) ) ) ) 
, DESCENDANTS ( [Branch.Branch].CURRENTMEMBER , [Branch.Branch].[Branch 
Office] ) ) ) } ' SELECT NON EMPTY [Branch_Branch_Branch Office_4] 
DIMENSION PROPERTIES PARENT_UNIQUE_NAME ON 0 , { [MEASURES].[No Of 
Accounts] } ON 1 FROM [Loan Account Analysis]
Can any one help us the resolve this issue? 

Regards
A.Subramanian


      
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20100104/f1da24e3/attachment.html