Skip to Content
0
Former Member
Apr 27, 2009 at 07:04 PM

WebI displays incorrect dates when sourced from SAP

30 Views

We have several issues, all tied to displaying dates from a BEx Query, through the universe, into WebI.

Scenario One: Dates that have a datatype of date will parse in the universe, but will give driver not capable when used in WebI. Could this be tied to an invalid date?

Scenario Two: Dates set with date datatype parse correctly and can be queried in WebI, but return incorrect results. If queried WITHOUT a measure, date appears as one day less than actual date (ex. SAP date = Apr 28, 2009 but universe object set with date datatype shows April 27, 2009. When a measure is added, the same date displays as Sept 27, 1976.

I suspect that we need to modify the data access files in order to accurately convert SAP dates (which by default come into the universe as Character) to a date datatype. If this is the case, are there sample sapen.prm and sap.sbo files to ensure appropriate settings?

Does anyone have additional thoughts on what could be causing this issue? Are there sample sapen.prm and sap.sbo files anyone would be willing to share?

Thanks!