SELECT 
  [ut_Dim1].[dCode], 
  Count(*) As FactCount, 
  SUM([Value1]) As SumVal1, 
  SUM([Value2]) As SumVal2, 
  SUM([Value3]) As SumVal3 
FROM [ut_Fact] INNER JOIN [ut_Dim1] 
        ON [ut_Fact].[idDim1] = [ut_Dim1].[idDim1] 
GROUP BY [ut_Dim1].[dCode]

SELECT 
  { [Measures].[FactCount], [Measures].[SumVal1], [Measures].[SumVal2], [Measures].[SumVal3] } ON COLUMNS,
  { [dCode].[AlldCode], DESCENDANTS( [dCode].[AlldCode], [dCode].[(All)], AFTER ) } ON ROWS
FROM [aCUBE]