The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

100Rub's avatar
100Rub
New Contributor III
2 years ago
Solved

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
    2 years 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
2 years 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
2 years 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
    2 years 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

     

    • 100Rub's avatar
      100Rub
      New Contributor III
      2 years ago

      Thanks Kamila,

      It worked perfectly with some changes.

      Regards