OneStream Community

Rev · 07-09-2024

Hi all, Noticed the data cells in my input forms are turned read only and cell status also shows the same. Please suggest on how to make it enabled for input. Thanks

Rev · 05-02-2024

Hi all, Due to requirement,the conso type we use is force consolidation,while doing which noticed that more time is taken during "Aggregate child entities" and that too for specific year (2024). When drilled through it,noticed there are huge number o...

Rev · 10-24-2023

Hi all, We're trying to pass below listed parameters to the table view: Case Is = SpreadsheetFunctionType.GetCustomSubstVarsInUse Dim paramList As New List (Of String) paramList.Add("ParamScenario") paramList.Add("prm_UD4_Select") Return paramList Ca...

Rev · 10-02-2023

Hi all, I've col A and col B.I want to show a dynamically calculated col C which should be based on below logic: If col A has no data then display col B Else display col A Please suggest the best options to achieve this. Can it be handled in cube vie...

Rev · 07-27-2023

Hi,While we copy from Scenario S#Bud1 to S#Bud2, Annotations are not getting copied.Understand from related posts, it can be achieved using api.Data.SetDataAttachmentText(). Any tried approach using this syntax.Any leads would be appreciated.Thanks

Rev · 07-09-2024

Workflow setting looks ok entity security also looks ok: scenario also looks ok : cube view settings are ok too: Is there something we're missing. I was able to input until yesterday.

Rev · 05-24-2023

Hi, I tried the above solution to check particular workflow's status and resulted in following error."The given key was not found in the dictionary"Here is the code I tried:

Rev · 04-10-2023

It is due to space created for each member.Resolved using below line and it worked.Dim ParamCC as string = (args.customcalculateargs.NameValuePairs.XFGetValue("ParamCC")).Replace(" ","")Dim split as String() = ParamCC.Split(",")For Each param As stri...

Rev · 04-10-2023

Thanks Seburn.I tried the suggestions provided and it works partially.Means when list of members were passed in ParamCC, it works only for the first parameter.Dim split as String() = args.customcalculateargs.NameValuePairs.XFGetValue("ParamCC").Split...

Re: Use computed member across forms/BRs · 10-04-2022

Hi JackLacava,Yes I run the calculate.A#Salary -> Expense type account(Formula type = "Not Used") and i dint set any formula pass.But I run the BR1 first and I still see the value stored as 14000 in CV1.Is there any other way to check if it is stored...

OneStream Community

User Statistics

User Activity

Data cells are read only

consolidation takes longer time than usual

Using Parameter in table view

Dynamically calculated column

Copy Annotations across scenario

Re: Data cells are read only

Re: can we test if Workflow Channel is locked in a BR before taking requested action?

Re: passing multiselect combo-box as parameter

Re: passing multiselect combo-box as parameter

Re: Use computed member across forms/BRs