Tuesday, October 22, 2013

Changed Table: Vendor

Financial Warehouse
VENDOR table has been replaced by VENDOR_TBL in the Financial Data Warehouse.

Here is what you need to do to modify your query:

  1. Change VENDOR table to VENDOR_TBL table in your existing query.
  2. 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.