Can ERP transactional data be loaded into OS?
Hi, my company's OS data integration with the ERP system has been set-up to load monthly TB's into OS and for transactional tables to sit outside of OS but with the ability for OS to query and drill-back to view transactions. The transactional drill-back function is limited in that a drill-down first needs to be performed to get to the detailed dimensional intersections at the lowest UD level before a drill-back to view transactions (at that precise lowest level set of dimensional intersections) can be run. It is therefore easier to use a stand-alone BI viewer outside of OS to view transactions. Am wondering - is it possible to load ERP transactional tables into OS (this may contain millions of rows spanning multiple years) and for OS to then display transactional level detail across higher-level roll-ups (e.g. viewing transactions across a cost centre parent rather than only at an individual cost centre level), or even display transactional detail in quick views, essentially making OS have similar functionality to a BI viewer?
Error Message: A column named 'AccountType' already belongs to this DataTable.
Has anyone seen the above error message or have thoughts on what it might pertain to. I am trying to load a delimited file to a BI Blend table. My test file only has 5 records. When I import the data it gets to 12% Complete - Translating Cache step. The only place I can find a reference to this field is on the file suffixed with '_RS'. BI Blend definition Error Msg:
Can we parameterize or set a value for the additional "options" for the Data Export step in DM?
Hello OneStream Experts, I was wondering if it is possible to set a value or retrieve a value (using XFGetValue) from user input for the "options" in the Data Export of a Data Management job while developing an Extensibility Rule. The goal is to give end users control over Data Exports without granting them access to the Application tab. Below is the code I developed to execute the Data Management sequence. I noticed there are a list of options that can be leveraged; however, I have not been able to set any values for these options. Any help or suggestions would be greatly appreciated. Thanks!
Unable to unlock the Work Flow channel
Hi Team, WhatIF_R&O_Adj is a Workflow Channel, and it is assigned under "Financial_WeeklyProcess" - "Base_Input Profile" (Refer the 2nd screen shot). when we are trying to unlock the channel. getting pop up like "'mnuWFChannelLockWhatif_R&O_Adj' is not a valid value for property 'Name'." and it is not listed under WF channel list(Please refer 3rd screen shot). Kindly help us to resolve the issue. Thank you, Shiva Prasad.Is there guidance on the setting for the number of parallel executions for Harvest Batch Loads?
When using the BRAPi.Utilities.ExecuteFileHarvestBatchParallel function in an Extender BR, does anyone have any guidance and/or opinions on the proper setting of the parallelBatchCount parameter? My understanding has always been to set it to a maximum of the number of CPUs - 1 , available for the server performing data management or batch load processing.
