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

Writing Annotation data in a Finance Rule (like SetDataBuffer)

Is there a way, in a member formula or Finance BR, to write annotation data back to the database in bulk?In OneStream rule writing, it's best practice to limit the number of times you are writing data back to the database (ideally only one SetDataBuf...

PhilB by New Contributor III
  • 1828 Views
  • 7 replies
  • 1 kudos

Data Buffer FilterMembers() with Empty Cells

Does the api.Data.GetDataBufferUsingFormula("FilterMembers(...)") only get cells that have values? Is there a way to create a data buffer with empty cells? Use case: We need to to cycle through an account hierarchy and populate each base account with...

Resolved! Create Excel spreadsheet from Business Rules

Does anyone know if you can create an Excel spreadsheet from Business Rules? I do not mean a csv file - I need to create multiple sheets. The OpenXMLBuilder object doesn't seem to have anything with writing files. I don't want to use a third-party ob...

MarcusH by Contributor II
  • 6128 Views
  • 25 replies
  • 0 kudos