Webi reports export to excel has a time differnce/PDF correc

building reports webintelligence legacy
1

Hi,

I am having a legacy system too to work on :shock: … I am having a report on a particular universe whose data when exported to excel shows a time differnce of 1 hr for each record whereas exporting to PDF gives the right data( the data displayed in universe).

I tried checking the time zone setting and all looks okay. Also, this is happening only for a particular universe reports only… :crazy_face:

Any one any clues? Not that much hands on on the older versions :frowning: :frowning:

Amy_Vikram :india: (BOB member since 2011-10-15)

2

There was a clock change and but it was not getting reflected in the excel. Excel was picking up the own time stamp :)…

Got the solution but thought might save someone’s time!

Amy_Vikram :india: (BOB member since 2011-10-15)

3

:wave: where does the time item located, webi header or body?

hongdida (BOB member since 2013-06-13)

4

Hi,

The timezone was at the webi header !!.. Does that makes a difference? Please let me know

Amy_Vikram :india: (BOB member since 2011-10-15)

5

sorry for the late reply. I just read this post, and it said "It is design behaviour. Items included in Header section won’t appear in Excel.

Move your blank cells(Which has refresh date,time,report name) from the Header section to body. It will appear now."

So I think maybe this is one reason.

http://scn.sap.com/thread/3335915 :slight_smile:

hongdida (BOB member since 2013-06-13)