Workflow and Data Integration

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. 

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

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,'  

Is there a way to make a data source process rows that do not have a value in the Amount column? For example,  an import file has 4 rows: Account Name Cost Center Name Amount Cash G&A 5,000 AR G&A 5,000 AP G&A   Retained Earnings G&A 10,000 OneStream will only process the Cash, AR, and Retained Earnings rows becuase the AP row has no value in the Amount column. While a complex expression can evaluate the empty amount in the AP row and retun "0", the Data Sources only processes the three rows into Stage.  

I'm trying to run cubeviews by way of the REST api on Version: 8.2.2.16127 We use PAT tokens for a native onestream user. Suddenly I started receiving meaningless errors about a day ago like so: "An error occurred returning data for 'Cube View RPT_SVC_PbopHierarchyBase', Please check the Error Log for more details. Unable to create database connection. There is no open application"         Does anyone know what this means?  Is it a bug?  Any help would be appreciated.

Hi All, We have a requirement with regard to our data mapping. There are certain data fields which are marked as XXXXX. We want to skip these by using for example X? and X* but that does not seem to work. How can we simply skip every value which starts with and X? Thanks in advance.

Another system on the network is pushing data into OneStream using a REST API. OneStream has a DataManagement group and a step to absorb this data. Is there a way we can pass back a custom response to the calling system?   Thank You for all your help in advance. Indu

I'm trying to convert a 5YP forecasting file into an XFD excel import file. Unfortunately the business currently plans by year and 'scenario' (UD5) on the column so it's not as simple as adding the xfd tokens in. This is a simplified example of the planning file: Has anyone got any prior experience of creating an xfd file with multiple dimensions in the columns? Ideally this would all be kept in one sheet, rather than splitting it one sheet per UD5. 

I am creating a tableview and I would like to pull the timestamp of when all our sub-workflow profiles were locked. I can audit each and get the lock history so it is stored somewhere. We have our workflow profiles set up like this: Jan->Import->IC Matching->CAC->Close Month End (Certify Step)->Other reports->Close reports (Certify Step) Right now I can pull whether each step is locked using "BRApi.Workflow.Status.GetWorkflowStatus().Locked" and can get the timestamp of a profile with a certify step using "BRApi.DataQuality.Process.GetCertification". When I use "BRApi.Workflow.Status.GetWorkflowStatus().LastExecutedStepTime" it pulls a timestamp only for the top step and the certify steps (however in one of our dashboards we use this method to pull the timestamps of all our sub-profiles). This however is still just the last step done and not the actual locking time displayed.   Dim icInfo As WorkflowInfo = BRApi.Workflow.Status.GetWorkflowStatus(si, BRAPi.Workfl

I have added below as improvement suggestion in IdeaStream. In have some cubeviews with page captions that give some details on the content, when I use a dashboard with Tabs in a workflow, the description of the Dashboard component becomes the page caption. Is there another place where I can add a caption? Example: Cubeview has Page Caption:  Outbound Freight Rates Direct Shipments from |CVUD2Desc| |CVScenario| |WFYear| in USD (Incoterms based on customer master data), it shows like this: Dashboard component cubeview has Description: Outbound Freight Direct Shipments and this becomes the page caption like below: I would like and expect to see the page caption as maintained in the cubeview.              

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?  

Dear community, It's an open question, hopefully you can forward this topic to other consultant and active people working on OneStream. The question is : how do you think is the best way to work on restatements ? Use Case : the customer load and input data, then validate them all and lock them, finally they report data for 2022. In 2023, they need to modify some of their input because they have more accurate data, which they will ultimately report on as 2022 (restated) in their 2023 reportings. Waiting for your anticipated feedback and thoughts on Workflow definition for this use case, eventually consideration for dimensions build. Regards,

I have several data feeds from OneStream to different application/db. I am currently trying to pass a parameter from OS which says which application and environment does the data feeds belong to?   What is the db table and column name where the applicatiotion  name and  the application environment is stored in?   Thanks

Hi Everyone. how could I do the following getdacell through the data management, that is to say to obtain those specific departments, because when I leave it in all_departments in the data management it does not go through, then I would like to know what I can do to do things like this in the rest of the POV elements. Dim dataCell1 As DataCell = api.Data.GetDataCell("Cb#HLFPLN:E#41401_41402:C#INR:S#[Forecast 2023M2]:T#2023:V#Periodic:A#611900:F#None:O#Top:I#None:U1#D1309:U2#ALL_PRODUCTS:U3#COUNTRY_RPT:U4#ALL_PROJECTS:U5#None:U6#None:U7#None:U8#None")  

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  

Hi,  right now we have a bunch of Forecast scenarios that have a time span of two years, example:  Jan 24 to Dec 25 Is it possible to lock some inputs in one specific year? The forecast process has a period where some entities are adjusting some keys and they only should be able to do it in the second year (2025), not the first one (2024).  Any idea? 

We have a requirement to have daily backups for our applications for a period of 15 days.  OneStream cloud offers point in time backups up to 7 days and only weekly backups past that period.  I know how to back up artifacts/metadata in OneStream but not sure how to back up data.  Does anyone have any ideas on the best way to create a data back up?

Can anyone tell me why our standard journals are reversing every month?  I thought that you had to select 'auto reversing' type for reversing and standard would therefore not reverse?

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 ?