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
OSAdmin
OneStream Employee
6 years agoIs it possible to change the displayed text in a Cubeview of a member of the View dimension ?
Originally posted by Jean-Daniel Pelchat Is it possible to display a value different than the Member name of the View dimension ?
For example, the View = Trailing2MonthTotal. But in the cubev...
OSAdmin
OneStream Employee
6 years ago Originally posted by Anoop Sharma
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
- 3 years ago
- 2 years ago