we installed a QV application that gets its data from a BW. What is the most efficient way to validate the QV data against the data in the BW? Currently we use a table object in QV and export the content of the table into excel. This output is used to compare the data against the BW data, that is made available in Excel via the EPM add-in. As we have many dimensions and, therefore, even more combinations of different dimension members, this manual process is very time consuming. Do you have an idea how this process can be automated or at least partially automated?
Thank you and best regards,