BEX filter based on characteristic combination

[#1]

Hi,

I have 0SOLD_TO and 0CUSTOMER where 0SOLD_TO ( as you know) is referenced from 0CUSTOMER. Let say the user does not select neither customer nor sold to in the report global filter.And let say there are 3 rows in cube.

sold to - customer - key figure

A A 5

A B 10

C C 20

I want to display row 1 and row 3 where sold to and customer are the same.(both are A and both are C. ) .

I think a variable on sold to with type replacement path and referenced from customer will not work.Do I have to write a user exit? If so , can you give clues about the exit?

[kohesco · Accepted solution]

hi

if you have them both in your cube or in one infoobject, add the logic in the DWH if not you can create:

you can create a formula variable of both those objects-> get the key als key figure -> when this is done you can create formula:

(formula variable 1 == formula variable 2) this is a Boolean expression, giving you 1 for true, set a condition on the new variable > 0

grtz

Koen

[gunesbt · Accepted solution]

Hi,

Can you elaborate the content of the formula variable ? Using my example above if possible ( using customer and sold to scenario)

[kohesco · Accepted solution]

Hi,

check out blog

https://blogs.sap.com/2013/04/30/replacement-path/

[gunesbt · Accepted solution]

Hi

Thank you for the well explained blog but.I know about the formula variable and was actually asking about your method and how it will solve our problem.

[kohesco · Accepted solution]

Well you use both formula variables in a formula to compare them, it they match you set 1 if they do not match you set 0, via the condition you can filter out the matching ones

[gunesbt · Accepted solution]

Works perfectly...