Skip to Content
avatar image
Former Member

Bex reports - change sort criteria

Hello, experts. I need to modify 3.5 BEX reports to sort products by Core Brands and then all other brands. I have a list of products which are considered to be Core Brands. Product Master data does not have any Core brands indicators. How do I go about identifying core brand products in the cube and then sort in the reports by Core products first.

I'm new to BEX reporting so Any input is appreciated.

Thank you. Alina.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Sep 02, 2008 at 09:36 PM


    I can think of a few ways to do this depending on how complicated you want to make things.

    Probably the easiest way is to add an indicator for Core Brand .... and 'X' in the field means it's a core brand and you can either display only core brands or sort this field descending.

    Getting a bit deeper, you can create an attribute to your "Brand" characteristic and either assign the 'X' or give it a number -- 1 being your biggest brand and 10 your least biggest. Make the attribute navigational in your characteristic and data target and you can immediately start restricting/using it -- as in, without a reload.

    There are various ways to identify these values, probably the best is if the field is already populated in R/3. The next best would be to use a lookup table or info object .... that would contain the mappings between brands and indicator value (X or 1 or 2 ....). You would need to look up the values during your load time.


    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Alina,

      You can make two queries or add a variable on ZCR_BRAND. If you make two queries, you can filter out values with a value (or restrict out values <> #) to get core brands and include values = # for a non-core brand query.

      If you add a variable, then at run time you can choose the core brand ranking or all core brands <> #. I would choose this method since it is only 1 query to maintain. ... to create a variable, in your query on the left hand side of the screen, right click on ZCR_BRAND and choose create new variable. Make a characteristic value variable and make it optional, ready for input, and type selection option.

      Also, in the rows section of the query, you can place ZCR_BRAND as the first characteristic and it will sort automatically. If you don't want to see it, you can go into the characteristic's properties and choose "No Display" for the Display As property.