Armstrong-Smith Consulting

What starts right - stays right

You'll wish you found us sooner!

 [Home] [Blog]

About Books Consulting Contact Downloads Resources Training SungardHE



This page contains details about how to correct the error in the MONTH table.

If you downloaded a copy of the prior to October 10, 2002, you will have an incorrect foreign key link for one of the months.  To correct this do the following:

  1. Log on to SQL as the schema owner
  2. Type and execute the following SQL

        update gs_month
        set quarterid = '1998-Q3'
        where monthid = 'May-98'


Last updated: October 28, 2008 
According to you are visitor number   
  The Business Intelligence and Discoverer experts. You'll wish you found us sooner!
Home ] Up ] [Blog]

Copyright 2002, 2003, 2004, 2005, 2006, 2007, 2008 Learn Discoverer, Armstrong-Smith Consulting.  All rights reserved.