Forum Discussion

Bella_Yu's avatar
Bella_Yu
New Contributor II
9 months ago

Call Data Adapter in BR and Store Results in External Database Table

I would like to export data from existing OneStream dashboard and load it into external database table. I did some research and below is a draft business rule written in Visual Basic. What it does is...
  • MarcusH's avatar
    9 months ago

    In the Business Rules editor if you type:

    brapi.Dashboards.Process.GetAdoDataSetForAdapter(

    it will give you the intellisense for the function which is like this:

    1 - says 1 of 2 so there is another definition of this function with different parameters (ie overloaded)

    2 - says the current definition is deprecated which is why you are getting the warning.

    Click on the down arrow in area 1 and it gives you this:

    which tells you the function needs the workspace id before the workspace/dashboard name.