Only a certain member and its children to be visible for selection
I am working on a report which needs the user to see only a particular member and it children when making a selection. I wondering how we can make such a configuration on a report. I understand that we can do it with a data access profile but I would like to do it at the report itself rather than create a separate data access profile for this report alone. Further, it would not serve the purpose as the users who will be using this report have credentials that can access pretty much everything in the model.