OneStream Community

BSK

We want to make some forecast periods read only ( Data seeded periods from Actuals) in a Data submission cube view by referencing the period count submitted in another Cube View. Basically, this is to deal forecast data submission.Trying to achieve t...

BSK · 06-06-2023

Hi Folks,We have 12 forecast scenarios and 12 FX rate tables for each FC scenario.When we update the FX Rates in one table, it's upsetting the status in all other Forecast scenarios, but not Actual.We don't want other scenarios status getting affecte...

BSK · 02-17-2023

Could you please provide a sample script with example to Generate the base mambers of UD2 dimension into a Variable. I'm trying to follow the below syntax, but it's not working for UD Dimensions Dim baseMembers As List(Of Member) = api.Members.GetBas...

BSK · 01-09-2023

Is there any maket place solution available to export the journal reports into a standard format similar to HFM, where we can see all the dimensions in one row and in consecutive columns and apply the filters? Also, is there any way to export all the...

BSK · 11-02-2022

Hi, Is there any option to restrict some of the users to post unbalanced journals ? we are able to restrict it in the journal templates. But we also want to restrict when user try to create by clicking on "Create Journal". Using the event Journal rul...

BSK

Thanks Celvin. We want this to be very dynamic as it varies for each forecast scenario. and also, we need seed the data for that specific periods.

BSK

Hi Mike, thanks for the responce.We want to avoid metadata changes as it required to follow internal change management process. Thanks

BSK

Hi Jack,Thanks for the responce.I tried initially with Integer and it didn't work. Then was playing with other data types.Currently we are handling handling through Text 3 and changing the metadata scenario property to the number of periods required....

BSK · 07-05-2023

Hi Marcello,We also have a need to calculate absolute values into destination member, Could you please suggest how did you achieve this.Thanks

BSK · 06-06-2023

Hi Nick,We have seperate rate table for each forecast scenario. we have 12 FC scenarios and 12 rate tables.Thx

OneStream Community

User Statistics

User Activity

Dashboard XFBR String Rules - api.data.GetDataCell

Entity Consolidation status change for Forecast scenarios

How to get Base Members of UD Dimension into a Variable

Journal reports

Restriction of posting "Unbalanced" journals when creating the journals manually

Re: Dashboard XFBR String Rules - api.data.GetDataCell

Re: Dashboard XFBR String Rules - api.data.GetDataCell

Re: Dashboard XFBR String Rules - api.data.GetDataCell

Re: api.Data.Calculate available operators (AbsoluteValue)

Re: Entity Consolidation status change for Forecast scenarios