By: Jo Ann de Ruiter
You may, at some point, want to set up a report that you have built dimension specifications in the row to have a tree that will also filter by those same dimensions to get, say, a line of business report – or only dimensions that are specified in a row.
However, this cannot be done. If you have a row format that is segregated by dimension you cannot filter by those dimensions in a tree. For the report to work, you’ll need to rewrite your row format to exclude the dimensions in question and then build a tree with those dimensions.