Forum Discussion

SimpleLove's avatar
SimpleLove
New Contributor III
6 months ago

How to use if statement to check calculation flag

Dear OneStream Experts: Thank you so much for the great help in the past. I am converting one Hyperion Planning application to OneStream application and would like to know how to use if statement...
Finance
  • FredLucas's avatar
    FredLucas
    6 months ago

    If you need the flag to be data (and do bear in mind that in OS Text attributes can be set differently by Period and Scenario Type and could be maintained via a dashboard / business rule if required), then yes, your approach is correct.

    As Henning mentioned for the GetDataCell you'll want to specify the full POV (except for the Data Unit dimensions that if not specified, will use the ones from the Data Unit POV).

    Here's an example:

    Dim flag as DataCell = api.Data.GetDataCell("V#YTD:A#[Staff Costs]:F#None:O#Forms:I#None:U1#IT:U2#None:U3#None:U4#None:U5#None:U6#None:U7#None:U8#None")

    Another thing you might be wondering is, how can I do some debugging to understand what is happening.

    You can use this function to write messages and print the content of your variables to the error log (that you can then check from (system -> Error Log):

    api.LogMessage($"Flag = {flag.CellAmount}; Data Unit POV - Scenario: {api.Pov.Scenario.Name}; Entity: {api.Pov.Entity.Name}; Time: {api.Pov.Time.Name}")

     

     

SimpleLove's avatar
SimpleLove
New Contributor III
6 months ago

I try the following

Dim FlagDataCell As DataCell =api.Data.GetDataCell("A#Rebate_Flag:UD1#No_Product:UD2#All_Country")

If ((Not FlagDataCell Is Nothing) And (Not FlagDataCell.CellStatus.IsNoData) And (FlagDataCell.CellAmount=1)) Then
     api.Data.Calculate("A#Rebate=A#Sales*0.10",,,,,"UD1#Total_Product.base",,,,True)

End If

I wonder if my approach is correct?

  • Henning's avatar
    Henning
    Valued Contributor II
    6 months ago

    Hi, how many flags do you have? Assuming in your example you have one flag, you will need to define the exact POV for the intersection you store your flag at. Keep in mind that flags should be pulled only to keep the system performant, but that is the next step. Global variables are used for that.

    • SimpleLove's avatar
      SimpleLove
      New Contributor III
      6 months ago

      Henning Thank you for the reply. I do have many flags. Each Country member has a flag and I may have many countries. I think I need to create a data buffer for the Flag and loop through the buffer.

  • FredLucas's avatar
    FredLucas
    Contributor III
    6 months ago

    If you need the flag to be data (and do bear in mind that in OS Text attributes can be set differently by Period and Scenario Type and could be maintained via a dashboard / business rule if required), then yes, your approach is correct.

    As Henning mentioned for the GetDataCell you'll want to specify the full POV (except for the Data Unit dimensions that if not specified, will use the ones from the Data Unit POV).

    Here's an example:

    Dim flag as DataCell = api.Data.GetDataCell("V#YTD:A#[Staff Costs]:F#None:O#Forms:I#None:U1#IT:U2#None:U3#None:U4#None:U5#None:U6#None:U7#None:U8#None")

    Another thing you might be wondering is, how can I do some debugging to understand what is happening.

    You can use this function to write messages and print the content of your variables to the error log (that you can then check from (system -> Error Log):

    api.LogMessage($"Flag = {flag.CellAmount}; Data Unit POV - Scenario: {api.Pov.Scenario.Name}; Entity: {api.Pov.Entity.Name}; Time: {api.Pov.Time.Name}")