we want to extract data from a table in R/3 which helds detailed data - much more detailed than we like to query in BW. Of course we can do aggregation in BW
but in fact we are not interested in the detailed level so why transfer the detail?
In our case we extract about 5 Mill. records (in one request!) but in the end we are writing only 100.000 to the ICube.
As an example you can imagine AMOUNT to be held at item level but we only want to extract at document level.
I suppose that this is a very frequent requirement and I guess that somebody might have come across it.
Currently I am thinking about using a function module to do it.
What would be the best way to do it in terms of performance?
Using DB Cursors? Collect? Select ...group by?
Thanks for sharing your experience and kind regards