文件名称：数值函数-数据挖掘_多维表达式（MDX）讲解
文件大小：379KB
文件格式：PPT
更新时间：2024-05-15 15:56:47
MDX
(5)数值函数 如下面的 MDX 查询示例所示，当 Aggregate 函数与产生总和的度量值相组合时，功能尤其强大： WITH MEMBER [Time].[1st Half Sales] AS 'Aggregate({Time.[Q1], Time.[Q2]})' MEMBER [Time].[2nd Half Sales] AS 'Aggregate({Time.[Q3], Time.[Q4]})', MEMBER [Time].[Difference] AS 'Time.[2nd Half Sales] - Time.[1st Half Sales]', SELECT { [Store].[Store State].Members} ON COLUMNS, { Time.[1st Half Sales], Time.[2nd Half Sales], Time.Difference} ON ROWS FROM Sales WHERE [Measures].[Store Sales] 查询产生了各州的店面销售额总和，带有前两个计算成员用 Aggregate 函数所提供的上半年和下半年的聚合，以及由第三个计算成员提供的二者的差额。 生成 MDX 中的计算成员 5.3 5 高级MDX