Skip to main content
M
MarcusH
Expert
August 14, 2024
Solved

Member Formula - get current member name

  • August 14, 2024
  • 1 reply
  • 0 views

Hi All

Does anyone know if you can get the current member name in a Member Formula? As an example, I have the UD8 member UD8 AverageRate_Budget - I want that information without manually adding a variable. I have a lot of members whose member names contain all the information for their value. It would save me a lot of time if I had one script that I could copy to all the members without editing them to update the member name. The members are DynamicCalc if that makes a difference.

I have tried args.DataCellArgs.FunctionName and args.CustomCalculateArgs.FunctionName but they both raise an error.

Thanks

Marcus

    Best answer by TheJonG

    If I am understanding you correctly, you have a formula e.g. api.Data.Calculate("A#Sales = A#Price * A#Volume") and would like this to know if you can do something like this: api.Data.Calculate("A#[Current Member Name] = A#Price * A#Volume") assuming so that you can copy this formula to other members and not have to update the target name?

    If so, I don't believe there is a way to do this. The finance engine processes scripts without knowledge of member names for which they are attached. If you can describe exactly what your formula is and what its trying to do, there may be a way to write the formula differently in a business rule which loops through a data buffer and brings in the account name so logic can be performed on it. 

    1 reply

    T
    OneStream Employee
    TheJonGOneStream EmployeeAnswer
    OneStream Employee
    August 14, 2024

    If I am understanding you correctly, you have a formula e.g. api.Data.Calculate("A#Sales = A#Price * A#Volume") and would like this to know if you can do something like this: api.Data.Calculate("A#[Current Member Name] = A#Price * A#Volume") assuming so that you can copy this formula to other members and not have to update the target name?

    If so, I don't believe there is a way to do this. The finance engine processes scripts without knowledge of member names for which they are attached. If you can describe exactly what your formula is and what its trying to do, there may be a way to write the formula differently in a business rule which loops through a data buffer and brings in the account name so logic can be performed on it. 

      M
      MarcusHAuthor
      Expert
      August 15, 2024

      The formulas are not returning amounts, it's text which is stored in the Account Text property and it needs to be parsed (it's for ESG and CbC reporting). You have answered my question anyway. I can make the member formulas dynamic by dimension but not by all dimensions. Not a big problem as the members will probably be always in the same dimension anyway.

      Y
      YanSavinsky
      Contributor
      August 15, 2024

      Will not the following do the job?

      Dim UD8Name As String = api.Pov.UD8.Name.ToString

       

      Terms & ConditionsAccessibility statement