OneStream Community

OS_Pizza · 05-04-2023

After an application copy , We usually go to the newly copied application and disable/delete the tasks.TIP-> You can press CTRL+A or can select multiple task by pressing shift and then Delete it.It might be that you already know about this, but just ...

OS_Pizza · 04-14-2023

I have a extensible rule called "A" to update my Derivative transformation rule group. Now during the workflow execution , i want to run A just before the transformation step.Requirementstep1- Load the file.step2 - Before running the transformation ,...

OS_Pizza · 04-06-2023

1. I am trying to export as trx for the derivative rule with a business rule in it. 1a. Once it exports, the exported file doesnt have the business rule name in it. (OR)2. Exported the rule as xml via application export and then opened it in the exce...

OS_Pizza · 03-30-2023

SourceA10000_0TargetA10000How can we achieve it in different ways?1. Connector SQL query -> Using this in the sql query Select left(Account, len(Account)-2) leaves blank rows in the import step.2. Data Source ? 2.a. Logical expression Return args.Val...

OS_Pizza · 03-23-2023

What alterantive solution you have build for Workforce Planning. I don't want to use People Planning Market place solution. 1) Run calculations inside the cube by storing all employee information. 2) Relational Table + Cube. Can you give me a top lev...

OS_Pizza · 05-27-2023

@WillVitaleI am not sure if you are looking to display inverse rate in the cube view cell. If yes, Check below1. Create two members under Accounts or UD8 . That will be your choice of dimension. I am using Account here .Make sure to put the account/F...

OS_Pizza · 05-25-2023

@Nitishkrish16 There are many ways to achieve this.For now i can think of this-1. You can write a sql query using the data adapter to output the records. Below example to extract unique members.Modify the query as per your requirement.Check the dim t...

OS_Pizza · 05-25-2023

Your data for headcount is at a different flow member called "F#EndBal_Input". In your business rule , you are filtering on the flow member with F#AddBack_Tot.Base.Can you let us know if F#EndBal_Input is base of F#AddBack_Tot. If not , you may want ...

OS_Pizza · 05-24-2023

1. Create a XFBR rule to round of the value.Public Function Main(ByVal si As SessionInfo, ByVal globals As BRGlobals, ByVal api As Object, ByVal args As DashboardStringFunctionArgs) As Object Try If args.FunctionName.XFEqualsIgnoreCase("Roundoff") Th...

OS_Pizza · 05-24-2023

@Rev That error comes from not passing the value to a given key. Please check your "CheckWF" variable.

OneStream Community

User Statistics

User Activity

TIP : Deleting all Scheduled task after application copy

Need to run a business rule before checking the transformation rule.

Bulk updating transformation rule

Remove suffix from source data where data is coming from a table.

Workforce Planning

Re: Inverse Currency Rate

Re: Can we export a hierarchy/hierarchies into a table?

Re: Forecast Seeding - Need to Add Headcount

Re: Round the result of an Allocation Method in People Planning

Re: How to check workflow/form status before proceeding with BR execution