Forum Discussion

Marco's avatar
Marco
Contributor II
5 months ago

Remove text from entities in Data Management

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....
Data Management
Transformation
  • TheJonG's avatar
    TheJonG
    5 months ago

    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")

     

Marco's avatar
Marco
Contributor II

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?

TheJonG's avatar
TheJonG
Contributor III
5 months ago

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's avatar
    TheJonG
    Contributor III
    5 months ago

    The only way to run an api.Data.Calculate in an entity that is not in the POV is to kickoff a CustomCalculcate rule from the Business Rule. You can pass in the right entity in through the param dictionary.

    Dim brParamDict As New Dictionary(Of String, String) From {{"Cube", api.Pov.Cube.name},
								                        {"Entity", "NewEntityName},
								                        {"Consolidation", "Local"},
								                        {"Scenario", api.Pov.Scenario.Name},
								                        {"Time", timedimhelper.GetYearFromId(api.Pov.Time.MemberId)},
								                        {"View", "YTD"}}
								
'Trigger custom calculate
								BRApi.Finance.Calculate.ExecuteCustomCalculateBusinessRule(si, "CustomCalcRule", "RuleName", brParamDict, CustomCalculateTimeType.CurrentPeriod)

     

  • Marco's avatar
    Marco
    Contributor II
    5 months ago

    Thank you very much Jon for the help, I used an XFBR String to be able to treat those entities and it worked for me, thank you for answering every doubt.

  • Marco's avatar
    Marco
    Contributor II
    5 months ago

    I was referring to the case of modifying the api.Data.Calculate to change the entities that it has for the Data Management, this to change the entities that the function with _Test has inside, to remove them. since the problem of the entities I mentioned, is that they are in those parents that are not the dummy, and they are not together in a place to put that section in the entities of the data management.