MDX PeriodsToDate函数 [英] MDX PeriodsToDate Function

问题描述

我无法获得periodToDate在MDX中工作.将期间设置为年级时，我正在获取总和值，但是无法获得季度，月度和天级的总和.

I am unable to get periodsToDate to work in MDX. I am getting the sum value when i am setting the periods to year level, but i am unable to get the sum values for quarters, months and days level.

With MEMBER [Measures].[Cumul Claim Cost] AS
'Sum
(
PERIODSTODATE
(
[Valuation Date].[Year].[All].Level,
[Valuation Date].[Year].CurrentMember
)
,[Measures].[Cost]
)'

select 
    {[Measures].[Cumul Claim Cost], [Measures].[Cost]} on columns,
    {[Valuation Date].[Date].Members} on rows
    from [WVWC DATA CUBE FROI SROI]

这是我对天数级别的查询，无法正常工作.

And this is my query for days level which is not working.

With MEMBER [Measures].[Cumul Claim Cost] AS
'Sum
(
PERIODSTODATE
(
[Valuation Date].[Year].[All].Level,
[Valuation Date].[Year].[Month-Year].[Quarter- Year].[Date].CurrentMember
)
,[Measures].[Cost]
)'
select 
    {[Measures].[Cumul Claim Cost], [Measures].[Cost]} on columns,
    {[Valuation Date].[Date].Members} on rows
    from [WVWC DATA CUBE FROI SROI]

请帮助. 谢谢.

推荐答案

Nevermin伙计们，经过大量的尝试和试验，我能够获得正确的查询.

Nevermin guys, I was able to get the correct query after tons of hit and trials.

，带有成员[度量].[累计索赔成本] AS'Sum(PERIODSTODATE( [评估日期].[全部].级别，

with MEMBER [Measures].[Cumul Claim Cost] AS 'Sum ( PERIODSTODATE ( [Valuation Date].[All].level,

[评估日期] .CurrentMember)，[度量].[成本])'

[Valuation Date].CurrentMember ) ,[Measures].[Cost] )'

在上选择{[度量].[累积索赔成本]，[度量].[成本]} 列，非空{[Valuation Date].[QuarterYear]}，来自以下行 [WVWC DATA CUBE FROI SROI]

select {[Measures].[Cumul Claim Cost], [Measures].[Cost]} on columns, NON EMPTY {[Valuation Date].[Quarter- Year]} on rows from [WVWC DATA CUBE FROI SROI]

这篇关于MDX PeriodsToDate函数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！