VENDOR table has been replaced by VENDOR_TBL in the Financial Data Warehouse.
Here is what you need to do to modify your query:
- Change VENDOR table to VENDOR_TBL table in your existing query.
- If you also join VENDOR table in your existing query, you will need to change the link to Left join instead full join in your query.
We have created another help article (http://help.asu.edu/sims/selfhelp/SelfhelpKbView.seam?parature_id=8373-8193-7884) for instructions on how to change a table name.
If you have any further questions regarding the new Vendor
table, please contact the Advantage Helpline at advantage-q@asu.edu. If you need
assistance in modifying your existing query, please contact the BI Reporting
team at myreports@asu.edu.
No comments:
Post a Comment