Forum Discussion

PB's avatar
PB
New Contributor II
2 years ago
Solved

Use data buffer in dashboard data set

Can a databuffer be made available in a dashboard data set business rule? I'm trying to get a data buffer data into dashboard data set so that I can manipulate the output for reporting.   I tried p...
Dashboards
  • JackLacava's avatar
    JackLacava
    2 years ago

    As RobbSalzmann said, you cannot use here any method that expects the api object, since that's available only in rules run by the Finance engine. This is why it doesn't show up in the helper tree, if you're writing a Dashboard DataSet:

    You'll have to stick to BRApi functions instead. Example to do what you want there:

    Dim mName as String = BRApi.Finance.Members.GetMemberName( _
   si, _
   dimTypeId.Account, _
   cell.DataCellPk.AccountId)
brapi.errorlog.logMessage(si, "My name is " & mName & " (Slim Shady)")

    Edit: for best performance, you probably want to cache the results of that GetMemberName in a dictionary, to avoid too many lookups that might end up hitting the database.

     

     

PB's avatar
PB
New Contributor II
2 years ago

Thanks for the reply.  

It seem like I'm not able to log the members themselves. I.e. I can output the values, but not the member names.

 

JackLacava's avatar
JackLacava
Community Manager
2 years ago

As RobbSalzmann said, you cannot use here any method that expects the api object, since that's available only in rules run by the Finance engine. This is why it doesn't show up in the helper tree, if you're writing a Dashboard DataSet:

You'll have to stick to BRApi functions instead. Example to do what you want there:

Dim mName as String = BRApi.Finance.Members.GetMemberName( _
   si, _
   dimTypeId.Account, _
   cell.DataCellPk.AccountId)
brapi.errorlog.logMessage(si, "My name is " & mName & " (Slim Shady)")

Edit: for best performance, you probably want to cache the results of that GetMemberName in a dictionary, to avoid too many lookups that might end up hitting the database.

 

 

  • PB's avatar
    PB
    New Contributor II
    2 years ago

    Excellent! Thanks - that works!