I am working to automate a manual process using Qlikview and CIA Report Manager. The report I am trying to reproduce uses a very complex SQL script that goes through many steps to go into the Excel Template. I don't want any visuals and all the user would do is select a few perimeters and select a month range.
I would like to not have to completely rebuild everything and just use Qlikivew to take the selections and pass those selections to live data on oracle and leverage the existing SQL. Is this possible?