I have a problem with MDX, this formula dont works correctly.
select
{[Measures].[Amount],[Measures].[Amount Prev.]}
on columns
from
[SalesCube]
WHERE
([Time].[Year-Month-Date].[Date].&[2011-11-03T00:00:00]:
[Time].[Year-Month-Date].[Date].&[2011-11-04T00:00:00])
[Measures].[Amount Prev.] is a calculated members and it's--> #error.
It's not a problem with data because, if i try with a single day separately data are ok.
It's the same if i try with a calculation just in time:
With member [Measures].AmountPrev as
([Measures].[Amount],
ParallelPeriod
([Time].[Year-Month-Date].[Year],1,
[Time].[Year-Month-Date].CurrentMember))
select [Measures].AmountPrev on columns
from [SalesCube]
WHERE
([Time].[Year-Month-Date].[Date].&[2011-11-03T00:00:00]:
[Time].[Year-Month-Date].[Date].&[2011-11-04T00:00:00])
The formula dont works with two or more days but it's correct if there is only one day.
Someone can help me?!
select
{[Measures].[Amount],[Measures].[Amount Prev.]}
on columns
from
[SalesCube]
WHERE
([Time].[Year-Month-Date].[Date].&[2011-11-03T00:00:00]:
[Time].[Year-Month-Date].[Date].&[2011-11-04T00:00:00])
[Measures].[Amount Prev.] is a calculated members and it's--> #error.
It's not a problem with data because, if i try with a single day separately data are ok.
It's the same if i try with a calculation just in time:
With member [Measures].AmountPrev as
([Measures].[Amount],
ParallelPeriod
([Time].[Year-Month-Date].[Year],1,
[Time].[Year-Month-Date].CurrentMember))
select [Measures].AmountPrev on columns
from [SalesCube]
WHERE
([Time].[Year-Month-Date].[Date].&[2011-11-03T00:00:00]:
[Time].[Year-Month-Date].[Date].&[2011-11-04T00:00:00])
The formula dont works with two or more days but it's correct if there is only one day.
Someone can help me?!