Post reply

calculate the sum of measures - for a range ofperiod.

  • January 6, 2009 at 8:26 pm

    #195719

    hi,

    How to calculate the sum of measures.Qty for a range of period.

    for example i want to sum up all the quantities between two weeks.

    (say from weekid - 0825 to weekid - 0840)

    Thanks,

    Regards

    Viji

  • January 7, 2009 at 8:36 am

    #922588

    Should look something like this:

    sum([Dimension].[Hierarchy].[0825]:[Dimension].[Hierarchy].[0840],[Measures].[Qty])

  • January 7, 2009 at 7:55 pm

    #923051

    hi,

    i tried something like this

    select sum([Client Tbl Dim Calendar].[Day Week Id].&[0828]:[Client Tbl Dim Calendar].[Day Week Id].&[0824],[Measures].[Quantity Sold])

    from [DSVClientAdmin]

    i'm getting error :

    Executing the query ...

    Parser: The statement dialect could not be resolved due to ambiguity.

    Execution complete

    can you please help me in this?

    Thanks,

    Regards,

    Viji

  • January 8, 2009 at 5:55 am

    #923235

    I see that error when I have a dimension member that is present in two hierarchies. Try to fully qualify the member by putting in the [Dimension].[Hierarchy].[Member] ;

  • January 9, 2009 at 3:24 am

    #924007

    You need to put the measure on columns

    select sum([Client Tbl Dim Calendar].[Day Week Id].&[0828]:[Client Tbl Dim Calendar].[Day Week Id].&[0824],[Measures].[Quantity Sold]) ON COLUMNS

    from [DSVClientAdmin]

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply