1396314 - Xcelsius 2008 Australia EDST date incorrect

SAP Knowledge Base Article - Public

1396314 - Xcelsius 2008 Australia EDST date incorrect

Symptom

  • In Xcelsius 2008 when the day of the start of Extended Daylight Savings Time (EDST) for Australia (GMT+10:00) is displayed in an analytic the time is shifted back 1 hour from Midnight to 2AM. 
  • The daylight saving actually starts at 2AM (2AM becomes 3AM on 4thOctober)
  • Main problem is observed when a date is stored as 4thOctober (in Excel this is stored as Midnight) - when displaying in Xcelsius it is becoming 3rd October (Xcelsius shifts back to 3rdOctober 23:00)

Environment

Xcelsius 2008 (Service Pack 2)

Reproducing the Issue

  1. Set Windows Time Zone to GMT+10:00 - Australia Canberra, Melbourne, Sydney & Check the box "Automatically adjust for daylight saving changes" 
  2. Install the latest Microsoft patches for DST
  3. Create Xcelsius 2008 model with 2 rows with dates:
    3rdOct
    4thOct
  4. change the display so that you can see the HOUR displayed also (eg d/mm/yyyy hh:mm) - this is just to make it easier to see what is happening
  5. Add an analytic to the model to display the 2 values above (I've tested with bar chart & grid)
  6. Note that the second value (4thOct 0:00) becomes 3rdOct 23:00
    This leads to incorrect aggregations & calculations & incorrect display of metrics

Cause

Issue tracked as Problem Report ADAPT01310377

Resolution

Work-around:
Adding 1 hour to each date masks this issue & is OK if only DATE is importatant & DATETIME is not relevant

Fix has been included in Xcelsius 2008 Service Pack 3 - released December 2009

Keywords

Extended Daylight Savings Time
4th October 2009
4/10/2009
Date
Eastern Australia
NSW
Vic , KBA , BI-BIP-ADM , BI Servers, security, Crystal Reports in Launchpad , Problem

Product

SAP BusinessObjects Xcelsius Enterprise 2008