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?