Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
vijayaganesh_s
Partner
Partner

Facing Problem during Data Load using BEx connector

Hi All,

I'm Facing problem while loading data from SAP BW using BEx connector when there are more than 500000 Rows.

There is no problem while loading the Query which has less than 500000 Rows but the problem occurs when row number exceeds 500000.

In order to limit the data during loading I'm loading data based on filtering Particular feilds like Month,Place,ProgramName this method is working fine for all Except one Month, Place, ProgramName combination of filter which means that particular combination of filter itself having more than 700000 records.

So I want to reduce the number of Records to be loaded / fetched from SAP BW through BEx connector.

Can Anybody please help in this scenario to limit the Number of Records or Any Alternate solution for this problem.

Regards,

Vijayaganesh S

10 Replies
quriouss
Creator III
Creator III

Yes, I think that's correct- you need at least one query built and released for the IinforProvider to be visible to third-parties;

https://help.sap.com/doc/saphelp_nw73ehp1/7.31.19/en-US/d4/eae3d74ddf774f8ba2671d1dffbd24/content.ht...