Hello BW Experts,
We have a scenario to report customer balances and payments. The feed is from a non-sap system. Changes(delta) comes to BW every weekend. There are about 1 M customers. We have customer master and also a zcustamt ODS. A report is needed to view the customers for a couple of company codes with the balances and payments.
we have 2 possible solutions
1) create the report on the zcustomer infobject
2) use the ODS to report
Wondering how efficient is to report on Infobject when we have 1M customers. In case we go for ODS. Then we are creating copy of the same data and we have to make sure that these are not inconsistent.
What would be the best way to model this scenario?