OneStream Community

SWilyums

Anyone have a suggestion on how to get the register in the Marketplace solutions (CPP, PLP, TCM) to use a parameter set as Member Dialog? We have a lot of cost centers, and it is tedious to scroll down the list.

SWilyums · 03-15-2023

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 re...

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 · 03-16-2023

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 · 03-15-2023

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

Member Dialog Parameter in Marketplace Solutions

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

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