Nprinting Performance issue on generating excel

Thu, 17 Nov 2016 03:14:51 GMT

Dear All,

Im having issue with the performance of NPrinting when generating the excel reports as details below :

My records consist more than 1 million records. And I have do some filtering in NPrinting because the excel generated are separately by Branch State. I have around 30 branch state to be filter based, meaning NPrinting need to generate 30 excel report based on each transaction perform by customer in the Branch.

The column of report consist of 8 dimensions columns (without any calculated dimension) and the expression consist of 5 columns which consists expression as a Sum and analysis expression.

For info, the expression calculation are similar for other report just that this affected report consists the detail information in the dimension column ( Product, Time, Vendor Id, Id Num, Branch name).

I do not have any issue with other reports which does not have the dimension column as Time and ID num. The other reports also having the same filtering which is 30 branch name

Fyi, when Nprinting generate one excel report for one branch only, it takes around 2 hrs to generate which the data around 350K rows.

Does Nprinting having limitation to generate the details reports in excel? If not any suggestion for me to reduce the timing.

topic Nprinting Performance issue on generating excel in QlikView

Nprinting Performance issue on generating excel