I've developed a report: dimension in rows and one column. When I refresh a report there are all members of dimension in rows but I want to show only that members which have any data. How can I do this?
I tried to use parameters suppressnodata, suppressrows but it does not work correctly. By the way, dimension has a hierarchy.