Processing Blank Columns | Direct Import/Load v Standard Import
Rolling Quarterly Forecasts - to Import 12-month flat files - Several times daily during a cycle - 12-month Matrix Data Source 1. Forecast Q1 '25 flat file - Columns Q1-Q4 '25 = amounts 2. Forecast Q2 '25 flat file a. Columns Q1 '25 = blanks b. Columns Q2-Q4 '25 = amounts c. Q1 '25 to be refilled with actuals - using a DM Job after the initial Import 3. Forecast Q2 '25 flat file - Columns Q1 '25 = blanks a. Direct Import/Load - Wiped out refilled actuals in Q1 '25 = blanks b. Standard Import (Import, Validate, Load) - Kept refilled actuals in Q1 '25 4. Blank Columns - Q1 '25, etc = Prior Periods a. Why do Direct and Standard process blank columns differently? b. How to make Direct process blank columns like Standard? - Keep actuals in Q1 '25/prior periods in OS Data Cubes TY.10Views0likes0CommentsExecute a Workflow multiple times with different periods from a BR
I am trying to automate a yearly load of data from a business rule. I want the rule to loop through a set of periods and run a specific workflow for that period. The workflow uses a connector rule in which I get the scenario and period of the workflow being run. THe issue I am facing is that I can get the WorkflowPK for the workflow/scenario/time that I want to run. But when I call BRApi.Import.Process.ExecuteParseAndTransform with that key, a workflow starts, but if I happen to be on that workflow in the session I am running it picks up the POV from where I am at. So if I want my business rule to run 3 periods (Jan - Mar). If I am on Dec, then it runs December every time. Below us how I get the WFPK and call the Dim wfClusterPk As WorkflowUnitClusterPk = BRApi.Workflow.General.GetWorkflowUnitClusterPk(si, wfProfileInfo.Name, wfScenarioName, wfTimeName) '--------------------------------- ' Parse and Transform: '--------------------------------- Dim ImportInfo As New LoadTransformProcessInfo ImportInfo = BRApi.Import.Process.ExecuteParseAndTransform(si, wfClusterPk, String.Empty, Nothing, TransformLoadMethodTypes.Replace, SourceDataOriginTypes.FromDirectConnection, False) Here is my connector rule that gets the scenario and the time; Dim wfPk As WorkflowUnitPk = BRApi.Workflow.General.GetWorkflowUnitPk(si) Dim wfProfileInfo As WorkflowProfileInfo = BRApi.Workflow.Metadata.GetProfile(si, wfPK.ProfileKey) 'Get the WF Time and WF Scenario from API wfTime = brapi.Finance.Members.GetMemberName(si, dimtypeid.Time, si.WorkflowClusterPk.TimeKey) wfScenario = ScenarioDimHelper.GetNameFromID(si, wfPk.ScenarioKey) Dim objTimeMemberSubComponents As TimeMemberSubComponents = BRApi.Finance.Time.GetSubComponentsFromName(si, wfTime) wfFiscalYr = objTimeMemberSubComponents.Year wfFiscalPer = objTimeMemberSubComponents.Month Any and all thoughts are appreciated. ScottSolved39Views0likes10CommentsTransformation Event Handler reviewing pre-transformed (stage) and post-transformation data?
Hi, My colleagues and I are interested in reviewing pre-transformed data side-by-side with the records from post-transformation data, as we're looking to move our transformation process further upstream and we wanted to validate the accuracy of our new transformation process against OneStream's transformations. I've reviewed the examples in GolfStream in the transformation event handler and I understand how to review the stage data, but I'm unsure how to find the matching transactions after they get transformed. Has anyone done anything similar before and would be able to share insights into how I can review the data at the validate and match them to the records in stage? Thanks! AlexSolved38Views0likes4CommentsBusiness Rule for SFTP
Hi - we're trying to PULL files from an SFTP server. These will be used for our OneStream load. Are there any sample BRs that we can reference to facilitate the file transfer from the SFTP server to OneStream? Are there libraries readily available in OS for this? So far, we have completed the following. 1. Whitelisting of OS IP from SFTP Server 2. Received SFTP server and credentials needed Thanks!4.1KViews0likes8CommentsFX Rate Lock/Unlock Bug
Does anyone else have issues with locking and unlocking FX rates on the Application tab in the UI? I can clearly see some periods with rates locked that I want to unluck, but the system will not let me unlock them. I've tried logging out, ending session, etc.; only then do I occasionally get it to work.1.1KViews1like4CommentsFdxExecuteCubeView unstable when using NameValueBuilder
Hi all, we are using FDX routines to extract high volume data from our cubes for external consumptions and we noticed an odd behaviour when using the FdxExecuteCubeView method with parallel processing and a NameValueBuilder parameter: we wanted to share this with the community to understand if it is an undocumented bug or else. FdxExecuteCubeView advantages: extracting any type of cube data (base/aggregated, input/calculation/dynamic) leveraging parallel processing for the given combinations of entity/scenario/time (e.g. using the FDXEntity/Scenario/Time substitution variables in the CV) Among the FdxExecuteCubeView input parameters, it is possible to define a NameValueBuilder object to evaluate at run-time other eventual substitution variables in the cube view. ⚠️Unexpected behaviour It seems that, when using both parallel processing (e.g. the FDXEntity/Scenario/Time filters trigger multiple CV rendering, with parallelQueryCount option > 1) and a NameValueBuilder object (even empty), the records appended to the output DataTable are repeated (e.g. duplicated) and/or missing. This can be solved using nothing instead of a NameValueBuilder object. E.g. using GolfStream, let's extract data for Houston entities using FdxExecuteCubeView method: in the top pivot, the data adapter leverages FdxExecuteCubeView with a NameValueBuilder input param (see code at the bottom) in the middle pivot, FdxExecuteCubeView without the NameValueBuilder param (e.g. using nothing) at the bottom, a validation cube view [...] '# Name-Value dictionary Dim nvbParams As New NameValueFormatBuilder("Tizio=Caio") [...] '# FdxExecuteCubeView with NameValueBuilder Dim dt As DataTable = BRApi.Import.Data.FdxExecuteCubeView(si, _ workspaceID, cubeViewName, _ entityDimName, entityMemFilter, _ scenarioDimName, scenarioMemFilter, _ timeMemFilter, _ nvbParams, _ includeCellTextCols, useStandardFactTableFields, _ filter, _ parallelQueryCount, logStatistics) [...] '# FdxExecuteCubeView without NameValueBuilder Dim dt As DataTable = BRApi.Import.Data.FdxExecuteCubeView(si, _ workspaceID, cubeViewName, _ entityDimName, entityMemFilter, _ scenarioDimName, scenarioMemFilter, _ timeMemFilter, _ nothing, _ includeCellTextCols, useStandardFactTableFields, _ filter, _ parallelQueryCount, logStatistics) We noticed it long time ago but didn't find any literature on this, we can share the dummy workspace/dashboard if anyone else wants to check this (and there is an easy way to share it, without writing all the code...).34Views1like0CommentsAutomating BAI uploads in Workflow
Hello OneStream Community, Currently working on setting up an automated process to handle BAI file uploads directly into each specific bank workflow in our OneStream application. 1. BAI Parser & Data Source Configuration - We've installed the BAI Parser dashboard to view and manage all imported BAI files. The BAI data source has been configured and initial tests with sample files have been successful. 2. File Transfer & Business Rules - Plan is to automate the transfer of finalized BAI files from our system via FTP to the OneStream file system. This requires a BR to connect with the FTP site and currently developing a BR to facilitate this connection. Once the files are in OS, they'll be imported into the appropriate bank workflow. 3. SFTP Wrapper and Workflow Integration - After the initial FTP transfer, a separate BR will be implemented to securely retrieve and upload the BAI file into the bank workflows. Question: For those who have set up similar BAI automation processes, are there specific best practices or additional BR configurations that you would recommend? Any insight would be greatly appreciated.193Views0likes6CommentsData import from Stage to Cube
Hi, We successfully imported data from stage to cube. But while creating cube views, I am getting fewer records. Not all data is showing up in cube view. I checked the tables in the database; they have all the lines, but the cube view is importing only the first line. What can I do to get all the lines calculated in Cubeview? This account has 1343 records but cubeView fetches only 1st line.