Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
We are currently facing this issue : we need to split an application according to one field value (it tells if the customer is a 'corporate' one or a 'field' one). We currently proceed like that : the 'corporate' value is selected, then we choose 'reduce data'. Thanks to this option, everything is consistent : all invoices that do not concern corporate customers are suppressed from the application, etc.
However, the products that are not bought are also flushed. And we HAVE to keep them, since we also need to know which products are not bought (it is a strength of QV, isn't it ?)
So, my question is : is it possible to do partial reduction through Publisher (we will soon have the license for it). ? Or do we have to do massive ETL job to reduce all the tables separately ? If so, is the loop & reduce feature of Publisher still useable (because we strongly need it to split applications across all countries) ?
Thank you for your help and your experience,
Regards,
Adrien
Hi,
You should be able to do a Loop and Reduce on that field value using publisher.
Bill
Actually my question is about the "reduce" of this loop & reduce. Will I loose all unbought products ? "Reduce" reduces all tables. Including the unselected products, customers etc. This is not the need of our company. If we cannot use this 'loop & reduce', it implies a LOT of work in etl.
When you select the item in the list box you are reducing on that is the report. That is what you will get in the reduction.
Bill
Thank you, Bill, but I must admit that this reduction way is too brutale for us. We have to do fine tuning on the dataset.
We will probably fork the reduction process thanks to script variables (e.g. if `a=1', then join (invoices).. where ...). By the way I would like to know if it is possible to pass variables thanks to publisher (e.g. `a=1' if user `John', `a=2' if user `Franck') ?
Adrien
Hi,
any answer concerning this ?
We will probably fork the reduction process thanks to script variables (e.g. if `a=1', then join (invoices).. where ...). By the way I would like to know if it is possible to pass variables thanks to publisher (e.g. `a=1' if user `John', `a=2' if user `Franck') ?
Thank you !
Adrien