If you are using the tracking profile editor to map orchestration shapes/events to BAM activity, the date time value that appears in views and cubes will be in UTC (Coordinated Universal Time) time. With a little tweaking of a stored procedure for each activity, you can display the date time value in your local time.

The stored procedure to modify is: bam_<Activity Name>_PrimaryImport. Add the following couple of lines in this stored procedure: