After adding script on reduce the file size , how to know it will not affect the report ?

[paulyeo11]

Hi All

Recently i want to make my QVW file size below 25 Mb. So i add below script into my QVW file. it work fine and can reduce the file size to what i want.

NewFilteredTable:

NOCONCATENATE

LOAD *

RESIDENT sales WHERE

  Year_n < 4

DROP TABLES sales;

But the issue is it affect some of the report on sales vs target , the target amount become zero.

For this case Lucky for me i only make one changes. and since the target amount all become zero , i know it is due to add above script. Otherwise i will not be able to figure why ?

My question is after adding new script , how to know it will create any side effect ? Or how to prevent this kind of problem from happening again ?

Paul

[paulyeo11]

Hi KUS

THank you very much .

Paul Yeo

DIrector

TDS Technology (S) P/L

Whatsapp +65 9326 1804

www.tdstech.com<http://www.tdstech.com>

[Kushal_Chawda]

Please close the thread by marking correct answer

[paulyeo11]

Hi Kushai

Today i just back from holiday , and i try again your script , it does not work.

it is possible for your post the QVW file here ?

So i know where i go wrong,

Paul

[paulyeo11]

Hi Kushal

Kindly send me the QVW file which you mentioned is working . As my side still not able to work.

Paul Yeo