Rules
Discuss Formulas and Business rules for your application
cancel
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

[howto] Use "Insert Code" when posting on Forum boards

Hey guys! Just a reminder: if you're going to post code in this forum, please make it easier to read by using the "Insert/Edit Code Sample" button on the expanded formatting toolbar. Here's a short video showing how it works. If you need to edit code...

tmp.png 1c_code.gif
JackLacava by Community Manager
  • 1411 Views
  • 6 replies
  • 3 kudos

Resolved! 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 to call data adapter and store the results. Next s...

Error.png
Bella_Yu by New Contributor II
  • 127 Views
  • 3 replies
  • 0 kudos

Dashboard Extender BR - Get data cell value

I am working with a Dashboard Extender BR and need to get the value of a cell. In another section of the code I am able to get the value of a cell in the V#Annotation but have not been able to figure out how to get the cell value of the V#Periodic. A...

Resolved! Execute sql on data table

Can I execute an sql statement against a data table created in a business rule? I created a table to use in a data set business rule, which returns data to the data adapter. e.g. if I created dt1 using : Dim dt1 As DataTable = BRApi.Database.ExecuteS...

PB by New Contributor II
  • 219 Views
  • 6 replies
  • 0 kudos

Tree view showing full hierarchy

Hi everyone, Thanks in advance for helping. I am new to tree views and trying to get a simple hierarchy (from the account dimension) to show as a tree view. Part of the structure is shown in the screenshot below: I'm using the following Dashboard Dat...

FlorisvdPoel_0-1713207208295.png FlorisvdPoel_1-1713207542288.png
Labels