I can imagine the following scenario: You declare some variables and use them within the script. A user who is able to reload can change the variables via inputboxes before starting the script. Nevertheless it seems to me to be a little dangerous because the user can insert anything into the inputboxes. And having started the load with silly parameters being passed to your database ......
@Roland: Thanks for your suggestion. I had that working, but as you say, it requires the user to be able to reload the script.
@Barry: Loading all data into Qlikview would of course be optimal from that point of view. Though, the specific Stored Procedure is reffering to ther SP's and are quite large. IT would require a very complex script to reproduce all the Stored Procedures in Qlikview (even though I would prefer that if it was possible). The SP's are not very well documented andI have not written them myself.
What came to my mind is whether it is possible to, when changing a variable, a macro is run to store the variable values into a text file (or similar). When the text file is updated (last changed is updated), it triggers a reload and distribute task via publisher?
thanks for your post. I agree with you when starting from the scratch. But in many cases I do remember there exists a lot of Business Logic (technical : ETL-Layer) which extracts, transfoms and loads source-data into a common analytical database. Sometimes they call it Data Warehouse. ;-)
So you do not want to loose this knowledge in this case, sometimes you won't change a running system and get your data further on from stored procs. Best example:
RobertKarneus wrote:IT would require a very complex script to reproduce all the Stored Procedures in Qlikview ... . The SP's are not very well documented andI have not written them myself.
this points into a good direction. Nevertheless I am not a friend of using macros. What about writing the parameters directly (users) into e.g. excel-files? The trigger should be realized QV-external in any case, as far as I know the QV-Publisher can't be triggered by exist/update a file.