Hi Gurus,
can anybody give me an helpfull advice for the following problem:
Architecture: SEM BCS on SAP BW 3.5 Basis --> Financial Reporting should be in a separate SAP BI 7.0 without BCS.
Problem:
The reporting on BCS in BW uses a vitual infoprovider with services. The service: RSSEM_CONSOLIDATION_INFOPROV read some additional data from Masterdata Tabeles from BCS.
For that it is possible to get the elimination on hierarchies an some other stuff on the fly.
how we can extract the date from the BW into a BI 7.0 not to loose the logic of the virtual Infoprovider with services.
Does the extraction over the virtual Infoprovide into the BI 7.0 help ?
Does the FM: RSSEM_CONSOLIDATION_INFOPROV read only synchronized BW MASTER DATA from BCS or does the FM read directly from BCS?
possible scenario if the FM access only to BW MASTER DATA:
1. BCS MASTER DATA <-> SYNCHRONIZE WITH BW 3.5 MASTER DATE <-> Extract to BI 7.0
2. Load Transaction Date from the transactional Infocube from BW 3.5 (used for BCS) into BI 7.0.
3. Use Virtual Infoprovider with services (FM: RSSEM_CONSOLIDATION_INFOPROV) in BI 7.0.
Is that a possible scenario ?
Thanks for your quick help.
Thomas