一些常用的MDX语句

最新推荐文章于 2025-02-10 00:41:03 发布

ChinaHuNannet

最新推荐文章于 2025-02-10 00:41:03 发布

阅读量1.3k

点赞数

分类专栏： BI 文章标签： string

本文链接：https://blog.youkuaiyun.com/ChinaHuNannet/article/details/5185886

版权

BI 专栏收录该内容

2 篇文章

订阅专栏

/* CALCULATE 命令控制该多维数据集中叶单元的聚合。如果删除或修改该 CALCULATE 命令，会影响该多维数据集内的数据。只有手动指定如何聚合该多维数据集时才编辑该命令。 */ CALCULATE; CREATE MEMBER CURRENTCUBE.[MEASURES].[价税合计_GL_平均] AS Avg( Descendants( [GL日期明细].[年-季度-月].CurrentMember, [GL日期明细].[年-季度-月].[月份] ), [Measures].[价税合计] ), FORMAT_STRING = "Currency", VISIBLE = 1; CREATE MEMBER CURRENTCUBE.[MEASURES].[价税合计_GL_环比百分比] AS (([GL日期明细].[年-季度-月].CurrentMember,[Measures].[价税合计])- ([GL日期明细].[年-季度-月].CurrentMember.PrevMember, [Measures].[价税合计]))/([GL日期明细].[年-季度-月].CurrentMember.PrevMember, [Measures].[价税合计]), FORMAT_STRING = "Percent", VISIBLE = 1 ; CREATE MEMBER CURRENTCUBE.[MEASURES].[价税合计_GL_同比百分比] AS ([Measures].[价税合计]-( [Measures].[价税合计],ParallelPeriod( [GL日期明细].[年-季度-月].[年份], 1, [GL日期明细].[年-季度-月].CurrentMember ) ))/([Measures].[价税合计],ParallelPeriod( [GL日期明细].[年-季度-月].[年份], 1, [GL日期明细].[年-季度-月].CurrentMember ) ), FORMAT_STRING = "Percent", VISIBLE = 1; CREATE MEMBER CURRENTCUBE.[MEASURES].[价税合计_GL_同期数值] AS ( [Measures].[价税合计],ParallelPeriod( [GL日期明细].[年-季度-月].[年份], 1, [GL日期明细].[年-季度-月].CurrentMember ) ), FORMAT_STRING = "Currency", VISIBLE = 1; CREATE MEMBER CURRENTCUBE.[MEASURES].[价税合计_GL_环比数值] AS ([GL日期明细].[年-季度-月].CurrentMember.PrevMember, [Measures].[价税合计]), FORMAT_STRING = "Currency", VISIBLE = 1; CREATE MEMBER CURRENTCUBE.[MEASURES].[价税合计_GL_同比增量] AS [Measures].[价税合计]-( [Measures].[价税合计],ParallelPeriod( [GL日期明细].[年-季度-月].[年份], 1, [GL日期明细].[年-季度-月].CurrentMember ) ), FORMAT_STRING = "Currency", VISIBLE = 1; CREATE MEMBER CURRENTCUBE.[MEASURES].[价税合计_GL_环比增量] AS ([GL日期明细].[年-季度-月].CurrentMember,[Measures].[价税合计])- ([GL日期明细].[年-季度-月].CurrentMember.PrevMember, [Measures].[价税合计]), VISIBLE = 1; CREATE MEMBER CURRENTCUBE.[MEASURES].[价税合计_GL_百分比] AS ([GL日期明细].[年-季度-月].CurrentMember,[Measures].[价税合计])/([GL日期明细].[年-季度-月].CurrentMember.parent,[Measures].[价税合计]), FORMAT_STRING = "Percent", VISIBLE = 1 ;