问SSAS多维数据集内存使用10维MDX查询爆炸

EN

with member measures.CatKey
    as
    [Question Answer Primary].[Q-A].currentmember.properties('key')
select {
        measures.CatKey,
        [Measures].[AverageValue],
        KPIValue('KPI Question Average Delta Wave Over Wave'),
        KPITrend('KPI Question Average Delta Wave Over Wave'),
        [Measures].[TopBoxPercent],
        KPIValue('KPI Top Box Delta Wave Over Wave'),
        KPITrend('KPI Top Box Delta Wave Over Wave'),
        [Measures].[MiddleBoxPercent],
        KPIValue('KPI Middle Box Delta Wave Over Wave'),
        KPITrend('KPI Middle Box Delta Wave Over Wave'),
        [Measures].[BottomBoxPercent],
        KPIValue('KPI Bottom Box Delta Wave Over Wave'),
        KPITrend('KPI Bottom Box Delta Wave Over Wave'),
        [Measures].[Primary Response Count]
    } on columns,

    [Question Answer Primary].[Q-A].[QUESTIONCATEGORY] * [Question Answer Primary].[QUESTIONKEY].[QUESTIONKEY]
    DIMENSION PROPERTIES MEMBER_VALUE on rows

from [SATPlus_Cube]

where CrossJoin({[Response Wave].[Wave].&[20110101]}, 
{
    [Question Answer Primary].[QUESTIONCATEGORY].&[AfricaSpecific], 
    [Question Answer Primary].[QUESTIONCATEGORY].&[ChinaSpecific], 
    [Question Answer Primary].[QUESTIONCATEGORY].&[Training], 
    [Question Answer Primary].[QUESTIONCATEGORY].&[SalesSupport], 
    [Question Answer Primary].[QUESTIONCATEGORY].&[Relationship], 
    [Question Answer Primary].[QUESTIONCATEGORY].&[ProductsAndPartsQuality], 
    [Question Answer Primary].[QUESTIONCATEGORY].&[ProductSupport], 
    [Question Answer Primary].[QUESTIONCATEGORY].&[PricingAndDiscounts],
    [Question Answer Primary].[QUESTIONCATEGORY].&[Overall],
    [Question Answer Primary].[QUESTIONCATEGORY].&[KeyMetrics],
    [Question Answer Primary].[QUESTIONCATEGORY].&[ITSystemsSupport],
    [Question Answer Primary].[QUESTIONCATEGORY].&[GovernmentNationalSales],
    [Question Answer Primary].[QUESTIONCATEGORY].&[FinancingAndCredit],
    [Question Answer Primary].[QUESTIONCATEGORY].&[FieldSupport], 
    [Question Answer Primary].[QUESTIONCATEGORY].&[DistributionSupport], 
    [Question Answer Primary].[QUESTIONCATEGORY].&[AdvertisingSupport]
}, 
NonEmpty (
        {[Sample].[SAMPLE KEY].[SAMPLE KEY]},
        ( 
            {[Hierarchy].[Node Value].&[1]}
            , [Measures].[Primary Response Count]
        )
    ))