SAP Knowledge Base Article - Public

1719922 - Date value changed when previewed from Dashboard Design 4.0

Symptom

Dashboard Design returns Incorrect Date value at Run-time. For instance, if the date value is 4/1/08 Xcelsius displays 4/2/08 or 3/31/08.

Environment

  • SAP Business Object 4.0 SP02
  • Dashboard Design 4.0 SP02 and above

Reproducing the Issue

  1. Create a QaaWS Query with a date parameters.
  2. Publish the QaaWS Query.
  3. Launch Dashboard Design and import the QaaWS Query.
  4. Reference the data in the spreadsheet (Example: A1 to A20)
  5. Add a spreadsheet component on the dashboard to map the spreadsheet data from A1 to A20.
  6. Click Preview
  7. The dates in QaaWS & WebI are correct, however in Dashboard Design it shows incorrect date value.

Cause

The issue has been identified and logged under Problem Report ID ADAPT01614296.

Resolution

  1. The issue is resolved in BI 4.0 SP02 Patch 18 under Problem Report ID ADAPT01614296
  2. However is currently in progress  for BI 4.0 SP04 under Problem Report ID ADAPT01598802.

 To workaround this issue, if in BI 4.0 SP04:

  • Change the Date type dimension object to Character type object in the Universe.

Keywords

DD,day,hour,time,ADAPT01598802 , KBA , BI-RA-XL , Obsolete: BusinessObjects Dashboards and Presentation Design , Bug Filed

Product

SAP BusinessObjects Dashboards 4.0