Rules
Discuss Formulas and Business rules for your application

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
  • 1391 Views
  • 6 replies
  • 3 kudos

FDXExecuteCubeView cannot export annotation columns

Hi All, I want to ask about my issue on FDXExecuteCubeView. It cannot export annotation columns or columns with text even I have put the parameter includeCellTextCols to True. Here's the annotation column member filter : Fyi, the annotation appears i...

martharany_0-1714106351812.png

Bulk Load DataTable into External Database Table

I call a data adapter and store results in DataTable in below snippets. How can I bulk load OneStream data in this DataTable to external database table? External database connection is ready and working in below method. Using dbConnApp As DbConnInfo ...

Bella_Yu by New Contributor
  • 39 Views
  • 1 replies
  • 0 kudos

Resolved! Extract detailed user info with business rule

Hi, For user maintenance purposes we'd like to extract information like user email address etc, using business rules. I've tried using BRApi.Security.Admin.* but that only seems to support extracting a few of the fields, like name, status and text fi...

JohannJ by New Contributor
  • 85 Views
  • 3 replies
  • 0 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
  • 78 Views
  • 3 replies
  • 0 kudos