05-17-2024 03:11 AM
Solved! Go to Solution.
05-17-2024 07:04 AM
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
05-17-2024 05:31 AM
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.
05-17-2024 06:20 AM
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
05-17-2024 07:04 AM
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
05-17-2024 10:35 AM
Thanks Kamila,
It worked perfectly with some changes.
Regards