BICC - ability to product a single CSV output merging data from many data stores/VO's
Does BICC support selecting columns from different data stores/PVO's and apply query filter?
We have a business requirement to extract large volume of PO data (daily) - est 10K PO Line records.
There are other data extracts (full and incremental) varying between few 1000's to 50K per extract.
We are looking at BICC and BI Publisher as the primary data extract options from ERP.
With BICC is it possible to pick and choose fields from related data stores, as example: PO header, Po Line, Receiving Transactions tables. Then apply a filter criteria based on PO header or RCV Transactions so that only those PO Lines are extracted.