Update the member Text5 property from a dashboard

[Marta]

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.

[Manasa]

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.

[johnnyRockets]

Hi Marta,

An alternative would be to utilize ACM (Application Control Manager) from the marketplace. The out-of-the-box functionality within ACM provides a Workflow to manage any metadata change requests. It could be worth exploring, especially if you will need to update more than one member property.

Thanks!