Restricted Measure in Analytic View - no 'not equal to' option?

[justin_molenaur2]

Hi all, I am trying to implement a restricted key figure using a 'not equal to' operator and am finding that it doesn't exist. I can only see Equal, GT, LT, GTE, LTE, and null operators.

I believe I will be able to get around this one since the distinct values in this column are small (I can just INCLUDE all others), but I do find it limiting that a restricted measure does not offer this operator.

Anyone else hit this limitation or know if this was implemented for maybe performance reasons?

Regards,

Justin

[Former Member · Accepted solution]

Hi Justin,

Please correct me if I am wrong.

Can we not just enter :

'= Equal' <value you want to exclude> and uncheck 'Include'?

With this, you are essentially excluding the value you do not want if I am not mistaken.

BR,

Nidhi

[justin_molenaur2 · Accepted solution]

Hi Nidhi, this only toggles whether to include the restriction in the evaluation, NOT to exclude it. Essentially a way to turn the specific restriction on or off.

Regards,

Justin

[Former Member · Accepted solution]

Ok. Can you take a quick look at this and help me understand :

I created an Analytic view on the demo EPM tables provided,

Here's a snapshot of rest_1 (Include unchecked)

rest_2 (include) :

Data Preview :

Why is PurchaseOrderItem 0000000010 excluded (rest_1) here?

Thanks much!

Nidhi

[former_member199691 · Accepted solution]

coz in rest_1, you did not mark include that means exclude 10 for rest_1.

[Former Member · Accepted solution]

Hi Gaurav,

That is exactly my understanding. But, acc. Justin's reply, that should not be the case.

Hence the query.

BR,

Nidhi

[justin_molenaur2 · Accepted solution]

Nidhi - I stand corrected! I tested again today with some other data and it worked just as you are illustrating. For whatever reason I think I had my test scenario set up incorrectly previously.

Really appreciate the detailed screenshots. SCN is a great community!

Regards,

Justin

[Former Member · Accepted solution]

That's great! Glad to help.

BR,

Nidhi

[Former Member · Accepted solution]

HI Nidhi,

I'm facing a situation, wherein I need to do more than 1 exclusion on the same field and it's not working.

Let's take your example:

Suppose in rest1, you add one more restriction that PurchaseOrderItem not equal to '20',

Then in that case, how ill you achieve this.

Thanks & regards,

Jomy

[Former Member]

I'm not sure about the Include check box. Let me know if it works for you.

However I have had faced the issue of needing to use "Not Equal To" Functionality. This is the work around I used:

Lets say for Restricted Key Figure "RKF1" we want to have the restriction SITE NOT EQUAL TO 1000.

Add two restrictions on RKF1

SITE > 1000 and

SITE<1000.

This has always worked for me.

[Prabhith]

Hi Former Member,

I remember a similar discussion(old one) on this topic,

http://scn.sap.com/message/13149257

Please check if its useful.

BR

Prabhith