2 Replies Latest reply: Nov 19, 2012 5:06 AM by BIDev RSS

    Why the percent value is sum in Hierarchy when filter the Dimension column?

    BIDev
      Hi Experts,

      OBIEE Version:11.1.1.6.0
      ESSBASE Version: 11.1.1.2.0

      Why the percent value is sum in Hierarchy when filter the Dimension column?
      For example:
      The datasource is ESSBASE and imported into physical layer,and expland to flat, then drag to BMM and Presentation layer.In answer, when I drag the hierarchy column and one percent colunm into report, it will show correctly, but when I filter Dimension column,such as 'South','North', the value of percent column will sum. Why?

      Wrong result:
      China-----------43%
      ---North-------22%
      ---South-------21%


      Expect result:
      China-----------21%
      ---North-------22%
      ---South-------21%