Hello experts,
We're implementing a RTC solution for the first time (1610 FSP02 with BW 7.5.1 SP 2, BPC 10.1). Due to a delay in S/4 implemetation, we haven´t been able to run a consolidation yet so we are working based on the theory.
One of our client's request is to be able to compare Consolidated data vs Budget and Forecast data in a single report. The source for Budget and Forecast data will be flat files (xlsx).
We know that it's possible to integrate non-S/4 Entities consolidated data using Flexible upload (RTCFU) directly to ACDOCC table, however, we are not sure if it's possible to load Budget/Forecast data using the FlexUpload as well, and, if so, if this is the best option.
In this case, what would be the recommended approach for us? Is it the best option to load the Budget data to the ACDOCC? Or should we create a traditional BW data flow to load this and integrate it to CompositeProv ? Is there another approach we're missing?
We'll really appreciate any help.