on 03-31-2016 3:28 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
12 | |
3 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.