SAP Knowledge Base Article - Public

1391378 - Incorrect date is shown in Xcelsius preview

Symptom

When using the =DATE() function in excel, the result in Xcelsius preview is off by one year.

Reproducing the Issue

Environment

  • Xcelsius 2008 Service Pack 2
  • Microsoft Office Excel 2007
  • Windows XP Professional
  1. In Xcelsius 2008 Service Pack 2, enter the follow formula in a cell: =DATE(2009,-11,30)
  2. The result will show 1/30/2008 in Excel. 
  3. Display that cell with the spreadsheet table component
  4. Click "Preview" and find that the result shows 1/30/2009.

Cause

  • The issue has been identified and logged under Problem Report ID ADAPT01268054.
  • This occurs when there is a negative value for the "month" parameter that is expected to fall on January.

 

Resolution

This is resolved in Fixpack 1 for Xcelsius Service Pack 2 (SP2.1).

Keywords

incorrect date; date function; Xcelsius SP2 , KBA , BI-RA-XL , Obsolete: BusinessObjects Dashboards and Presentation Design , Bug Filed

Product

SAP BusinessObjects Xcelsius Enterprise 2008