what is the best way to reduce the file size ?

[paulyeo11]

Hi All

I have QVW file , i like to reduce the file size .

what i did is i remove the old data. That is my sales order table have sales from 1997 till 2017.

So what i do is to remove the 1997 till 2013 data. as those old data we don;t need to analyse.

NewFilteredTable:

NOCONCATENATE

LOAD *

RESIDENT sales WHERE

//BRAND_='BECKHOFF';

  Year_n < 4;

DROP TABLES sales;

When i using the above script to remove those old data only keep last 4 year data.

Year_n = 1 is current sales

Year_n = 2 is last year sales

Above work fine , but it affect my sales target report.

Can some one advise me how to reduce the file size and not affect my report ?

Paul Yeo

[paulyeo11]

Hi All

If i use script :-

NewFilteredTable:

NOCONCATENATE

LOAD *

RESIDENT sales WHERE

  Year_n < 4;

DROP TABLES sales;

it will only select

Year_n=1

Year_n=2

Year_n=3

Now i never run the above script , when i manually select

Year_n=1

Year_n=2

Year_n=3

The sales target become zero.

Paul Yeo

[prma7799]

For reducing qvw file you have to apply year filter for all tables like Sales, Target etc.

Second thing you can comment unwanted fields .

[paulyeo11]

Hi P M

I am not sure what you saying.

Can you pls give me more detail info.

Paul Yeo

[prma7799]

I means to say that if you have multiple fact table in your application then you have to apply or use filter which you apply filter for sales table like that you have to apply filter to all fact / transaction table .

Secondly , You can comment unused field for reduce file size.

[paulyeo11]

Hi P M

I try to add 2 condition on filter , I get the error msg below , How to avoid the error msg :-

NewFilteredTable:

NOCONCATENATE

LOAD *

RESIDENT sales WHERE

  Year_n < 4

BRAND_='BECKHOFF';

DROP TABLES sales;

[prma7799 · Accepted solution]

NewFilteredTable:

NOCONCATENATE

LOAD *

RESIDENT sales WHERE

  Year_n < 4 and

BRAND_='BECKHOFF';

DROP TABLES sales;

"and is missing "

[Kushal_Chawda]

may be

WHERE

  Year_n < 4 and

BRAND_='BECKHOFF';

[paulyeo11]

Hi P M

Can you share with me how to remove un-used field from my sales table ?

So that i can reduce the file size.

Paul Yeo

[Kushal_Chawda]

Use document analyzer to know which are your unused field

Document Analyzer V3.0 Update Available