Skip to Content
avatar image
Former Member

BEX filter based on characteristic combination

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Oct 31, 2017 at 02:29 PM

    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

    Add comment
    10|10000 characters needed characters exceeded