ssas 2005 mdx总计 [英] ssas 2005 mdx get total

问题描述

我有这个MDX查询

    select 
    {
        [Measures].[Sold value]
        ,[Measures].[Units]
        ,[Measures].[Sales baskets]
        ,[Measures].[ATV]
        ,[Measures].[AUT] 
    } on columns

    , filter(
        nonempty(
            {[Branch].[Branch].&[5] *[Receipt No - Sales].[Receipt No].[Receipt No]}
        ),
        [Measures].[Sold value] >= 50
    ) on rows
    from Rmis
    where [Time].[Day].&[20131218]

哪个会产生以下结果:

如何获得上述结果集的所有这些度量的总和?总数应使用多维数据集中定义的聚合.

How can I get the total of these measures of the above result set? The total should use the aggregation defined in the cube.

推荐答案

with set [rows] as
    filter(
        nonempty(
            {[Branch].[Branch].&[5] *[Receipt No - Sales].[Receipt No].[Receipt No]}
        ),
        [Measures].[Sold value] >= 50
    )

    member [Receipt No - Sales].[Receipt No].[Total] as
    aggregate([rows])

select 
    {
        [Measures].[Sold value]
        ,[Measures].[Units]
        ,[Measures].[Sales baskets]
        ,[Measures].[ATV]
        ,[Measures].[AUT] 
    } on columns
    ,
    { ([Branch].[Branch].&[5], [Receipt No - Sales].[Receipt No].[Total]) }
    +
    [rows]
    on rows
    from Rmis
    where [Time].[Day].&[20131218]

这篇关于ssas 2005 mdx总计的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！