Forum Discussion

100Rub's avatar
100Rub
New Contributor III
8 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
    8 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

     

Kamila's avatar
Kamila
Contributor

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

 

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

Thanks Kamila,

It worked perfectly with some changes.

Regards