Remove text from entities in Data Management

Question

Hi Everyone.
I have some entities that have text at the end, for example “_Test”, and what I want to do is that in the data management I can remove the text at the end to use the original entities.Example: 12001_12000_Test to 12001_12000
I want to remove that in the section that is in the image, so I wanted to know if it is possible or if there is a solution so that the api.Data.calculate and api.Data.SetDataCell use that entity without the “_Test”.

TheJonG · Accepted Answer

I say that the entities that have _test have different parents, and likewise I am making the copy from PLP to PLN.So there is no way to configure the api.data.calculate to work as I expect it to?

I think I am missing something but I think you just need to manipulate the source entity and leave the entity off the destination side.

You are copying from Entity to Entity_Test, correct?

If you define the _Test entities in the DM Step then your rule would look like this:

Dim povEntity As String = api.Pov.Entity.Name
Dim povEntityRemove_Test As String = povEntity.Replace("_Test","")
api.Data.calculate("A#S_HEADCOUNT = E#" & povEntityRemove_Test & ":A#Headcount")

TheJonG · Answer

Hi Marco - if I am understanding your question correctly, the entities returned by E#Root.WFProfileEntities would all have '_Test' at the end and you'd like to have the '_Test' removed?

If this is correct, you can do this through an XFBR rule which loops through the entities and removes "_Test". I have pasted some sample code below. To implement, you can replace E#Root.WFProfileEntities with XFBR(MarcoParamHelper, RemoveTestFromEntities) in the Entity filter of you Data Management step.

Imports System
Imports System.Collections.Generic
Imports System.Data
Imports System.Data.Common
Imports System.Globalization
Imports System.IO
Imports System.Linq
Imports Microsoft.VisualBasic
Imports OneStream.Finance.Database
Imports OneStream.Finance.Engine
Imports OneStream.Shared.Common
Imports OneStream.Shared.Database
Imports OneStream.Shared.Engine
Imports OneStream.Shared.Wcf
Imports OneStream.Stage.Database
Imports OneStream.Stage.Engine

Namespace OneStream.BusinessRule.DashboardStringFunction.MarcoParamHelper
	Public Class MainClass
		Public Function Main(ByVal si As SessionInfo, ByVal globals As BRGlobals, ByVal api As Object, ByVal args As DashboardStringFunctionArgs) As Object
			Try
				If args.FunctionName.XFEqualsIgnoreCase("RemoveTestFromEntities") Then
					
					Dim wfProfileEntities As List(Of WorkflowProfileEntityInfo) = BRApi.Workflow.Metadata.GetProfileEntities(si, si.WorkflowClusterPk.profileKey)
					
					Dim newEntityList As New Text.StringBuilder
					Dim isFirstItem As Boolean = True
					
					For Each wfProfileEntity As WorkflowProfileEntityInfo In wfProfileEntities
						
						Dim wfProfileEntityName As String = wfProfileEntity.EntityName
						
						If isFirstItem Then
							newentityList.Append("E#" & wfProfileEntityName.Replace("_Test",""))
						Else
						
							newentityList.Append(",E#" & wfProfileEntityName.Replace("_Test",""))
						End If
						
						isFirstItem = False
					Next
					
					Return newEntityList.ToString
				End If

				Return Nothing
			Catch ex As Exception
				Throw ErrorHandler.LogWrite(si, New XFException(si, ex))
			End Try
		End Function
	End Class
End Namespace

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded