Post reply

problem with aggregate

  • May 7, 2008 at 3:39 am

    #190022

    i have in a matrix a measures desviation (stdev)

    aggregate(desviation.value)

    but if have the matrix by rowgroups(program - subprogram - pn ) and column groups(year-quarter-month), without extending, the cells are empty :

    year

    2007 2008

    programa desviation desviation

    1

    2

    3

    if i extending the matrix to level last , the aggregate are ok :

    year

    - 2007

    - QUARTER

    JANUARY

    programa desviation

    - 1 - A PN1 2,1

    PN2 1,3

    - B PN65 3,4

    PN66 5,9

    + C

    +2

    +3

    my measures in ssas is :

    stdev( [view].[elementID].children, [measures].[days] )

    my view has the columns:

    elementID, program, subprogram, pn, date (yyyy/dd/dd),days

    my dimension time is internal of ssas.

    help!!

  • May 9, 2008 at 12:11 pm

    #813290

    A couple of points:

    First, you must make sure you've entered the values in the matrix on the group lines. Look for the cells with a green triangle on the top left and click on the triangle.

    Second, you need to make sure you have RS pull / use the value from the data source (MSAS). Natively, MSAS tries to aggregate (sum) the values, which in many cases isn't correct. For the field, use the value =Aggregate(desviation).

    When pulling data for a matrix, make sure all of the "dimension fields" are referenced on your matrix.

    MSRS treats the data in a "flat data source", so you have to go to some extra steps to make it properly reference MSAS data.

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

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