| Author |
 Topic  |
|
|
pablohrs
Uruguay
15 Posts |
 Posted - 11/06/2012 : 07:56:52
|
Dears,
The percentage computed column in OLAP Reports does not provide the filters that are added to the report, what is the solution?
Thanks!
Pablo H. Rodriguez Sosa |
|
|
admin
1637 Posts |
Posted - 11/06/2012 : 13:12:11
|
Which percentage type do you use?
Percent of Parent - the denominator is ancestor.
Percent of Max Child - the denominator is the largest sibling.
Percent of Dimension - the denominator is the highest level of the hierarchy.
Percent of Total - the denominator is all.
http://www.reportportal.com/help/olap/percentage.htm
Which number do you see and which number did you expect to see? |
 |
|
|
pablohrs
Uruguay
15 Posts |
Posted - 11/06/2012 : 13:37:58
|
Hello, Thanks for the reply,
I tried all the options, the option that is by Dimension and the option is for the Ancestor.
The initial result is correct, ie that the items represent the correct percentage is 100%.
But if I exclude through the filters (multi-select) one of the items, the percentage is not recalculated, but on the contrary, continue to represent the same value, which results in a huge confusion because no items added give 100% and yet continues to display the item ALL 100%.
In summary the calculation of the measure has no items selected.
Thanks and I look forward to your prompt reply
Pablo H. Rodriguez Sosa |
|
|
|
admin
1637 Posts |
Posted - 11/06/2012 : 19:58:58
|
The "Percent of Total" should work. To see an example, please go to demo server (http://www.reportportal.us) > My Reports > Problem with percentage column.
Please note that you might need to modify the calculated member not to use the Ancestor() MDX function (and use the unique member id instead) for the hierarchy that is used for the multi-select filter.
|
|
|
|
pablohrs
Uruguay
15 Posts |
Posted - 11/07/2012 : 06:05:12
|
Thanks and Regards
Pablo H. Rodriguez Sosa |
|
|
| |
Topic |
|
Report Portal
Problem with percentage column
