on 07-16-2013 7:34 PM
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
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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Paulo,
Would you please elaborate? I see 0MAT_PLANT__0DISMM is a under the navigation attrib section of the infoproivder as green triangle, but in query designer it (MRPType) is orange under the Attributes folder of Material Plant View
I cannot drag orange triangle to filter panes...What am I missing?
Thanks
Lee
Thanks Suman
I found that by simply checking the Nav/Display setting on the attribute for the char in RSD1 was not enough. I had to press the pushbutton 'Navigation Attribute Infoprovider' and check the Selection box. Then closed and re-opened Bex Qery designer and the nav attribute now appears like a characteristic with green triangle so can restrict/filter on the current master data values of the material like MRP
I appreciate the help! Points!
Lee Lewis
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
9 | |
7 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.