Forum Discussion

OSAdmin's avatar
OSAdmin
Valued Contributor II
5 years ago

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

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. 

Data Sources

2 Replies

  • OSAdmin's avatar
    OSAdmin
    Valued Contributor II
    5 years ago
    Originally posted by Aymar Doat

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

  • OSAdmin's avatar
    OSAdmin
    Valued Contributor II
    5 years ago
    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