Workflow and Data Integration

Hi, Does maybe anyone know how can I get a status of a single process in workflow from BR? I was trying to use method GetInputWorkflowStatusForMembers, however I can't select any specific process there: Dim wfInfo As WorkflowInfo = BRApi.Workflow.Status.GetInputWorkflowStatusForMembers(si, cubeId, entityId, scenarioId, timeId) I need this check in Extensibility Rule as it will be ran using DMJ. Many thanks!

Hi all, I am building some form templates for my workflow profiles, and have a query regarding the best way to setup the form template and entity parameter (setup below):   I would really like to be able to have users navigate between the forms, and the entity POV that they have selected in the parameter remain constant between forms. As it is now, when they move from a form, it always goes to the top entity in the list. I have some workflows with 20+ entities, and it may be that someone is working on the forms for just 1 entity at a point in time so has to re-select the entity each time. I've seen a "Sticky POV" idea raised on IdeaStream, but that hasn't moved since 2022.  I have seen mentioned at Splash that there's an option to have the user state pov remain through a business rule, but haven't seen anything other than a SetUserState? And I'm not really sure how to write the code and apply it here.  Any advice would be really helpful.  

Im being given an account consisting of 4 numbers, a - and 4 more numbers like:5150-0707. Im using range TR to map to the OS accounts, so for example 5000~5050-0304 works fine, but if i put the ~ after the - like this: 5000-0001~0304 it doesnt work any more. is there any way to fix this and make it work?

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