Have a request to change the currency of a parent Entity and want to know what the implications are and the best way to go about it.
Originally posted by Laura Garcia 7/26/2019 Have a request to change the currency of a parent Entity and want to know what the implications are and the best way to go about it. History of course would retranslate so if they don't want that to happen, what's the recommended approach? Create an alternate hierarchy with the new parent in the new currency? Add the new parent above the old? Any suggestions or thoughts?!
13 Period time dimension vs UD
Hello everyone, We have a client that uses 13 period time dimension in their current system that we are moving to onestream at the moment. They use period 13 to load TB' post adjustments even input disclosures currently. We first wanted to use a UD dimension to capture it but I'm more and more leaning towards having custom 13 period time dimension to cater that. I know that is something that needs to be set up during application creation so I'm guessing we need a new application. Is that something to be requested from OneStream to set up? I also would love to hear if any of you had a similar case and how you handled it.
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 is saved to the backend, it's converted to UTC time-zone. The Date component in the Cube View is also Time-Zone aware, so that it uses the local time of the user, to convert back from the backend UTC to local-time. The challenge with this is 2 fold: 1) Assuming we would calculate a rent for a given period. The user, based in CET time-zone, enters 2022-1-15 using the Gridview. This date is converted to 2022-1-14 as UTC (2022-1-14 23:00:00). Using a Custom Calculate method to calculate the rent from start (2022-1-15), now adds one day more, as the server time is UTC. (don't mention Daylight Saving Zone) 2) If another user, based in US Central, is reviewing data in the same Grid View (and same POV), this user will see a wrong date, as the server UTC date, is converted to this user's local time Is there a way to specify in the Cube View, that when using the Date/DateTime picker, that the component should ignore time-zones? Or are there other usable solutions for this issue? Cheers
