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
Avoid changing members manually through Member Filter - Quick View
Hi everyone, Is it possible to call the Rebuild function in VBA ? The goal is to update a Quick View by typing in a new period to avoid going into Member Filter and change the period manually (workbook contains multiple QV (ext. I know that Time Functions can be used so users can update through Cube View but the client insists on building a macro.
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.
24 Month PLP Dataset - Import to cube
Hello All, We have setup People Planning for 24 periods. We need to import the data into a cube across 2 years/24 months. Wondering the best approach. We have flagged Allow Loads After Workflow View Year as "True". We have tried using "Range" in the Workflow Tracking Frequency. This approach works, but the fact that we can't change time periods in the Scenario, creates some monthly and annual process management issues. Anybody use an alternative approach? Thanks, ScottMy client has all sorts for FX rate types attached to different scenarios (Actual, Budget, AOC, LE1, LE2, LE3...). Some of these FX rate types are updated during the year.
Originally posted by Rob Dessureault 1/23/2019 My client has all sorts for FX rate types attached to different scenarios (Actual, Budget, AOC, LE1, LE2, LE3...). Some of these FX rate types are updated during the year. Besides updating them as follows: Manually adjusting them in the FX Rates table or Exporting to Excel, manipulating the file and then loading it back in or Using Excel XF functions Are there other ways that people have come up with?Copy FXRates
Originally posted by Diane Rochford Has anyone copied FXRates from prior month Closing FXRate to current month Average FXRate? In HFM, I can copy last period in year closing FXRates, Actual scenario, to both current closing and current average rate, constant $ scenario. I was also able to copy the prior month closing rate to all future period closing rate and average rate within the Forecast scenario. I would expect I can do these copied within OneStream, I just cannot find where, or how, I can accomplish this task. Help is greatly appreciated. Thanks Diane
Headcount Roll-Forward using Flow Dimension
Hi all, I have built out my cube view that shows headcount change for 2019 M12, I want to be able to capture the ‘Ending Balance Headcount’ for 2020 M1 as its ‘Begin Balance’. Will a rule be the way to go in order to achieve this? Unsure on where to go from here. Thank you.
