OneStream Community

MarkBird

Hi We are creating a book that loops over an excel export item to create multiple tabs (see below):Is there any way to add a named range around each exported cube view?Thanks,Mark

MarkBird

HiIs it possible to treat a dash/hyphen as a zero during a data import from a file?Thanks,Mark

MarkBird · 07-19-2023

Hi I always seem to get an "Object reference not set to an instance of an object" in the error log when I execute data loads that use connector rules.The full error message is: ---------------------------------------- Exception Type: Unknown Message:...

MarkBird · 07-12-2023

HiDoes anyone know if it is possible to create a 'Read only' column in a SQL table editor?I have set the column format 'AllowUpdates = False' which almost gives the correct functionality. However, the field is still editable when you insert a new row...

MarkBird · 07-11-2023

Hi allI currently have a UD8 member to do a simple variance to actuals formula, but I was wondering if it is possible pass parameters to the UD8 member formula that this could be more dynamic? My current code looks something like this: Try 'Declare b...

MarkBird

Managed to get it working using the following code: 'Create a new Excel file Dim currentProfileInfo As WorkflowProfileInfo = BRApi.Workflow.Metadata.GetProfile(si, si.WorkflowClusterPk.ProfileKey) Dim folderPath As String = BRApi.Utilities.GetFileSha...

MarkBird

Haha!I have actually been trying to create an excel export using a an extender business rule (using information found on this post - https://community.onestreamsoftware.com/t5/Rules/Create-Excel-spreadsheet-from-Business-Rules/m-p/24231#M2344) but I ...

MarkBird

I did, but we are looking to have a custom named range.We are trying to create a extract book that we can use as an upload template. So we are trying to create custom named ranges that start with 'xfd'.

MarkBird

It's pretty much copy paste from yours.It doesn't get past the file creation line (line 60). Code below Imports System Imports System.Collections.Generic Imports System.Data Imports System.Data.Common Imports System.Globalization Imports System.IO Im...

MarkBird

Hey OmkareshwarI'm trying to run your code, but I get the following error:Any idea what it could be? The path definitely exists...Mark

OneStream Community

User Statistics

User Activity

Add a named range to an excel export item in a book

Data Import: treat a dash a zero

Connector Rule - Object reference not set to an instance of an object

SQL table editor - Read only column

Is it possible to pass a parameter to a UD8 dynamic calc member?

Re: Create Excel spreadsheet from Business Rules

Re: Add a named range to an excel export item in a book

Re: Add a named range to an excel export item in a book

Re: Create Excel spreadsheet from Business Rules

Re: Create Excel spreadsheet from Business Rules