topic Re: QVW file size differ after using loop and reduce in App Development

QVW file size differ after using loop and reduce

Wed, 28 Sep 2016 19:54:35 GMT

Hi, I getting huge QVW file size difference after distributing application using loop and reduce i.e. I need to use loop and reduce due to huge volume of data so that it reduces the file size and creates individual file with respect to country (field Name). But if I distribute for only one country using where clause in QVW the file size is less and size is more if when loop and reduce is .

Please help.

Re: QVW file size differ after using loop and reduce

marcus_sommer — Thu, 29 Sep 2016 07:02:16 GMT

Is there maybe a difference by the compression-option? I'm not sure if the publisher will keep a compression if this is enabled within the source-qvw.

- Marcus

Re: QVW file size differ after using loop and reduce

sushil353 — Thu, 29 Sep 2016 07:05:05 GMT

Hi,

When you use the where clause and create a separate file for each country then you are physically removing the data from the application..

But in the case of reduce and loop i guess it is logically restricting the file for a country.

Re: QVW file size differ after using loop and reduce

Thu, 29 Sep 2016 14:20:09 GMT

Thanks Sommer, there no difference in compression i.e. in both cases it is selected as high.

Re: QVW file size differ after using loop and reduce

Thu, 29 Sep 2016 14:23:18 GMT

Thanks Sushil, if that is the case then using loop and reduce file should have huge size as it is just restricting the file for a country. i.e. it should have file size as how I have for 4 countries and it just showing the data for only one country but it is not happening the same.

Re: QVW file size differ after using loop and reduce

marcus_sommer — Thu, 29 Sep 2016 19:13:56 GMT

Try it with disabling the compression and check the file-sizes again.

- Marcus

Re: QVW file size differ after using loop and reduce

Thu, 29 Sep 2016 21:48:30 GMT

I did it but no luck ..

Re: QVW file size differ after using loop and reduce

marcus_sommer — Fri, 30 Sep 2016 05:32:19 GMT

But the file-sizes from both applications increased significantly?

Please take a look into the tablewiever and report here the number of records from your main fact-tables and the belonging file-sizes from the origin app (without any country-filter), the manually reduced one and the from publisher reduced version.

- Marcus

Re: QVW file size differ after using loop and reduce

Wed, 19 Oct 2016 19:04:09 GMT

Hi All,

Finally I got the solution for my issue. I would like to recall issue.

1) I have huge data in QVD and after publishing size of application is huge

2) Thought to use Loop and reduce based on country so that individual country will have respective QVW

3) But after implementing L&R file size is still huge than if we use where clause for individual country

Now came up with another solution i.e. created a new variable in script and pass the value from publisher. So that it will consider as where clause and it creates individual file for each countries and file also got reduced.

Please refer below screenshot.

Included variable in script

Passing value

Create individual tasks for every country in QMC