Workflow and Data Integration

hey All, I have request to dump out all the imported source documents to a central location. Not sure if it is possible. Looking for some information on Where these files/documents are stored within OneStream is there a way to export these files using a BR              

Hey all, Since Onestream 6.6.0 there should be the option to trigger a Submit Workbook with VBA using SubmitSetXFFunctions. However, I can't get that to work. We're using Onestream 7.0 and the following VBA-code:   Sub SubmitWorkbookToOnestream() Set xfAddIn = Application.COMAddIns("OneStreamExcelAddIn") If Not xfAddIn Is Nothing Then If Not xfAddIn.Object Is Nothing Then Call xfAddIn.Object.SubmitSetXFFunctions End If End If End Sub    If I run this I get an 'Object doesn't support this property or method' error. What am I doing wrong?

Hi, this was already asked in an old post, but there was no solution given.Where is the Workflow Audit information (like the one in the picture) stored? For context, I know that Lock History information can be retrieved using the WorkflowLockHistory Data Adapter method, and it's also stored in the WorkflowLockHistory application table.However, I'm having trouble finding the Workflow Audit information that isn't part of the Lock History. Specifically, I'm looking for details on who performed each workflow step, which is displayed in the workflow audit window but not returned by the WorkflowStatus Data Adapter method. Can anyone provide guidance on where to find this information?

Hello,I am writing a SQL Query that references tables in different databases, one that exists in the External database (BI Blend) and one that exists in the Application database. I am having trouble setting up my data adapter to allow for pulling in both tables to perform a Union, as I need to specify the Database Location. Is this possible?

Hello, everyone, Could you please advise is it possible to see workflow status on each entity (if data was loaded or not, if there are any validation issues etc) in one report?  

Hi All,We currently have BiBlend set up to use all 20 attributes. We're considering reusing two attributes to load data from different columns (these attributes are currently used but are no longer needed). Our plan involves renaming these attributes in the Cube Settings and updating the data source.Does anyone know if this is possible? Are there any restrictions or limitations on how attributes can be used or modified after the initial configuration?Thanks in advance for your insights.

Hi all,  I'm after some guidance for a capex form that I'm currently developing. Simply, it's a form that takes the current month closing balance (BS accounts) less the prior month closing balance, and need to categorise these movements.  At the end of FY24, 2 entities liquidated (LQE) and transferred assets to a new entity. In the entity dimension, it's timestamped in the 2 entities as no longer in use from FY25 M1 onwards. So for FY25, there is no form to fill in for the 2 LQE's but there is for the new entity. However, at group level, it shows the FY24 balance with 2 LQE's and no balance for new entity, and FY25 is no LQE's, just the new entity. Because the setting means the 2 entities are no longer part of the group, it's no longer showing in the movement columns. See below.  The real movement for the month to be explained is -33k, but the calculated movement ignores the 2 LQE's and just shows the new entity with +164k addition. Any ideas how I can develop this form

When loading data through batch file, does transformation event handler invoked the same way as running through manual workflow steps? Also, how can I execute Workflow (import->validate->load) through batch?

Hello OneStream Community,I'm working on how to implement a REST API in OS, but i'm not sure to understand all the steps, i've already read the documentation and i've found it very hard to understand, can anyone please explain how can we implement it in OS what are the steps to follow, i started by downloading and installing POSTMAN for the tests but i don't know what should do i do after, please any help will be much appreciated. I'm also woundering if there any data management that should be used for this Thanks and merry christmas.

I have come across a validation error that is kind of vague. I created a new entity, confirmed it is setup the same way as its sibling, and added it to my transformation rules, but my validation step kicks out an error. Any ideas?  

Hi Everyone. I had a Business Rule that checked the Workflow table to see if a scenario was blocked, but it always showed WFProfiles as blocked. I don’t know where this information is coming from, as those WFProfiles were unblocked in the environment but appeared as blocked in the table. How can I verify this information?  

I'm unable to import from SAP, i have an error message Summary: Unable to execute Business Rule 'SAP_TB_ALL'. Cannot call classic RFC API. See help for details.Please put a recent 64-bit version of librfc32.dll in your System32 folder (typically C:\Windows\System32).See SAP note 413708. Please make sure you have installed Visual C++ 2005 SP1 ATL Security Update (x64). Unable to load DLL 'librfc32.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E) how to fix this issue?  

 Hi All,I'm encountering an error while trying to import data:"No valid DataKeys (Scenario / Time) found in data source. Review the source data load processing log and check one-to-one transformation rules to ensure that you have created proper Scenario and Time dimension rules for this data source."I've attempted both options for the time dimension—applying 'Datakey Text' and then assigning the Time field, as well as using the 'current Data key time' options—but it’s still not working.For reference, I've attached the relevant code:```csharpvar fields = new List<string>{"ACCOUNT","ACTUAL","Time"};return fields;string wfYear = TimeDimHelper.GetYearFromId(api.WorkflowUnitPk.TimeKey).ToString();int wfMonth = TimeDimHelper.GetSubComponentsFromId(api.WorkflowUnitPk.TimeKey).Month;string periodName = $"{wfYear}M{wfMonth}";var sql = new StringBuilder();sql.Append("SELECT ");sql.Append("ACCOUNT, ");sql.Append("ACTUAL, ");sql.Append("Time ");sql.Append("FROM [tablename] ");sql.Append

I cloned an existing connection that pulls the Scenario and Date from the workflow.  The new connection is requiring me setup a  New Scenario Transformation rule that is basically Budget --> Budget and time rule 2024M1 --> 2024M1.  The connection I cloned doesn't require the additional rules and was pulling Actuals.  All my Data Sources, Scenario, and Workflow settings seem the same.  Any suggestions on what I am missing?  I don't want to maintain the time rules, so that's why I'm trying to see what I'm doing wrong.

I am trying to copy data from external database to OneStream SQL table. I am trying to achieve this by using Extensibility Rule. Can someone help me with the rule to save data into Onestream table.

Hi Everyone,I am actually trying to make a dashboard that let users execute different sequences from data management without accessing the Application tab so i am using a dashboard with a combo box that lets you choose the step you want  and a button to execute it.The problem is that i don't know how to send to the button the sequence i chose from the combo box and how to make so that the button can execute any sequence i chose without preparing the parameters in advance like we do in the data management tab where we run then choose parameters we need. I already linked a parameter containing the list of steps to populate the combo box but i don't know how to send the selected step to the button to run it. Thank you.

Once my SIC Gateway is online, how can I apply the data sources to specific workflow profiles? The "data source name" shown on the Custom System Configuration is not one of the available options to select for the workflow profiles.

I'm trying to do a Composite Rule to Bypass an account if it's part of a specific Scenario?  Can you use Scenario as part of an Account Composite Rule?  This is my statement "A#[525300]:S#[Budget_Dist]" that isn't working.

Hi All, Has anyone integrated Azure data warehouse into OneStream kindly walk me through the process. How are databases integrated into OneStream  need help ASAP

Greetings OS Integrators, Going with v8 and SIC for integrations, it is not an option to have 3. party assemblies added to the cloud environment. I am building a integration to push data from OS to an Azure Blob Storage location, and in this case I want to use some of the nice nuget packages (assemblies) that provides an easy way to do this, hereby authentication. I therefore want to use the following assemblies for my solution, that will run on SIC as a Smart function: Azure.Storage.Blobs Azure.Storage.Common Azure.Identity Azure.Core As such, I am able to compile my Smart Function against an existing SIC gateway, and able to call the function from within OneStream. But, issues lies in required other dependencies within my code-logic. So my questions are: Are Smart Functions compiled against .NET framework 4.8? Looking at the assemblies already available within the SIC folder, I can see that both Azure.Core and Azure.Identity are there. Can I reference those by just using an import

I am getting error "Unable to access database table 'ABC'. Database table 'ABC' does not exist". If we create a table with extensibility. Does it solve the problem?

I have a form template profile containing 2 form template groups. Each template group has a selection of CubeViews.Template Group A has Access group = Everyone. Template Group B has Access group = SuperUser. The template profile has access security = Everyone (although it doesn't seem to matter what is in here). All forms are visible and all forms can be completed as long as the CubeView group access group is low enough.The form template profile is attached to a workflow form profile. The workflow form profile access group = everyone.I had hoped that the list of forms would be restricted for everyone, with only SuperUsers seeing and executing a slightly longer list of forms (ie Form template group B).I hope I have made sense. The only way I seem to be able to restrict access is by applying CubeView Access security. It looks like all Form security settings are being ignored or overridden by some other security. Can anyone throw any light on this, please?

I'm having trouble getting my data files to import into the correct quarter of the workflow. Whenever I load the data into the Q2 import of the workflow, it removes the Q1 data and adds the Q2 data to the Q1 import of the workflow. (screenshot attached)  I am having a hard time finding the correct settings to allow me to load the quarterly data files into each quarter of the workflow. Any assistance would be greatly appreciated. Thanks!  

I want to create a yearly LTP scenario of type (scenario1) where input frequency is yearly and data can be input for like below I want to restrict this scenario for data input for particular years like, FY26-FY36. (with 1 entry a year) What setting can I do- to make this scenario available for input only for 10 years.  

Hello, First time posting question here. I'm a developer new to the OneStream.   I'm trying to run a remote business rule to pull a file that stored on Local Gateway Server. The idea is to have the content of the data file returned to OS in bytes[].  I have extender rule  and SIC Function rule. After I executed the Extender rule, I printed out a few things from the returned object and looks like there is an exception when executing the remote rule. Could anyone give any pointers? Any help is appreciated!    Error Returned BRApi.ErrorLog.LogMessage(si,objRemoteRequestResultDto.RemoteException.StackTrace) ' Returned -> ' at OneStream.Shared.Wcf.RelayHostInfo.InvokeRequest(IRemoteRequestBase xfRequest) ' at OneStream.Shared.Wcf.OneStreamRelayAgent.SendRelayRequest(IRemoteRequestBase xfRequest) BRApi.ErrorLog.LogMessage(si,objRemoteRequestResultDto.RemoteException.GetBaseException.Message) ' Returned -> ' DirectConnection BRApi.ErrorLog.LogMessage