Post reply

Measure in AllMember is greater then the Sum of all Members

  • July 14, 2016 at 2:34 am

    #151463

    Hi,

    I have a Measure called "LS Anzahl" which value in the ALLMEMBER is greater than the SUM of all Members in the AttributHierachy.

    Select [MEASURES].[LS Anzahl] on 0,[Rechnung].[Re Bezahlt].ALLMEMBERS on 1 From Rechnungen

    LS Anzahl

    Alle Rechnungen4865 --> AllMember

    bezahlt 312 --> Member

    nicht bezahlt2525 --> Member

    Unknown (NULL) --> Member

    2525+312 < 4865 ???

    I don't know the reason for this, thinking the ALLMEMBER is the sum of its Members?

  • July 14, 2016 at 4:10 am

    #1890029

    Is [MEASURES].[LS Anzahl] a calculated member? If so, please post the code.

  • July 14, 2016 at 4:18 am

    #1890032

    No, it is a Count of Rows from the Fact Table.

    The Dimension is join to the Measure by M2M, i don't know if there is an impact through the relation?

  • July 14, 2016 at 4:25 am

    #1890036

    Is this a multi-dimensional or Tabular cube?

  • July 14, 2016 at 4:30 am

    #1890039

    multidimensional

  • July 14, 2016 at 5:17 am

    #1890046

    I'd review your M2M relationship. Unfortunately, I'm not that familiar with M2M relationships in MD so I can't give any other recommendation.

  • July 14, 2016 at 5:21 am

    #1890049

    ok, thanks!

  • July 14, 2016 at 1:16 pm

    #1890192

    Definitely check the dimension usage and attribute relationships. Maybe your measure is counting rows from the wrong table?

Viewing 8 posts - 1 through 7 (of 7 total)

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