Removing rows with columns zeroed (TOTAL = 0)

[henriqueberaldo]

Alex, hello. I need the pivotcube not show rows in which all columns are cleared. Depending on the filter that the user makes the cube in run time, a ranking of clients, when you sort in descending order of sales, customers who do not participate in the filter also appear, displaying rows with zero total unnecessarily.
Note: Instructions SQL (SELECT) performs the query and shows only the customers related to the filter, not returning zero values (= 0)
Thanks!

[AlexZencovich]

Probably you may set TPivotMap.HideEmptyRows/Columns to control if totally empty row/coolumn still visible after filtering