Workflow and Data Integration

Hi all, I'm trying to find a way to extract comments and text inputs using a data management job. OS doesn't let me select V#VarianceExplanation member in the dataunit section. Error processing Data Management Step 'ExportComments'. Non-numeric View member 'VarianceExplanation' cannot be used in data filter Any help is appreciated.

I have a client that has a app with 7 years of data in it.  They would like when we get to the end of 2024 to chop off the last year in the app so that in only ever has 7 years of data in it and archive that data to another app.  Just curious on how people are doing this with chopping off a year and putting it into another app.  Thanks

Dear coleagues,  when I need to change transformation group within multiple transformation profiles I wanted to export XML file, do the change and then reupload it. Unfortunatelly it add new group but does not remove the old one. I guess the merge approach it to blame.  Do you know a way how to do this excersise in more sophisticated way than running a clicking derby? Thanks for help!

Hello OneStream CommunityDoes anyone know how to get the data source time to use the WF time instead of the start Time range scenario . The import data source is using the start time instead of the WF , POV time. Thank you

HI All, I have been asked to see if OneStream can take a feed in to update the metadata. We are looking at having a Master Data Management system which will be used to update all the downstream systems. SO new accounts, entities or dimension members get created in this MDM system and then ideally gets automatically updated into OneStream (either mapping tables or Metadata hierarchy updates). Has anyone tried to do this ? Thanks Tahir

I am looking to implement an incremental data extraction feature for our cube data. Specifically, I need to extract all data from inception and continue to do so on a quarterly basis, including any updates to previous quarters. Any ideas or best practices on how to achieve this effectively would be greatly appreciated.

Is there a way I can check my source records before importing data into a stage? If I am in a workflow for Import, Validate and Load, Even before the data is imported, I would like to check my source record for a condition like if it is less than a particular value. Only if the condition satisfies, I need to proceed to import else stop the workflow. If someone has done it, can you share the setup and code for the same. Appreciate your help!

Is there any way to read data from Onestream cube (.csv/.txt/Data Table) and push it to external system using external Web API connection (Not Onestream Rest API, SFTP)? Is it possible to do it using SIC?

We tried to copy from test environment to development environment which failed. we emailed Onestream who gave the following response: 'Thank you for logging this request with us. It looks like the app copy failed out due to a lack of storage space in your Prd1 environment. You can view the applications in your Prd environment by using the System Diagnostic tool. The latest release of System Diagnostics (PV620 SV200) now allows cloud customers to see up-to-date information on all Application Database sizes and Elastic Pool used space from within the OneStream application, under Environment Analysis reports. This is now available on our Solution Exchange website: (https://solutionexchange.onestream.com/dashboard/home/browse)We can provide 2 potential solutions with this:1. Delete any applications that are no longer in use. You can do this by entering in a Service Catalogue request.2. Increase storage limit (which can incur costs)   We have couple of questions on the above: 1) how mu

How are the Debit and Credit inputs treated when using an account set as Account Type Balance on a Journal?  Are debits positive and credits negative?

Hello. When importing an application from an older version of OneStream XF into the latatest version of OneStream XF in CloudI received an error message regarding the "DataManagement.xml" file. It wasn't admitting the <dataManagementProfiles> section of the file. So I had to remove it fromt he XML file to load sucessfully the application. Then when I entered the application (using the OneStream client), I saw in the screen that we didn't have a section for DataManagemente Profiles (neither a button to craeate them). Are they still in use? (so we should open a Ticket to get the issue checked by OneStream Technical Support)Or are they an outdated type of artifact that no longer exist in the newest version of OneStream XFSupport?Thanks in advance

I am using a below code to display Intersection Error. The code works perfectly fine- except for one thing. The problem is when the error is - Invalid Member Name.Entity,2010 It only outputs- "Invalid Member Name" (may be because it gets period) Is there a way to update below code to also show Entity ,2010-  instead of just 'Invalid Member Namr' ***************************************************************** Guid gWFid = si.WorkflowClusterPk.ProfileKey;                     int idScenario = si.WorkflowClusterPk.ScenarioKey;                     int idTime = si.WorkflowClusterPk.TimeKey;                       using (DbConnInfoApp dbConnApp = BRApi.Database.CreateApplicationDbConnInfo(si))                     {                    

We have lot of workflows by entities, for each entity we need to add another workflow step(Import). and each workflow has different security groups. here, how can i updated the new workflow step at a time at one go. Can you please suggest us some easy ways to update the same. Thank you, Shiva Prasad.

Hi all, We have experienced that in our application, at specific times of high workload where many processes are executed simultaneously, some tasks in the workflow that involve loading data into the cube remain in the ‘Running’ state for hours. I wonder how to find the cause of this issue, which seems to be a performance problem during periods of high workload. Thank you.

Does anyone know how to display Workflow status in a Cube View or a Dashboard? I would like to create a report that would show the status of a particular step within a subset of workflows. I am thinking of a more formatted presentation of the information available in the "Dependent Status" grid available in the "parent" workflow "Certify" grid. More specifically I would like to create a report showing the status of all "Flash Report" steps in the attached screenshot. Thank you in advance and best regards. Yan

Hi,  I'm having difficulties trying to specify the Parent Filter in the data management step and was wondering if anyone has encounter this before and can suggest a better approach. I'm creating a data management step to trigger custom calculate elimination rule and trying to specify multiple parent members however it doesn't seem to work properly. When debugging the BR, i can see api.pov.parent is returning nothing whenever multiple parent members are specified in the parent filter of the Data Management Step.  It does work properly when a single parent member is defined, but this means I need to create multiple data management steps to triger the same calculation.  Below is the illustration of this scenario. Appreciate all the help/advise i can get. Thank you.

Hello,Our environment is OS Cloud 7.4 version.I am trying to explore if it is possible to copy OS internal App table data to external DB thru SIC? I know there is way to extract OS app table data and save to 'External' DB table with  "BRApi.Database.SaveCustomDataTable" command passing "External' DB location as a parameter. We currently extract/read from "Custom" DB connection thru SIC into OS Cloud no problem, but now I want to data to go out bound from OS DB to SIC "Custom" DB.Thank you.

When loading data through a workflow- and when "Load and Transform" is clicked-> we can get Import error like below. Where are these import error stored? I need to put the contents of below error in an email.     Where are these errors stored. 

Hi, I need to make sure the first tab updates when the data changes on another tab after saving.  I tried to add the refresh on that save button and redraw that component from the first tab .   Is there a way to make this happen with the tabs.  I have to currently refresh the page in the upper right when I go to the first tab. Thanks, Sharon

What operation triggered in Transformation Event Handler when import process fails. For example, when Validation mapping fails: Operation Failed is Transformation.ValTrans.FinalizeValidateTransform   For example, when Validate Intersection fails: Operation Failed is Transformation.ValIntersect.FinalizeValidateIntersect   I am looking for similar event name when Import Process in workflow is failed.

Hello - recently in our Production environment a new user inadvertently locked and certified all of the workflows used for variance commentary before they were completed for the period. These workflows are descendants of the top workflow for the actual scenario type. We were eventually able to unlock and un-certify them, but going forward, is there a way to prevent this from occurring again without assigning specific user groups to each individual workflow? Right now, all of the users that enter variance commentary are in one user group, because their property assignments change on a regular basis, and it would create a maintenance headache for our admin team having to keep up with the much larger user group population. 

When loading data to cube, through workflow step.  We can get Load error as below: Where are these load errors stored? I need to put these errors in an email content

Is there any documentation available for the backend tables in OneStream? Many of the tables are composed of keys pointing to other tables, and it can be challenging to discern the relationships between them. Additionally, understanding what each column in a table represents would be helpful. For instance, in the vStageSourceAndTargetData view table, columns like Wfk, Wsk, and Wtk essentially form the Workflow POV, but this isn't explicitly stated anywhere, making it difficult to interpret.

Hi, I am trying to access a file stored in Azure File Storage to import in the cube, but I need help to do that if I try using the REST API as the namespace Microsoft.Azure or any other Azure related namespace, as they are not available in the OneStream library.Has anyone encountered the same ?  Any better approach to achieve the desired outcome ? Thank you for your help 

Hello!We are using the OS API to pull data to ADF using data connectors and cube views.  This has been working fine until we upgraded to 8.2.2 a few weeks ago.  Here's the error I'm getting in ADF.  Our URL actually didn't change.  Has anyone seen this or know how to fix it?  THANKS IN ADVANCE! Operation on target Copy Actuals from HTTP Endpoint failed: ErrorCode=HttpRequestFailedWithClientError,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Http request failed with client error, status code 400 BadRequest, please check your activity settings. If you configured a baseUrl that includes path, please make sure it ends with '/'. Request URL: https://xxx.onestreamcloud.com/onestreamapi/api/DataProvider/GetAdoDataSetForAdapter?api-version=5.2.0/.,Source=Microsoft.DataTransfer.ClientLibrary,''Type=System.Net.WebException,Message=The remote server returned an error: (400) Bad Request.,Source=System,'