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

[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 · Accepted solution]

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

[former_member196865]

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.

[Former Member]

Hi David,

you could create a new property just for this purpose. But yes, you can combine several properties. I belive the syntax would be "ACCTYPE=AST;PROPERTY=VALUE".

BR,

Arnold

[former_member186338]

Unfortunately in  this formula you can combine properties only using ";" - AND! Not OR!

Looks like new property is the only solution but it's not elegant!

[former_member196865]

Thanks Vadim & Arnold.

Spoke to the user and they are not keen on creating a new property so I believe I have to show them all the members.

Interesting to see that logical And! is available but not the logical OR!.

Again thanks for your input.

[former_member186338]

Strange, that in EPMDimensionOverride you can use both "," and ";" But not brackets to create flexible filter condition!

[former_member186338]

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