Skip to Content
avatar image
Hady Ibrahim

Import more than 800,000 rows to SAC

Jan 23, 2018 at 11:44 AM | 592 Views

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.

SAP Analytics Cloud
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Henry Banks
    Jan 23, 2018 at 11:52 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Tammy Powlas
    Jan 23, 2018 at 11:47 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Hady Ibrahim
    Jan 23, 2018 at 12:31 PM

    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

    Add comment
    10|10000 characters needed characters exceeded