在MDX中计算一组度量的YTD？ [英] Calculate YTD over group of Measures in MDX?

问题描述

我的要求是：我需要根据用户的度量选择显示YTD  ，当用户根据该度量拖动任何度量时，应该计算YTD。

示例：

WITH MEMBER [Measures]。[Current YTD] AS

SUM（YTD（[Date]。[Calendar] .CurrentMember），[Measures]。[Internet Order Quantity]）  from
Cube

而不是 此措施  [Measures]。[Internet
订单数量]，当用户拖动另一个/任何小节时 基于该度量根据用户选择动态填充YTD值。

你能帮我解决这个问题吗？

在此先感谢

---

Siddanth

解决方案

嗨Siddanth，

你可以使用创建会员  stat ement to 定义整个会话中可用的计算成员，以便您可以拖动任何所需的计算度量。

 
创建成员多维数据集。[措施]。[当前互联网订单年初至今] AS 
 SUM（YTD（[日期]。[日历]。现在会员），[措施]。[互联网订单数量]）
 
创建MEMBER Cube。[Measures]。[Current others YTD] AS 
 SUM（YTD（[Date]。[Calendar] .CurrentMember），[Measures]。[其他措施名称]）
 
。 ... 
 

最好的问候，

将

My requirement is: I need to show YTD based on the measure selection by user  , when user drag any measure based on that measure YTD should be calulated.

Example:

WITH MEMBER [Measures].[Current YTD] AS
SUM(YTD([Date].[Calendar].CurrentMember), [Measures].[Internet Order Quantity]) from Cube

Instead of  this measure [Measures].[Internet Order Quantity] , When user drag another/any measure based on that measure dynamically populate the YTD values based on the user selection.

Can you help me out on this?

Thanks In Advance

---

Siddanth

解决方案

Hi Siddanth,

You could use CREATE MEMBER statement to define calculated members that are available throughout the session, so that you could drag any calculated measure that you want.

CREATE MEMBER Cube.[Measures].[Current Internet Order YTD] AS
SUM(YTD([Date].[Calendar].CurrentMember), [Measures].[Internet Order Quantity]) 

CREATE MEMBER Cube.[Measures].[Current others YTD] AS
SUM(YTD([Date].[Calendar].CurrentMember), [Measures].[other measures name]) 
....

Best Regards,

Will

这篇关于在MDX中计算一组度量的YTD？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！