OneStream Community

BenvanBergen

Hello, I have imported data from a csv file with unit price adjustments. Data is transformed to use the correct UD2, UD5 with One to one transformation. In some cases there should be a second data record created with a different UD2 and UD5, is it po...

BenvanBergen · 06-07-2024

Seems I have found a bug, not sure if this is the right place to get it solved. We have a calculation where we use text3 on the customer, which is the country code to find the freight rate on the country customer with that name. In the latest forecas...

BenvanBergen · 05-31-2024

Hello, I'm looking for a member formula, or business rule to copy data from an entity to the IC entity, where also another UD member is substituted. Example of source data: Cb#100:E#3100:P#?:C#EUR:S#May_C2:T#2024M5:V#Periodic:A#ICfreightPrice:F#Calc:...

BenvanBergen · 11-29-2023

Hello, How can I see the signage from aggregation weights. For example I have these 2 account groups in a hierarchy: PL44000000 has aggregation weight 1 PL43700000 has aggregation weight -1 When I show these in a cube view with SG&A.Children.Base all...

BenvanBergen · 11-14-2023

Hello,For purpose of grouping we have some accounts listed as member filter in a single row:A#VOL_O_StockWIP:Name(Opening Stock Volume), A#VAL_O_StockWIP:Name(Opening Stock Value) etceteraSome of these would need a different format to make it easer t...

BenvanBergen

Thanks Marcus, You had given all that was needed, still it took me some time to figure it out. Below a screenshot of the settings that worked for me, creating a duplicate line with a different UD2: This changed line also needs a different UD5, by usi...

BenvanBergen

Thanks @Henning and @MarcusH, I had overlooked that and didn't find anything in the ABA training documentation. Should be able to make it work, I'll let you know.

BenvanBergen

Thank you @MarcusH, would that be used then in a BI Blend import? I could find some documentation on that, however in the regular transformation rules I didn't find anything on derivative rules.

BenvanBergen

I see, not much entered on security. Was there another workflow profile created for the same entity maybe? You can have the entity assigned to only 1 workflow. You can also check the pov to see if there are any parent members included, if it's not re...

BenvanBergen

Hello, there can be several reasons for this: Authorization, usually on scenario, or entity level. Does the cubeview allow input in the cubeview properties, or on row/column level. Can also be authorization in the workflow profile settings I hope it'...

OneStream Community

User Statistics

User Activity

Create second line on a data import

Text IN on UD3 gives error

Copy account to other account on IC entity

Aggregation Weight Display in Cube View

Formatting of multiple Member Filters in CubeView

Re: Create second line on a data import

Re: Create second line on a data import

Re: Create second line on a data import

Re: Data cells are read only

Re: Data cells are read only