Increase one day when you export the data of 2100 and later in Excel 2007 (Doc ID 2060913.1)

Last updated on OCTOBER 22, 2015

Applies to:

Business Intelligence Server Enterprise Edition - Version 11.1.1.7.150120 to 11.1.1.9.0 [Release 11g]
Information in this document applies to any platform.

Symptoms

Exporting the data beyond date 12/31/2099 to Excel 2007, it shows the date increased by one day.

The issue can be reproduced using Sample Sales Lite:

  1. Create new analysis the below columns

Products.Brand
TIMESTAMPADD(SQL_TSI_YEAR,90, "Time"."Calendar Date") 
Calculated Tacts.Actual Unit Price

  1. Show the analysis on BI

Brand   TIMESTAMPADD(SQL_TSI_YEAR,90,Calendar Date) Actual Unit Price
------------+-----------------------------------------+-----------------
BizTech     2100/04/22                     80.71
HomeView 2098/06/13                     60.65
BizTech     2100/12/29                     60.62
BizTech     2100/06/22                     59.28
BizTech     2099/02/10                     15.04

  1. Export to 2007 Excel

Brand   TIMESTAMPADD(SQL_TSI_YEAR,90,Calendar Date) Actual Unit Price
------------+-----------------------------------------+-----------------
BizTech     4/23/2100(*)                      80.71
HomeView 6/13/2098                         60.65
BizTech     12/30/2100(*)                     60.62
BizTech     6/23/2100(*)                        59.28
BizTech     2/10/2099                          15.04

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms