How to upload multiple values as a filter in BW
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:
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?