Dear experts,
i have an infoset query which return about 10 million rows and
the maximum data can be imported from SAP ERP to SAP Analytics Cloud (SAC) is 800,000 rows.
and i want to import all 10 millions rows of data
any advice.
Thanks in advance.
Hi Hady,
I suggest trying to use a Live Connection open that Tammy mentioned.
What version of SAP ERP are you on?
Do you have a HANA installation?
Have you heard of APOS Live Data Gateway?
https://www.apos.com/content/sap-businessobjects-cloud-apos-data-gateway-enterprise-data
Hi,
Why not do an initial load (fetch) which returns a numbers of rows/cols which is below the max limit. (less than 1M)
then, subsequently you should do 'delta loads' to append new rows into the model (say, 9x further loads of 1M rows) = 10 M total.
does that work?
regards, H
Dear Henry Banks
this solution may be taken in considerations by load 800,0000 one by one for many times to finish all 10 M rows.]
but this will take much time.
OK, please do let us know if the approach works? I haven't validated it myself, so am curious!
Hi - One idea is to use the live connection
If you are on ECC 6.0 SP5 or higher you can activate embedded BW in ECC
Then you can creating a BEx query against this infoset and use a live connection to the BEx query instead of importing all rows to SAP Analytics Cloud.
Is this data already in a BW system? I would use that with a live connection too
we have to to import data as this infoset query will get data from ZERPORT on SAP ERP.
so we have to go through this solution and exclude BW solution.
Is ERP running in HANA? if that is the case, you can create a Calculation View in HANA and avoid importing data consuming a live connection.
Dears,
we have to to import data as this infoset query will get data from ZERPORT on SAP ERP.
so we have to go through this solution and exclude BW solution