Dynamic column for different entities

[100Rub]

How to create a form with dynamic cost buckets (columns) that change every year for different entities in OneStream ?

[Kamila]

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]

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 · Accepted solution]

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]

Thanks Kamila,

It worked perfectly with some changes.

Regards