Startup blogging

-
Being inspired by other bloggers/ websites in my area. Now it's time to share my knowledge/ findings.
About: Business Intelligence, SAP Business Objects reporting, analyses and Dashboarding.

Reacties

Een reactie posten

Populaire posts van deze blog

Auditing.unx Universe has a difference of two hours time!

-
Afbeelding
The Standard delivered Auditing Universe with SAP BO4.0/4.1 leave much to be desired. But the main things that needs to be resolved are time-related. Example: The local time is 12:55, but the registration in the audit table is 14:55. That is a two hour difference, can be very confusion especially for end users. To correct this little, but annoying problem do the following.  Replace the SQL statement, of the object "Event StartTime" Replace: ADS_EVENT.Start_Time by DATEADD(hh, DATEDIFF(hh, GETUTCDATE(), CURRENT_TIMESTAMP), ADS_EVENT.Start_Time ) Do not forget to alter all depending/derived  objects/Filters. Use @select statements wherever you use ADS_EVENT.Start_Time. Like: object: [Event year]= datepart(yyyy, @Select(Events\Event StartTime))
Meer lezen