OneStream Community

vmanojrc30 · 04-20-2023

Please provide any guidance or knowledge documents on how to access data stored in table data manager tables via Finance Business rules.

vmanojrc30 · 03-31-2023

I have a OS Batch File Load Setup which loads Multi Year and Multi Period Data(3 Years).I have an Extender Business Rule that creates the Batch File one period at a time and calls BRAPi.Utilities.ExecuteFileHarvestBatch to execute the data load one p...

vmanojrc30 · 03-14-2023

Is it possible to calculate slope, Correll and Intercept for a given factors vary by 12 periods using OS Finance Rules? If so, what are the libraries, I need to Import? Appreciate any suggestions how I can implement this in OS.

vmanojrc30 · 02-28-2023

With SQL Connector as Data Source, can we automate to Import, Validate and Load multi period and multiyear data (Ex: Jan 2023 till Jan 2026) in such a way the Import, Validate and Load occurs one period after the other sequentially?Query execution ti...

vmanojrc30 · 02-27-2023

I am setting up a Workflow with a SQL connector data source. I need to be able select a range of periods (start and end period) within the SQL query to extract the balances for multiple periods and load the same to OS cube. Users should have a provis...

vmanojrc30 · 04-13-2023

I removed the piece of code related to sleep and its still behave the same way. Data loads freeze at 10th period. However when i run the data management job only for the Period 10 or Period 12 it completes successfully within 5-10 minutes. These peri...

vmanojrc30 · 03-31-2023

Connector BR: Private Function GetDBBudget_Import1SourceDataSQL(ByVal si As SessionInfo, ByVal globals As BRGlobals, ByVal api As Transformer) As String Try 'Create the SQL Statement Dim statement As New Text.StringBuilder Dim wfScenario As String = ...

vmanojrc30 · 03-31-2023

Extender Rule: Imports System Imports System.Data Imports System.Data.Common Imports System.IO Imports System.Collections.Generic Imports System.Globalization Imports System.Linq Imports Microsoft.VisualBasic Imports System.Windows.Forms Imports Syst...

vmanojrc30 · 03-15-2023

Thanks for your response.Yes, the linear regression calcs like Slope, Correll, Intercept are currently done in Excel however we are moving from Excel to OS.So we need to automate these calcs in OS using Business Rules. Period/Amount EntityP1P2P3P4P5P...

vmanojrc30 · 02-27-2023

Hi ChrisThanks for your response. With regards to next steps after import (validate and load) is it possible to run them for multi period at one time? I dont beleive this can be configured in Workflow setup (similar to Import) however could this be d...

OneStream Community

User Statistics

User Activity

Access Table Data Manager from Finance Rules

Batch Loads Freeze

Slope, Correll and Intercept Functions

Multi Period and Multi Year data Load Automation

SQL Connectors with Multi period selection dynamically

Re: Batch Loads Freeze

Re: Batch Loads Freeze

Re: Batch Loads Freeze

Re: Slope, Correll and Intercept Functions

Re: SQL Connectors with Multi period selection dynamically