- SAP Managed Tags:
Hi Experts,
i'm trying to get data from aDSO's and info-providers via ODATA Easy Query (EQ). Earlier I have made it trought HANA (XS). In case of BW EQ method I faced an out of memory issue.
Before that I did all nessessary steps to create an ODATA service for a BW Query and get some result on tiny query (contains only 5 entries). That query return all 5 entries into Excel via ODATA. Next I have prepared a simple example query based on info-provider with a list of materials (millions of them). When trying to get data I've got have no memory or time-out (500) warning. Seems to be it's because system reading all the data.
After adding URI Option "$topN" to query situation wasn't change cause system were reading all the entries and then applying "$topN" option. As you might have guessed system couldn't run that option.
Then I created a restriction of list of materials in a query. It was a list with 200 entries. It was help me to get data into excel. 
The question is how to get data by topN without restriction in query (i need all the data)? Why system collect all the data and after than using URI options? Do I'm understand ODATA Easy Query concepts correctly?
Thank you!
Regards,
Alex
