SQL Server Performance

Duplicate values for Dimensions when looking at Cube in Browser

Discussion in 'SQL Server 2008 Analysis Services' started by cusp, Sep 2, 2011.

  1. cusp New Member

    I am a newbie to BI and SSAS
    I have Names(dimensions) and their related values (measures)
    When I display them in Cube , I get following values:

    Name value
    cusp 456
    cusp 4578
    cusp 23
    dim 34
    dim
    dim 321

    I dont know how to solve this and get only one value for each name
    cusp, Sep 2, 2011
    #1

  2. cusp New Member

    I have some clue do I need to use MDX to sum these values?
    cusp, Sep 2, 2011
    #2

Share This Page