Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How to upload multiple values as a filter in BW

Hi All,

I am using a Bex query as a source to one of my BOBJ 4.1 reports and there is an object called as Vendor Number that I need to filter on.

There are about 4200 unique values of Vendor NumbersĀ  that i need to apply the filter on.

However, When i specify these vendor numbers in the Characteristic Restrictions of the Bex query, I keep getting the following error "RSR_BAD_CODING2".

I did some research on SCN discussions and found that the following thread has a relevant answer with the following Solution:

Unable to generate query RSR_BAD_CODING2 withou... | SCN

Solution

You can achieve the same result by creating an external hierarchy and

aggregating the thousand single values in a hierarchy node, which you

can then use as a filter in the structure item or in the global filter.

Alternatively, you can use a navigation attribute.

However, I am not sure how to create an external hierarchy or a global filter with all the 4200 vendor number values.

Is there any easy method with detailed steps on how i can apply 4200 filter values for a Bex query?

Thanks,

Nimish

Former Member
Not what you were looking for? View more on this topic or Ask a question