PDA

View Full Version : MDX query



bardeggia
10.11.2011, 15:06
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?!