Only a certain member and its children to be visible to a particular user

[former_member196865]

Hi gurus,

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.

Regards,

David

[Former Member]

Hi David,

why not hardcode the member into the report? Build an Excel drop-down based on a list and only give this to the user to select from.

BR,
Arnold

[former_member196865]

Hi Arnold,

Thanks for your reply. Told the user the limitations of it and they seem to be okay with it. Your idea is a novel one but the members have to be maintained separately and given the number of base level members and the possibility of new members being added to the system, we would have to write a Macro to dynamically update the list. I have done such a thing before but it does take time to refresh. The user was not keen on doing that so they seem to be okay with it.

Regards,

David