Post reply

how to aggregation functions (sum, AVG) assign to a measure by different dimensions

  • July 20, 2009 at 6:25 pm

    #140014

    Urgent help needed:

    I have measure 'estimates', defined in the cube. This measure should be sum by organization dimension and

    AVG by time dimension Anybody has experienec how to implement this feature nkorobova@yahoo.com

    thank you much for your help

  • July 29, 2009 at 6:12 am

    #1031582

    You can use the default behavior for your measure on Organization and add a measure 'Estimated Order Count' which is a count on your fact table and a calculation for your time dimension:

    Create Member CurrentCube.[Measures].[Average Estimated]

    As [Measures].[Estimated amount]

    /

    [Measures].[Estimated Order Count],

    Format_String = "Currency",

    Associated_Measure_Group = 'Estimated' ;

    Yann Nguyen France
    MCITP: Business Intelligence Developer 2008

Viewing 2 posts - 1 through 1 (of 1 total)

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