OneStream Community

KennethNL · 05-24-2022

Hi, I have some accounts I either need to map to an asset account (100000) or liability account (200000). The mapping should be based on the total account incl. sum of all dimensions. e.g. A#12345:I#IcpA = 2000 A#12345:I#ICPB = -3000 Then both accoun...

KennethNL · 05-31-2022

Creating the extra row for derivative it not a problem.But as mentioned below:I might be able to skip ICP, so each ICP goes to different accounts.But same question remains more or less, if I then haveA#12345:U1#ABC = -2000A#12345:U1#DEF = 3000Acc. 12...

KennethNL · 05-31-2022

Yes, that is how it is currently being done. I might be able to skip this, so each ICP goes to different accounts.But same question remains more or less, if I then haveA#12345:U1#ABC = -2000A#12345:U1#DEF = 3000Acc. 12345 maps to acc. A1234 or L1234 ...

KennethNL · 05-24-2022

Hi Nicolas, Thank you, I looked at that post already, but it did not work.If I add all dimensions and put them the same, then yes, I can get one positive or negative account.But as mentioned, then I e.g. have IC_All instead of the individual IC partn...

OneStream Community

User Statistics

User Activity

Pos / Neg check of total amount but keep all dimensions for future mapping

Re: Pos / Neg check of total amount but keep all dimensions for future mapping

Re: Pos / Neg check of total amount but keep all dimensions for future mapping

Re: Pos / Neg check of total amount but keep all dimensions for future mapping