Forum Discussion

100Rub's avatar
100Rub
New Contributor III
7 months ago

Dynamic column for different entities

How to create a form with dynamic cost buckets (columns) that change every year for different entities in OneStream ?
  • Kamila's avatar
    Kamila
    7 months ago

    I hope it helps:

    If args.FunctionName.XFEqualsIgnoreCase("DynamicColumns") Then
    Dim sEntity As String = args.NameValuePairs("Entity") 'thats the entity from cube view
    'if you won't take entity from cube view, just can take it from workflow 
    Select Case sEntity 
    Case Entity_1
    Return "S#Scenario_1, S#Scenario_2" 'or whatever you want
    Case Entity_2
    Return "S#Scenario_5"
    End Select
    End If