Reduce Data

[warrenpress]

Hi,

I have a master data model which is approx 1.5GB with over 200 millions lines of fact data.

I want to split it into smaller chunks for users.

Is it possible to script the following:

Open QV Document

Make a field select ie Year = 2016

Reduce data - Keep possible values

Save QVW as new QVW

Thanks in advance