I am trying to map historical data from SAP-BPC into OS.
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.