Microsoft KB Archive/236121

= SS3: Usage Import Reports Do Not Reflect Time Zone Adjustment =

Article ID: 236121

Article Last Modified on 6/28/2004

-

APPLIES TO


 * Microsoft Site Server 3.0 Standard Edition
 * Microsoft Site Server 3.0 Commerce Edition

-



This article was previously published under Q236121



SYMPTOMS
After you set Usage Import to adjust log times during import, the changes are not reflected when reports are run.



CAUSE
The filter

(Date = "dd/mm/yy")

must be set in the report for time adjustments to be reflected in the report.



RESOLUTION
The import times are actually being modified in the database during the import. This can be verified by following this procedure:


 * 1) Open Usage Import.
 * 2) Click View.
 * 3) Click Import History Manager.
 * 4) Observe that the Request Times for start or end have been modified.

To add the filter, follow these steps:


 * 1) Open Report Writer.
 * 2) Open or create a new report.
 * 3) Right-click either the Root or the Measurement required. Choosing the Root will affect all child measurements.
 * 4) Click Properties.
 * 5) Click in the drop-down list box marked Dimension.
 * 6) Scroll down and select Date.
 * 7) A valid import date will automatically appear in the box. Choosing the drop-down list box will show other valid dates. (The value can also be typed in manually.)
 * 8) Click OK to close the dialog box.
 * 9) Save the report.
 * 10) Run the report

Additional query words: usage analysis report import

Keywords: kbprb kbpending KB236121

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.