Workflow and Data Integration

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 ?

Hi there, I'm looking an example using the "Specific data filters". So far, I can filter the data using the "combinations of data filters" in the previous step as expected, but I need to be more specific on the data combinations to export. Does anyone have used it? For instance exporting: A#(subsetA1):F#(subsetF1) A#(subsetA2):F#(subsetF2) and do not exporting: A#(subsetA1):F#(subsetF2) A#(subsetA2):F#(subsetF1) Thank you Best regards, Carlos 

How do I set up a task in the task scheduler to run as Administrator and not as me? Thanks, Scott  

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.        

This syntax only inserts one line and the line does not have 'entity currency' or 'group currency' description in the [currency] column. Please advise on what the issue could be:INSERT INTO XFC_005_RCP_FinResults ( [PROJ_ID], [PROJ_DESC], [SCENARIO], [TIME], [VIEW], [ACCOUNT], [EOJ], [EOJ_AVG_FX_RATE], [AMOUNT_INPUT], [AMOUNT_FACTORISED], [FACTOR_PERC], CURRENCY )SELECT [PROJ_ID], [PROJ_DESC], [SCENARIO], [TIME], [VIEW], [ACCOUNT], [EOJ], [EOJ_AVG_FX_RATE], [AMOUNT_INPUT], [AMOUNT_FACTORISED], [FACTOR_PERC],CASE WHEN RowNum = 1 THEN 'Entity currency' WHEN RowNum = 2 THEN 'Group currency' END AS CURRENCYFROM (SELECT *, ROW_NUMBER() OVER (PARTITION BY [PROJ_ID] ORDER BY [SCENARIO], [TIME], [ACCOUNT], [CURRENCY]) AS RowNumFROM XFC_005_RCP_FinResultsWHERE CURRENCY = 'Project currency') AS tWHERE RowNum <= 2AND NOT EXISTS (SELECT 1FROM XFC_005_RCP_FinResultsWHERE [PROJ_ID] = t.[PROJ_ID]AND CURRENCY = CASE WHEN RowNum = 1 THEN 'Entity currency' WHEN RowNum = 2 THEN 'Group currency' END);

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   

Hi , Is it possible to use REST API in SIC? If so, could you please provide some examples?  

Hello, We have a DM that receives one set of parameter inputs and runs the business rule for a target entity. We would like to convert this DM to run on multiple sets of inputs for multiple sets of target entities. What is the best setup?  In the example below, users usually select one set of "SourceScenario=|!dl_LAPScenarios!|, SourceEntity=|!dl_LAPEntities!|, SourceUD3=|!dl_SourceLAPParcelForFcstCopy!|, Inflation=|!dl_LAPInflation!|" and select one "E#|!ml_InactiveNoStatus_WF_Entities!|", then launch the job through the dashboard button. We have a situation where they have to run multiple sets like this several times during the month, so we would like to set up an automation so that they can select multiple source to pair with multiple targets, and launch one button to trigger the job for all pairs of source and target.  Thank you, LeAnn  

Hi all,  I'm putting together confirmation rules for various forms, and have got a few working where the explained items clears a check to zero. These checks are isolated to a few accounts, and are pretty straightforward.  I am a bit stuck on creating the rules for the Balance Sheet variance form. The idea is that the users will provide commentary onto all Asset and Liability base accounts where the movement is over 50,000 Euros and over 5%. I started building my rule and ran some tests to see that the logic worked, but I haven't progressed much. See rule below. Sampling it on S_CashatBank account, I know there is a movement of 15,000 Euros in this workflow on one entity, so should pass above 100,000 but fail below 10,000. It fails on both amounts.  Also, where there is 1 confirmation rule looking at multiple accounts, how do people get to show on the confirmation page the different accounts that have failed the rule? Let's say there were 5 base members under I wasn't s

Hi - I am trying to call the DM job using RESTAPI call from Powershell using Basic Authentication . It is an On-Premise Environment and Version is 6.6. I know I can use the task scheduler but I requirement is to use the API. I have a PS Script but it failing and also failing in Postman with 404. The below is the script $User = ""$Token = ""$base64AuthInfo = [Convert]::ToBase64String([Text.Encoding]::ASCII.GetBytes("$($User):$($Token)"))$Header = @{Authorization = "Basic $base64AuthInfo"ACCEPT="application/json"}$ContentType = "application/json"$Url = "http://Host:Port/api/DataManagement/ExecuteStep"$Body = @{SequenceName="Sample"BaseWebServerUrl="http://Host:Port/OneStream"ApplicationName="Sample"}$json = $body | Convertto-JSONInvoke-RestMethod -Method 'Post' -Uri $url -Headers $Header -Body $json Any help would be appreciated. ThanksKrishna  

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 All,  I have a process that exports a dashboard and all of its components to XML.  It then reads through the XML and creates new objects.  The process works when I import the XML by hand.  I was wondering if there is a way to have the code: 1) delete objects if they exist 2) import the XML to create the new objects.    Thank you,Scott

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

Hi team, I was trying to run a reset scenario for a particular time period and encountered the following error:   Has anyone else experienced this issue or have any insights on how to resolve it? Any thoughts or suggestions would be greatly appreciated. Thanks!

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. 

we have 2 import steps on our workflow, the main Budget Import and the Fixed Cost Reallocation import. The main TB is loaded via the budget import and the fixed costs for this TB are loaded to 1 default department. Later, the entities will reallocate the fixed costs to the correct department via the Fixed Cost reallocation import, the reallocations use the same accounts but a different UD6 to distinguish between the 2 imports. But the original fixed costs amounts loaded via the main Budget import are being overwritten. Any suggestions to prevent the original fixed cost amounts be overwritten? we are using separate workflow channels, and we have tried flipping between using True and False on load overlapping sibblings but nothing is working. thanks    

Hi, We are facing a new challenge, as we want to rebuild the entire hierarchy, which has about 6000 members and about 150 parents. In this case we need to rebuild whole workflow hierarchy, is there any way to dynamically create a workflow hierarchy based on entity dimension? Regards, Michal

I'm trying to write a BR to export metadata to csv so that I can export them via a schedule. 1) Is there an easier way to repeatedly export dimensions to csv? 2) How do I look up the property name for a Member  PropertyId or a Relationship PropertyId? I am querying the members and member_properties table and I'd like to get the property name? Thank you, Scott