Question:
Hi All,
Any inputs on how to give user a selection field based on the Vendor Name than the Key.
Right now, our users are able to report on transaction data based on the Vendor number selection criteria.
e.g, 123488 Fleet Bank
Now the user want's to enter "Fleet*" in the selection screen for Vendor and then the report should automatically comeup with the transaction data with the Vendor number 123488.
There is a strong reason for this. We have same vendor with different vedor numbers. The name atleast contains a coommon word. So, The user wants to a filtering based on the Vendor Name (Texts) than the Vendor number.
Thanks in advance.
Answer:
Hi All,
Any inputs....
Answer:
Why not make the query a multiple selection for starters?
Answer:
Bob,
There is a point in the user request. There are totally 95,000 vendors in the system. The cube has 12 million records. Now, they have to group all the transactions with Vendor Name (texts) having "Fleet".
The only way they can do this if they can do a filteing on the vendor name using wild charactres like R/3 provides.
Vendor Name: FLEET*
Period: 001/2003 to 007/2003
Then execute the report.
They should get all the results.
Any help.
Regards,
- Gary
Answer:
In the selection screen of your query, you can drill down (F4) in the variable and the system will list the key and name. you can do your name filtering here..
hope this helps.
Answer:
This is a temporary solution to your problem:
1- extract your vendor lists into flat files. Ideally, export only the one with 'Fleet' in description.
2- combine, sort and clean up files to make one with 'fleet' vendors only and save this as text file type.
3- In your query, make sure the vendor variable could accept multiple selection.
4- Execute your query. In the selection screen, select multiple selection for vendor. Click on the upload from file button. Then select the file created in step 2 and load it.
Gary, this should work well for up to 1000 single entries. After that, you might have to find a way to create secondary index for vendor tables (ask SAP) to speed up the selection process.
For permanent solution, I think you need to redesign your vendor master data so that you can easily select 'Fleet' vendors
Answer:
You can also solve by creating Hierarchies.
Answer:
HI
I guess, bwquery is rite instead redefining the LEGACY system which m sure most clients dont like, as an BW consultant a BW HIERARCHY could be the solution.
Thanks
Chetan