Skip to main content
A
Anonymous
June 16, 2020

I am trying to map historical data from SAP-BPC into OS.

  • June 16, 2020
  • 2 replies
  • 0 views
Originally posted by Hans van der Kemp

3/20/2020

I am trying to map historical data from SAP-BPC into OS.
BPC has some accounts where 3rd P and Interco are booked on a single account.
The ""top"" member is stored and is called ""TPTOP"". This member contains the sum of 3rd P + Interco. The Interco partners are also stored as ""IC1"" etc
The issue is that the 3rd P component (our I#None) is generated by analysis services, and is therefore not stored. It cannot be extracted from BPC.
So I would like to create a complex expression or BR that does ""I#None = TPTOP minus IC1, IC2 etc""
Does someone have a snippet available for that?
Another option could be to (manually) create an additional 3rd P load file, just for I#None, and merge it with the regular source file. But I prefer the code solution, because it is repeatable. 

2 replies

A
Anonymous
June 23, 2020
Originally posted by Aymar Doat

A derivative rule should do the trick I believe ! If you need help to built it ping me

A
Anonymous
June 23, 2020
Originally posted by Hans van der Kemp

Solved by derivative rule that creates an additional record D_TPTOP for each IC detail record, multiply it by *-1, then mapping both TPTOP and the D_TPTOP into I#None

Terms & ConditionsAccessibility statement