Workflow and Data Integration

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?  

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   

I have the routine below that exports data from a datatable to a file.  I am writing to "Documents\Users\" & si.UserName.   The file gets created correctly; I am now trying to pick up that file with a business rule.  I am not familiar with all of the XF file functions.  I need to ftp that file to a remote server.  How do I go about getting the full path the Document\Users folder from another Business Rule. Public Function DataTableToFile(ByVal si As SessionInfo, ByVal dt As DataTable, ByVal strFilePath As String, ByVal listColToSkip As List(Of String), ByVal Optional strSeparator As String = ",") As XFFileEx Dim strDt As String = Me.PrintDataTable(si, dt, strSeparator, 0, False, listColToSkip, """") Dim bytes() As Byte = System.Text.Encoding.UTF8.GetBytes(strDt) Dim fileinfo As New XFFileInfo(fileSystemLocation.ApplicationDatabase, strFilePath) Dim xfFile As New XFFile(fileinfo, String.Empty, bytes) BRApi.FileSystem.InsertOrUpdateFile(si, xffil

Our customer has been importing ANSI-encoded files to OS, which contains spanish characters, as 'ñ' and accents, for years. These characters were recognized properly until OS 6.8. But after migrating to 8.2.2, they are no long: 'España' is shown in the workflow as 'Espa�a'. This is a big issue for the customer, as they use the workflow stage tables for OS reports and export that data to a Data Warehouse. We have tested encoding a file as UTF-8 and worked, but changing the encoding the files is not a good solution for the customer as they load files from many different sources. This looks related to the migration: Is there any way to load ANSI-encoded files without this problem?

Hi , I added a row from a different table to the Drill back table, but it's also showing up on page 2. Does anyone have any idea why? Thanks,    

I have some BIBlend tables I have created during testing of a Workflow. that I want to delete/Truncate Resetting the Scenario doesn't do it. Do I need to do it programatically or via a Data Management job? When I try this it tells me that the SQL is not safe (I have tried with TRUNCATE TABLE and DELETE) Thanks Steve

Anyone aware if the Smart Connector solution supports a way to access a SMB fileshare on the clients network? Use case is that client uses a file-share for flat-file exchange

Hi Everyone. I have some entities that have text at the end, for example “_Test”, and what I want to do is that in the data management I can remove the text at the end to use the original entities.Example: 12001_12000_Test to 12001_12000 I want to remove that in the section that is in the image, so I wanted to know if it is possible or if there is a solution so that the api.Data.calculate and api.Data.SetDataCell use that entity without the “_Test”.  

Hi all,I have a data management step which is of "execute business rule" type, and make use of parameters so that when I run it, it prompts me to select the parameters. The parameters are "member dialog" parameters.Now, since I want users to be able to run the step without giving them access to the Application tab, I am creating a dashboard that has a button in it to run the data management step.I have built some combo boxes that use "member list" parameters, created a data mng sequence that contains the data mng step, and a standard button which runs the data mng sequence. How do I pass the combo boxes selection to the data mng sequence?Thank you

We have created a book that when run outputs an Excel file that is 67 tabs.  It can take 20+ minutes to run on our desktop Clients and many times will time out if we are at home vs. in the office.  Anybody ever created something that would allow this book to run on the server and save the output to the Application Folder.  That would allow it to run using the Server resources and only impact our laptops when downloading the file, which should be manageable.