Forum Discussion
Hi Jean,
I could do so by below:
1) setting up a parameter to provide list to user to select View members, i used MemberList parameter and set it up to pull base members. called as ViewParam
2) Call the parameter in Member Filter builder to first query for the selected member and then rename it using rename function. In rename function i used a XFBR business rule to substitute string. Called as below:
V#|!ViewParam!|:Name(XFBR(XFR_TextString, GetAltViewDesc, ViewName=|!ViewParam!|))
3) The XFBR business rule gets the ViewName paramter value and applies logic and returns in the Rename function to dynamically update name. I used below logic, can be modified as per requirement:
If (args.FunctionName.XFEqualsIgnoreCase("GetAltViewDesc")) Then
Dim viewName As String = args.NameValuePairs.XFGetValue("ViewName")
If viewName.Length >= 10 Then
Return viewName.Substring(0,10)
Else
Return viewName
End If
End If
Return Nothing
I am a fellow user of OneStream and think may be there are other ways to do this, but the above worked for me.
Related Content
- 2 years ago
- 2 years ago
- 2 years ago