Getting Results You Expect

If, after processing a query in the Data Warehouse, you get zero rows or do not get the results that you expect, try checking the following:

• Limits: Check that the limits are applied properly. Remember to check that the case and formats for the field that is being limited are chosen correctly. For example, make sure that the "P" in the Profit Center ID number is capitalized.
  
  
• Joins: Double-check that the tables are joined properly, with only one join between any two tables. Try deleting the join (click on it to highlight, and press the delete key) and re-joining. Incorrect joins can sometimes be made by joining to the field above or below your intended field.
  
  
• Timing of Data: Are you certain that there is data in the Data Warehouse for the time period(s) you have requested in your query? For example, the Warehouse does not have any telephone data prior to June, 1999. Requesting a date prior to then would result in zero rows.
  
  
• Access: Confirm that you have access to the data you are trying to retrieve. One easy way to do this is to open a new query, open the table catalog, and see whether the tables listed in your view are also in the query you are trying to process. Contact warehouse-admin@mit.edu if you believe there is a problem with your access to data.

Contact warehouse-help@mit.edu if you are still not able to get the results you anticipate. A Data Warehouse team member will be in touch with you to assist you further.