Skip to Content
avatar image
Former Member

Bex Query Filter on Navigational Attribute of Compound Characteristic

Hello,

I have a requirement to filter on a navigational attribute of a compnd characteristic in BEX BW 7.3.1 SP7. I have found many posts on this topic but the solution evades me and I am hopeful that you can help what I have overlooked.  Perhaps this is not possible with compound characteristics?

Thanks for your help!

Lee Lewis

http://scn.sap.com/thread/1695754

http://scn.sap.com/thread/1823006

  1. The info object is 0MAT_PLANT and the attribute 0DISMM is marked as navigational in RSD1
  2. 0DISMM is present as nav attribute in the infocube and multiprovider with the On/Off Checked
  3. In Bex Query Designer, the nav attribute 0DISMM is visible under the dimension and characteristic Material Plant View
  4. I want to filter on 0DISMM where value is Z1, but when I try to drag the nav attribute to the restriction or filtered values, the characteristic Material Plant View is added.
  5. When I try to restrict values on characteristic Material Plant View, the nav attribute is not displayed, only the keys Material Plant View
  6. I tried to create a variable on characteristic Material Plant View, but again unable to restrict on a nav attribute.
  7. I dropped and reloaded the cube, and checked for attribute change run required (it was not)

I am able to add the nav attribute to the right of the characteristic Material Plant View, and the user can sort on it, but they cannot filter on it. However, the requirement is to set a characteristic restriction on the nav attribute in the query designer.

  

1.png (82.5 kB)
2.png (23.1 kB)
3.png (57.7 kB)
4.png (33.5 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Jul 16, 2013 at 08:57 PM

    Hi,

    Acording to your prints, you are not using the nav attribute

    You need to put the green object 0MAT_PLANT__0DISMM (press F12 in Query Designer to see technical names)

    Regards,

    Paulo.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 16, 2013 at 07:21 PM

    When you right clicked on Mat Plant view field in filter pane-->restrict-->Variable, you could not get it right?

    How are you getting in your report? Are you using Mat plant view field in rows pane?

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      When I add Plant Material to Filter, I can right click to restrict, but the values to restrict are on the characteristic keys and no nav attributes are available for filter selection

      Lee

      1.png (44.0 kB)