Hi all
This is still an issue in 8.4 version when we export a cube view to excel, we have the 1 day difference? Can someone from OS comments and explain how we can resolve this important issue?
Thanks
Nouria
Hi Nouria,
We have this issue as well. There are limited ways to work around this, but the value stored in the Cube View Cell Type "Date" will always have a date and time. That date time being off by x number of hours between different users is what drives the difference when exported to Excel. One thing you can do is open the Cube View in Excel via the Excel Add-In instead of exporting to Excel. This will keep the date showing the same no matter if you look in the OneStream client or Excel.
There are a few other ways to handle some parts of this based on where your end users are located on the globe and how the data gets into the system. One example would be if you load the data you can use a DateTime add hours and then convert back the ticks numeric value to load into OneStream.
We opened a ticket on this and OS acknowledged that the time part of the Date Time will be an issue unless this is changed to just a date and not a time.
