Discussion Board for collaboration on QlikView Scripting.
We are trying to load data from SAP BW via OLAP Connector.
The average speed of our loading is about 30000 lines per minute.
We see the strange behaviour: SAP Connector use just only one Core.
The questions are:
1) is it normal speed of data load?
2) is it normal behaviour of using CPU?
3) can we make SAP Connector to use all avaliable cores? How?
We use SAP Connector 5.5, 2 CPU, 4 Cores, 16 GB RAM
I will suggest you that instead of exptecting cube through OLAP connector . pls extract fact and dimention table seperately,
and make cube in qlikview.
Your process become faster.