How to filter a dimension by a given range of cells

[Former Member]

Hi All,

Suppose that we have data in a range (eg. A3:A25) in worksheet and just want to filter a dimension with that range.

In this case, please tell me what exactly i should do.

I tried EPMDIMENSIONOVERRIDE so much, but can't succeed.

Thanks in Adv. for your supports

[former_member186338 · Accepted solution]

Hi Sadi,

If you read help about EPMDimensionOverride than you will see that the valid member list is a comma separated list. No ranges!!!!

If it's possible to concatenate values in you range to have a comma separated list (as in my proposal in the link provided by Neha) than it's fine.

Vadim

[Former Member]

Neha & Vadim,

Thanks a lot, it is completely fine for my work.

Sadi

[Former Member]

Hi Sadi,

I raised similar question some time back. You can find some helpful answers here

Regards,

Neha