Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Dimension Property Value 'Contains' instead of 'Is equal to'

Hi guys,

I was wondering if it is possible to reference a dimensional property value in the sense of 'contains' instead of 'is equal to'.

In other words: We all know it from Excel: Here it is possble to define a column filter based on 'contains'.

(BTW, in the WORKSTATUS context of the ENTITY dimension / OWNER property, it is possible, however only there as it seems.)

Anyway, I'd like to generically achieve the same in EPM templates (without having to apply the Excel filtering).

A potential way could be to apply a dynamic filter in the member selector, however, the only valid entries are =, <>, Like, and Between. (And applying multiple dynamic filters (using '+' Operators) , covering all possible entries of the desired property value should not be the preferred option at this stage.)

Another way I could imagine to be working out ist the EPMDimensionOverride formula, however, I can't work out out the potential syntax.

So please, if anyone got an idea...


Last but not least a simples example:

Say, the Dimension 'TEST' has got the property 'FILTER'

And it's dimensional members are as follows:

KEY               FILTER

TEST_1          A

TEST_2          B

TEST_3          A,B

TEST_4          B,C


Filtering a template based on 'contains' A should display the members TEST_1, TEST_3

Filtering a template based on 'contains' B should display the members TEST_2, TEST_3, TEST_4

Filtering a template based on 'contains' C should display the member TEST_4


Thanks guys, your help is appreciated!



P.S. About like: according to help you can use wildcards * to check for some part of the string, but I am not sure it will help you: Like *B*


0 View this answer in context

Helpful Answer

Not what you were looking for? View more on this topic or Ask a question