OneStream Community

SWilyums

Hello, We have our PLP Workflow step set to "Workspace, Import, Validate, Load". When we click the "Complete" button the Import, Validate and Load step are executed. We have forecast scenarios with settings for "Number of No Input Periods Workflow Un...

SWilyums · 12-14-2022

Hello,Our transformationeventhandler rule adds missing UD1 members to an unmapped parent.The rule works and has been for a few months.A couple of weeks ago I built a business rule which leverages the utitlity "ExecuteFileHarvestBatch".I have the rele...

SWilyums · 09-27-2022

I have a reporting requirement.Projects rollup into customers in UD1. UD6 contains employees.Reporting requirement is to display both customers and projects U1#Total_Customers.DescendantsInclusive. Also display employee U6#Total_Employees & U6#Total_...

SWilyums · 09-15-2022

Hello, In another post user KarlT suggested the use of the UD defaults available for UD1. I manually updated members, and the functionality is exactly what I need. I need to update the field through a data load. UD1 members (Projects), will always ha...

SWilyums · 08-12-2022

I may have a requirement to filter a member list based on the project manager.Whenever data is loaded the PM assignment may change.I am thinking of potential ways to capture the current PM assignment, but don’t know if they are possible.Leverage a te...

SWilyums

Just an update..embarassingly it's my fault. There was leftover data in the Staging table for the 'closed' periods.I cleared it and (knock on wood), it issue is resolved.

SWilyums

This is the line running the import and validate:Dim valTranProcessInfo As ValidationTransformationProcessInfo = BRApi.Import.Process.ValidateTransformation(si, wfChildClusterPk, True)

SWilyums · 12-14-2022

Hello Albert, I did some initial testing. You may have pointed me in the correct direction.In my TEH rule I have:Dim wfProfileName As String = BRApi.Workflow.Metadata.GetProfile(si,si.WorkflowClusterPk.ProfileKey).NameIf wfProfileName = "############...

SWilyums · 11-30-2022

Celvin, any options for parsing where the field values have commas? Can I call a column based on the column name from a complex expression where the data is coming through using a connector rule?

SWilyums · 10-12-2022

I used the code above posted by MattG.

OneStream Community

User Statistics

User Activity

PLP - Complete process not recognizing Number of No Input Periods Workflow Unit

TransformationEventHandler & ExecuteFileHarvestBatch

Alternatives for conditional expansion - are there any?

Updating UD4 Default value in UD1 using extensibility rule

Tagging a project with a Project Manager - Meta Data or Data

Re: PLP - Complete process not recognizing Number of No Input Periods Workflow Unit

Re: PLP - Complete process not recognizing Number of No Input Periods Workflow Unit

Re: TransformationEventHandler & ExecuteFileHarvestBatch

Re: Fields reference in a Connector Datasrc

Re: Updating UD4 Default value in UD1 using extensibility rule