This discussion is archived
2 Replies Latest reply: Nov 19, 2012 3:06 AM by BIDev RSS

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

BIDev Newbie
Currently Being Moderated
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%

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points