none
MDX Grand Total RRS feed

  • Question

  • Hello,

    I am new to MDX and have been having some issues creating a Grand Total row in an analytic grid. I have spent several hours reading through other posts and still can not get it to work properly. The grid populates based on fiscal periods that are selected from a drop down. There is one other data point that I do not want to include in the grand total. As such, just adding in [Account].[Account] in the rows returns an inaccurate total. Any direction towards getting this to work would be greatly appreciated. My original code is as follows:

     

    WITH

    MEMBER [Date].[Fiscal].[ Aggregation] AS 'AGGREGATE( { [Last 12 Periods] } )', SOLVE_ORDER = 0

     

    SELECT

    DISTINCT( HIERARCHIZE( { [DepartmentFIN].[Dept Node].&[ALLDEPTS], [DepartmentFIN].[Dept Node].&[ALLDEPTS].CHILDREN } ) ) * { [Measures].[Actual -1], [Measures].[Budget -1], [Measures].[Variance], [Measures].[Variance %] }

    ON COLUMNS,

     

    HIERARCHIZE( { [Account].[Account].&[EXPENSES], [Account].[Account].&[NON OPER GAIN LOSS], [Account].[Account].&[REVENUES] } )

    ON ROWS

     

    FROM [Financial]

     

    WHERE ( [Date].[Fiscal].[ Aggregation] )

     

    Monday, June 27, 2011 9:01 PM