Forum Discussion

Marta's avatar
Marta
New Contributor
2 years ago

Update the member Text5 property from a dashboard

Hello, We want to update the UD2 Text5 property from a workflow step (via a cube view or a dashboard, for example). Is it possible to do it? We don't find how to do it. Thanks.
Cube View
Dashboards
Manasa's avatar
Manasa
New Contributor III
2 years ago

Hi Marta, 

One approach would be to use a button and a dashboard extender rule to do this.

Create a button that calls the rule as shown below, passing the member's name and the text5 value (modify as needed).

and use the below code to update the property.

Dim selectionChangedTaskResult As New XFSelectionChangedTaskResult()
					Dim memberName As String = args.NameValuePairs.XFGetValue("Name")
					Dim propertyValue As String = args.NameValuePairs.XFGetValue("Value")
					Dim member = BRApi.Finance.Members.GetMemberInfo(si, DimType.UD2.Id, memberName,True)
					Dim UD2Properties As UDVMProperties=member.GetUDProperties()
	                UD2Properties.Text5.SetStoredValue(ScenarioType.Unknown.Id, DimConstants.Unknown, propertyValue)
					selectionChangedTaskResult.WorkflowWasChangedByBusinessRule = True
                    selectionChangedTaskResult.IsOK = True
                    selectionChangedTaskResult.ShowMessageBox = True
                    selectionChangedTaskResult.Message = "Text 5 updated"
	                
					Return selectionChangedTaskResult

Thank you.