#11 Totalizer member with filters - wrong value

closed
nobody
None
5
2007-01-31
2007-01-16
khandur
No

Hi.

I have a Mondrian dimension like:

<Dimension foreignKey="" name="Módulo">
<Hierarchy allMemberName="Módulo - TOTAL" hasAll="true" primaryKey="">
<Table name="GS_OLAP_REPORTS_20122006141545" />
<Level column="DS_MODULO" name="Módulo" uniqueMembers="true" />
</Hierarchy>
</Dimension>

And, using OLAP navigator, i create a filter onto this column, by selecting only two itens of "Módulo", and my MDX be like that:

{[Módulo].[Módulo - TOTAL], [Módulo].[Módulo - TOTAL].[GS/Sales], [Módulo].[Módulo - TOTAL].[GS/Tools]}

My problem is that when i create those filters, my allMember line, in this case "Módulo - TOTAL", does not add correctly. My totalizer line do add all all itens, not only itens that i filtered, and the value of this totalizer become wrong.

How can i solve this problem?

Thanks!

Discussion

  • Andreas Voss

    Andreas Voss - 2007-01-31
    • status: open --> closed
     
  • Andreas Voss

    Andreas Voss - 2007-01-31

    Logged In: YES
    user_id=36405
    Originator: NO

    This is the way MDX works. The TOTAL value is independet of what else you display. You did not create a filter, you selected two elements. This does not change the value of the TOTAL.

     

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks