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
    8 months ago

    To make columns dynamic, you can use parameter or XFBR String.

    In parameter you can use method type - Business Rule and there define the logic according to entity from workflow.

    You can also use XFBR - XFBR(Business Rule name, name of Method, another parameters) like XFBR(MyBusinessRule, MyMethod, Entity = |MFEntity|) in column and of course write a Dashboard XFBR String business rule.

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

      Hi Kamila,

      Thank you for your solution. I would appreciate it if you could please draft a snippet for Dashboard XFBR String business rule, as I am not well-versed in writing code. 

      Kind Regards

      • Kamila's avatar
        Kamila
        Contributor
        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