Skip to Content

Only a certain member and its children to be visible for selection

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Mar 31, 2016 at 02:55 PM

    Hi David,

    should the user select a certain member of a dimension and then the report would display this and its children in rows or columns?

    Then I would use the EPMContextMember formular with a filter.

    The filter can use any property of the dimension.

    Then simply hide that dimension from the context bar.

    BR,

    Arnold


    Add comment
    10|10000 characters needed characters exceeded

  • Mar 31, 2016 at 03:30 PM

    Hi Vadim & Arnold,

    Thanks for your reply.

    The problem is that I have only one property that is H1 with which I can filter, but that will leave the member out of selection and display only the children. I am wondering if there is a way to use multiple properties in the filter section to display both the member and its children.

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 31, 2016 at 02:53 PM

    Hi David,

    You can't do anything with context selection without data access profile.

    But you can use =EPMSelectMember( with some filter. Then user will double click this cell to select filtered member...

    Vadim

    Add comment
    10|10000 characters needed characters exceeded