แบบสอบถาม MDX คอลัมน์ผลรวม

อาจลองสิ่งนี้:

WITH 
  MEMBER [Articulo].[Art_Linea].[ Aggregation] AS 
    Aggregate({[Articulo].[Art_Linea].&[3M],[Articulo].[Art_Linea].&[Bendix]}) 
   ,SOLVE_ORDER = 0 
  MEMBER [Articulo].[LCD].[All].[3M+Bendix] AS //<<you might need to play around here - maybe this is correct name?: [Articulo].[LCD].[All].[Art_Linea].[3M+Bendix]
    Sum
    (
      {
        [Articulo].[LCD].[Art_Linea].&[3M]
       ,[Articulo].[LCD].[Art_Linea].&[Bendix]
      }
    ) 
SELECT 
    Hierarchize
    (
      {
        [Almacen].[Alm_Nombre].&[MATRIZ]
       ,[Almacen].[Alm_Nombre].&[TOLUCA]
      }
    )
  * 
    {
      [Measures].[Val]
     ,[Measures].[Disponible]
    } ON COLUMNS
 ,Hierarchize
  (
    {
      [Articulo].[LCD].[Art_Linea].&[3M]
     ,[Articulo].[LCD].[Art_Linea].&[Bendix]
     ,[Articulo].[LCD].[All].[3M+Bendix]  //<<you might need to play around here - maybe this is correct name?: [Articulo].[LCD].[All].[Art_Linea].[3M+Bendix]
    }
  ) ON ROWS
FROM [Inventario]
WHERE 
  [Articulo].[Art_Linea].[ Aggregation];

แม้ว่าฉันจะไม่แน่ใจเล็กน้อยเกี่ยวกับจุดประสงค์ของสมาชิก Aggregation - ดังนั้นอาจเป็นเพียงสิ่งต่อไปนี้

WITH 
  MEMBER [Articulo].[LCD].[All].[3M+Bendix] AS //<<you might need to play around here - maybe this is correct name?: [Articulo].[LCD].[All].[Art_Linea].[3M+Bendix]
    Sum
    (
      {
        [Articulo].[LCD].[Art_Linea].&[3M]
       ,[Articulo].[LCD].[Art_Linea].&[Bendix]
      }
    ) 
SELECT 
    Hierarchize
    (
      {
        [Almacen].[Alm_Nombre].&[MATRIZ]
       ,[Almacen].[Alm_Nombre].&[TOLUCA]
      }
    )
  * 
    {
      [Measures].[Val]
     ,[Measures].[Disponible]
    } ON COLUMNS
 ,Hierarchize
  (
    {
      [Articulo].[LCD].[Art_Linea].&[3M]
     ,[Articulo].[LCD].[Art_Linea].&[Bendix]
     ,[Articulo].[LCD].[All].[3M+Bendix]  //<<you might need to play around here - maybe this is correct name?: [Articulo].[LCD].[All].[Art_Linea].[3M+Bendix]
    }
  ) ON ROWS
FROM [Inventario];