Announcement

Collapse
No announcement yet.

MDX query

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • MDX query

    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?!
Working...
X