累计金额（累进总计）

发布于 2024-12-19 05:30:31 字数 731 浏览 2 评论 0原文

我有一个具有维度 CreatedOn （时间类型）和度量 IssueOpened 的多维数据集。我需要获取 IssueOpened 的累计金额。

例如：

2009  IssueOpened=7   OpenedOnTheEndOfPeriod=7
2010  IssueOpened=12  OpenedOnTheEndOfPeriod=19
2011  IssueOpened=2   OpenedOnTheEndOfPeriod=21

所以，我创建了计算成员：

sum([CreatedOn].[Y-Q-M].currentmember.level.members(0):[CreatedOn].[Y-Q-M].currentmember.prevmember, Measures.[IssueOpened])

在此处输入图像描述

但它看起来不起作用我想。维度开始：

在此处输入图像描述

维度末尾看起来像是事实：

在此处输入图像描述

可能是时间维度的第一个成员上的错误？我需要修复什么才能获得所需的结果？

原文

I have a cube with the dimension CreatedOn (Time type) and the measure IssueOpened. I need to get the cumulative sum for IssueOpened.

For example:

2009  IssueOpened=7   OpenedOnTheEndOfPeriod=7
2010  IssueOpened=12  OpenedOnTheEndOfPeriod=19
2011  IssueOpened=2   OpenedOnTheEndOfPeriod=21

So, I have created the calculated member:

sum([CreatedOn].[Y-Q-M].currentmember.level.members(0):[CreatedOn].[Y-Q-M].currentmember.prevmember, Measures.[IssueOpened])

enter image description here

But it looks like it doesn't work as I want. Start of dimension:

enter image description here

And it looks like a truth at the end of dimension:

enter image description here

May be the error on the first member of Time dimension? What do I need to fix to get the desired result?

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

隐诗 2024-12-26 05:30:31

您是否看过

要计算运行总计，您应该使用如下成员：

set Q as Nonempty( Order( [CreatedOn].[Y-Q-M].Members,[Measures].[IssueOpened], ASC ) 
                         ,[Measures].[IssueOpened] )

Member [Measures].[RunningTotal] as Sum(
    Head( Q, ( [Measures].[Level], [CreatedOn].[Y-Q-M].CurrentMember ) )
   ,[Measures].[IssueOpened] )

Have you ever looked at http://www.ssas-info.com/analysis-services-articles/62-design/367-inventory-management-calculations-in-sql-server-analysis-services-2005-by-richard-tkachuk. This is a must read if you want to attemp anything like you are doing.

To calculate a running total, you should use a member like this one :

set Q as Nonempty( Order( [CreatedOn].[Y-Q-M].Members,[Measures].[IssueOpened], ASC ) 
                         ,[Measures].[IssueOpened] )

Member [Measures].[RunningTotal] as Sum(
    Head( Q, ( [Measures].[Level], [CreatedOn].[Y-Q-M].CurrentMember ) )
   ,[Measures].[IssueOpened] )

回复收藏 0 原文

~没有更多了~