Workflow and Data Integration

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

Hello Everybody,Could you please help to get a solution how to complete all WF forms at once for all descendants. We already got the extensibility rule for this purpose but it's completing all WF steps except forms. The function for form exists (brapi.Forms.Process.ExecuteCompleteForm(si, formPk)), but we are having trouble retrieving the formPk...Would be highly grateful if someone can share an idea how to solve this.Best Regards,Svetlana  

Hello OneStream community,I'm working on a data import process where our source file contains Entity codes with hyphens (e.g., "ENT-BER"), but in our OneStream application, these codes use underscores instead (e.g., "ENT_BER").I'm looking for an efficient way to automatically transform these Entity codes during the import process without having to create individual mappings for each entity.Where in the OneStream configuration should I add this transformation rule? In the Data Source settings, Transformation Rules, or somewhere else?Any guidance or examples would be greatly appreciated. Thank you in advance for your help! 

I want to create a table and columns in SIC, but only the table name is being created. I want to know how to fix this problem. Below is my sample query and code. Dim sql as new text.stringbuilder  Sql.appendline(“Create Table employee(Name varchar(255) not null ,age int null);” using dbconnap as dbconninfo = brapi.database.createexternaldbconninfo(si,”SICconnectionname”) Brapi.database.executesql(dbconnapp,sql.tostring,true) end using

Hello, I have a .txt file to import and the delimiter are tabulations. Do you know if I can manage with it? if yes what do I have to enter in the delimiter field?Thanks Nicolas

Hi All,   Can someone please teach me guide me how can I set the Import validate Load or process the automation and catch the error log with file in the email step by step please.  Thank You so much in Advance. 

i want extract TB input form data for all base entities at once. is there any way to have mass extract? 

Hi All,   I think i have a very simple requirement but i cant seem to get it to work. I just want the API to make use of the entity which the user is currently using in the workflow. The code i now have is as following                    Dim sURL As String = "xxx"                     Dim pkWFunitPk As WorkflowUnitPk = BRApi.Workflow.General.GetWorkflowUnitPk(si) Dim sYear As String = TimeDimHelper.GetYearFromId(pkWFunitPk.TimeKey).ToString                         Dim sPeriod As String = TimeDimHelper.GetSubComponentsFromId(pkWFunitPk.TimeKey).Month.ToString                         Dim sAPIKey As String = "xxx"                         Dim sYearPeriodParam As String = String.Format("?yearPeriod={0}{1}", sYe

We are setting up TXM/RCM and would like to have the workflows in a separate Cube View Workflow Profile.  We have added a suffix to the appropriate scenario types on the cube setup and created the default Cube View Workflow Profile for this new cube suffix.  However, the customer already has some workflows that are being used in the original cube.  Is there any way to move these to the new profile?  We know we can get it to work if starting clean, just not sure if it's possible to do anything with what they already have set up.

Hello! I encountered an issue where the results retrieved from a quick view setting varied significantly at different times. I want to understand why this occurred and how to prevent it from happening in the future. Can you help?  

I have several data feeds from OneStream to different application/db.I am currently trying to pass a parameter from OS which says which application and environment does the data feeds belong to?What is the db table and column name where the applicatiotion  name and  the application environment is stored in?

Hi, When we load two siblings where the Load Overlapping Siblings is set to True. How does the system know what Accounts to clear from Day 1 loads to Day 2 loads. For example, Day 1: Sibling 1 Loads Act A for $10... Sibling 2 Loads Act A & B for $10 Dav 2: Sibling 1 .. No Change.... Sibling 2 Loads Act A only (Replace) for $10 ... How does it know to clear Act B Nothing has been setup regarding Channels for Accounts? Thanks  

Trying to write transformation rules for a delimited TB file and Onestream does not recognize the "dot"/bullet point character. Makes it impossible to do a transformation profile load/extract to load mapping data, as when I load the transformation profile via load/extract the bullet points come through fine. But when the actual TB file is loaded to the workflow, the bullet points are not recognized. Thoughts?    

Does anyone know if the local SIC gateway supports JDBC data sources (SIC Version number if appropriate) and if not is there are workaround for this ?

I have composite rules for my accounts involving 3 dimensions, but when validating the load, if there are missing intersections it would not show me the combination of the 3 dimensions but only one.  is there a way to see the intersection missing involving the 3 dimension?   for example for the following first line  when i double click it to see the source intersection i find out there are many  so my question is if there is a practical way to see all the missing mappings at once?

Is there a way to extract data from a cubeview with the OneStream REST API?  I've tried using the "DataProvider/GetAdoDataSetForCubeViewCommand?api-version=5.2.0" endpoint from the doc via Python - howeverwhen I try to print the result from the response, it doesn't contain data, only metadata ( i.e 'Title', 'HeaderLeftLabel1' etc as seen in the screenshot below)     Im trying to see the numerical values within the cells. Can this be done ?

I am new with OneStream. I need to have the Onestream to connect with our SAP ERP system. The instruction told me to download the following dll and install in Local gateway server. I only find ERPConnectStandard20.dll in solution market not the other dlls. Please help. ERPConnectStandard20.dllNOTE:See Solution Exchange to download. lsapnwrfc.dllicuuc57.dlllicudt57.dllicuin57.dll I also want to make sure these dlls are placed in local gateway server not Onestream app server. Please advise  

Hi to the OneStream Comunity.  Im having some issues since the IT outage that happened a weeks ago.  In this case I  have been using the a ODBC connector to pull from  Netsuite a  failry simple query to pull the Trail balalnce for all accounts. This since July 19th going foward is failing giving me this error: Summary: Unable to execute Business Rule 'SQL_NetSuite_TB'. Smart Integration Connector remote query failed. One or more errors occurred. (A task was canceled.)One or more errors occurred. (A task was canceled.)A task was canceled. Im assuming is a time out issues in the Netsuite side. Still working with them to figure out. To those that have a netsuite connection via ODBC and SIC, are you having trouble from the last two weeks? Out of quriosity, how many rows are you importing? How long is taking the load step? Thanks in advance for your reply.        

Hello,I'm looking for a function to put in a extensibility rule that will be handled via a data management sequence to execute an automatic import in a workflow that uses a connector datasource:   This function : Dim batchInfo As WorkflowBatchFileCollection = BRApi.Utilities.ExecuteFileHarvestBatch(si, fixedScenario, systemTime, valTransform, valIntersect, loadCube, processCube, confirm, autoCertify, False) executes the harvest file, in my case i want it to execute the connector businessruleDoes anyone know how to do this? your help is much appreciated.thank you