OneStream Community

sudarshan · 05-27-2022

Even a simple globals.getObject("_ex") throws a object reference not found error. Is the use of the globals object prohibited inside a spreadsheet rule?The code:Error log when this spreadsheet rule is used:But if I comment out line number 24, the err...

sudarshan · 11-21-2022

Hi,You can try using this functionPublic Sub ImportCSV(ByVal si As SessionInfo,ByVal FileName As String,ByVal TableName As String) Dim sourceFolder As String = BRApi.Utilities.GetFileShareFolder(si,FileShareFolderTypes.FileShareRoot,Nothing) & "\Syst...

sudarshan · 09-12-2022

Here's the code referenced in the above link.Public Class MainClass Private ReadOnly tableName As String = "XFC_CustomTableView_Example1" Private ReadOnly PKColumnName As String = "PK" Private ReadOnly readOnlyColumns As New list(Of String)({"PK","Sc...

sudarshan · 09-12-2022

You can add new rows back to your table via a table view by using the same principle of looping over the table view object but to differentiate the new rows you use the isDirty() flag in the spreadsheet rule and then using an insert SQL statement to ...

sudarshan · 06-15-2022

Got it, our organization uses a cloud instance so dont think I can access the DLLs unfortunately. But thanks for this

sudarshan · 06-15-2022

Hey John,I can see you are using Visual Studio to write rules, do you mind sharing how to write rules in visual studio I find the br editor a bit cumbersome.Thanks,Sudarshan

OneStream Community

User Statistics

User Activity

Globals object in a spreadsheet rule

Re: Read a .csv file from a file in filestore everyone folder and convet to datatable in a BR

Re: Can you add records to a table via an Excel Table View?

Re: Can you add records to a table via an Excel Table View?

Re: Table View - Tab Addition Automation ??

Re: Table View - Tab Addition Automation ??