No valid DataKeys Error
Hello, Has anyone had this error message "No valid DataKeys (Scenario/Time) found in data source". I received this message when importing a "text" file through the workflow. Once import is selected and is at 94% complete prior to validation. I have checked on Scenario & Time to make sure it is proper. I need help on how to fix this.Stage data
Hi all, We have Excel file that we upload into Cube (some tabs from this Excel file). This file also contains additional tabs that we want to upload into stage only and create cube views based on numbers on these additional tabs. Could you please advise where I can find instructions how to create, upload, perform mappings (if necessary), aggregate stage data and create cube views based on stage data.10Views0likes1Commentin which Application Database table User Certified details are available?
Hi Team, I just want to create a report, in that report user can review like (which user has certified the respective entity in the workflow with date and time). i could not able to find in which application database table certification status details will store. can you please help us with the table name. so that we can write method query to fetch the data.Make document attachment required on journal
Hi Everyone, Our business team would like to make it mandatory to attach a document to every journal entry. I know this can be done via a confirmation rule. However, one of our business partners googled this and AI returned the information in the screenshot below so they are questioning why we can't enable the setting referenced. We can't find this in any of the OneStream documentation nor see it when creating new workflow forms or journal templates. Is anyone familiar with this setting?18Views0likes2CommentsWorkflowEventHandler AfterEvent Action
Hello, I am currently working on the Business Rule WorkflowEventHandler to update a custom table when certain tasks are manually completed in a workflow. The scripts shown in the screenshot are located in the section where Case Is = BREventOperationType.Workflow.UpdateWorkflowStatus, with the following condition: If NOT args.IsBeforeEvent Then. I want to trigger the function after the current workflow is fully completed. However, despite testing various syntax alternatives, the function consistently executes before the workflow is fully completed. For example, when I initiate the last step of the current workflow, the function is always triggered at line 141. For context, this issue occurs when the workflows consist of multiple tasks. The final task varies depending on the workflow—it may end with Import, Confirm, or another task. Below are the syntaxes I tested but without success. Could you please help me resolve this issue? ThanksProcessing Blank Columns | Direct Import/Load v Standard Import
Rolling Quarterly Forecasts - to Import 12-month flat files - Several times daily during a cycle - 12-month Matrix Data Source 1. Forecast Q1 '25 flat file - Columns Q1-Q4 '25 = amounts 2. Forecast Q2 '25 flat file a. Columns Q1 '25 = blanks b. Columns Q2-Q4 '25 = amounts c. Q1 '25 to be refilled with actuals - using a DM Job after the initial Import 3. Forecast Q2 '25 flat file - Columns Q1 '25 = blanks a. Direct Import/Load - Wiped out refilled actuals in Q1 '25 = blanks b. Standard Import (Import, Validate, Load) - Kept refilled actuals in Q1 '25 4. Blank Columns - Q1 '25, etc = Prior Periods a. Why do Direct and Standard process blank columns differently? b. How to make Direct process blank columns like Standard? - Keep actuals in Q1 '25/prior periods in OS Data Cubes TY.14Views0likes0CommentsSummary: BI-Blend base data does NOT match any Aggregation Base Members.
We have noticed that BI Blend drop tons of lines during the import and does not log any error. We took few not loaded entries and try to load to table again but getting below error. Just few lines of data. Tried to play around with Agg properties but could not find any solution. Summary: BI-Blend base data does NOT match any Aggregation Base Members.20Views0likes2CommentsExecute a Workflow multiple times with different periods from a BR
I am trying to automate a yearly load of data from a business rule. I want the rule to loop through a set of periods and run a specific workflow for that period. The workflow uses a connector rule in which I get the scenario and period of the workflow being run. THe issue I am facing is that I can get the WorkflowPK for the workflow/scenario/time that I want to run. But when I call BRApi.Import.Process.ExecuteParseAndTransform with that key, a workflow starts, but if I happen to be on that workflow in the session I am running it picks up the POV from where I am at. So if I want my business rule to run 3 periods (Jan - Mar). If I am on Dec, then it runs December every time. Below us how I get the WFPK and call the Dim wfClusterPk As WorkflowUnitClusterPk = BRApi.Workflow.General.GetWorkflowUnitClusterPk(si, wfProfileInfo.Name, wfScenarioName, wfTimeName) '--------------------------------- ' Parse and Transform: '--------------------------------- Dim ImportInfo As New LoadTransformProcessInfo ImportInfo = BRApi.Import.Process.ExecuteParseAndTransform(si, wfClusterPk, String.Empty, Nothing, TransformLoadMethodTypes.Replace, SourceDataOriginTypes.FromDirectConnection, False) Here is my connector rule that gets the scenario and the time; Dim wfPk As WorkflowUnitPk = BRApi.Workflow.General.GetWorkflowUnitPk(si) Dim wfProfileInfo As WorkflowProfileInfo = BRApi.Workflow.Metadata.GetProfile(si, wfPK.ProfileKey) 'Get the WF Time and WF Scenario from API wfTime = brapi.Finance.Members.GetMemberName(si, dimtypeid.Time, si.WorkflowClusterPk.TimeKey) wfScenario = ScenarioDimHelper.GetNameFromID(si, wfPk.ScenarioKey) Dim objTimeMemberSubComponents As TimeMemberSubComponents = BRApi.Finance.Time.GetSubComponentsFromName(si, wfTime) wfFiscalYr = objTimeMemberSubComponents.Year wfFiscalPer = objTimeMemberSubComponents.Month Any and all thoughts are appreciated. ScottSolved55Views0likes10CommentsTransformation Event Handler reviewing pre-transformed (stage) and post-transformation data?
Hi, My colleagues and I are interested in reviewing pre-transformed data side-by-side with the records from post-transformation data, as we're looking to move our transformation process further upstream and we wanted to validate the accuracy of our new transformation process against OneStream's transformations. I've reviewed the examples in GolfStream in the transformation event handler and I understand how to review the stage data, but I'm unsure how to find the matching transactions after they get transformed. Has anyone done anything similar before and would be able to share insights into how I can review the data at the validate and match them to the records in stage? Thanks! AlexSolved46Views0likes4CommentsDelete Cube root Workflow Profile ! !
I am unable to delete a Cube Root workflow for AOP due to an issue related to a workflow profile. The error occurs whenever I attempt to delete the workflow profile. I have already reset the scenario, checked all the data record tables, including the DataUnitCashStamp table, and even used a Custom Calculate BR to set the entity value to 0. I suspect that a form associated with this workflow profile was completed previously, and its log or reference still exists somewhere. Despite thorough checks, I am 100% certain that there is no data associated with this entity in any table. How can i delete the log associated with this workflow profile so i can be able to delete it ? I need to merge AOP and Forecast under the same suffix in the cube property, unless I can delete that workflow profile, i won't be able to do that. I appreciate the help !!42Views0likes1Comment