Forum Discussion

FrankDK's avatar
FrankDK
Contributor
3 years ago

Cube View DatePicker, Time Zone and Custom Calculate

We're working on a solution, where users can enter and view a date through a Cube View using the Cell Type Date. The challenge is how OneStream handles date's (datetime) with time-zones. When a date ...
Infrastructure
Methodology
Time
nkehli's avatar
nkehli
New Contributor II
10 months ago

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

  • MG's avatar
    MG
    Icon for OneStream Employee rankOneStream Employee
    10 months ago

    Hi

    I'm assuming that you are referring to the date being shown as a header or a footer as you export to excel? There is a similar post already Book: Footer using UTC time zone | OneStream Community

    If you search for "UTC" on community there are a few posts and a couple of ideastream posts that you may want to upvote.  

    If you want specific help with your issue, it might be worth raising a ticket with support to discuss and demonstrate your specific issue. This post is originally 3 years old and since you are seeking someone at OneStream to explain how to resolve an important issue to you, I would suggest you proactively contact support as there is additional detail needed in terms of what you are trying to do and the expected result.  

  • EricPotts's avatar
    EricPotts
    New Contributor II
    10 months ago

    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.