topic Re: Locking data into a Qlikview model in QlikView

Locking data into a Qlikview model

Thu, 26 Feb 2015 08:22:18 GMT

I am needing to lock in data on a monthly basis (i.e. the users want it so that no matter what changes happen to allocations after that period the data from the past cannot change). I did it for them for the annual data by creating a separate extract model and putting security on both the extract model and the data folders so that no one had access to them other than the administrators but to do that on a monthly basis would be a maintenance nightmare. The data is all being pulled from excel spreadsheets and excel mapping documents so I can't put any kind of locks on a database.

Does anyone have any suggestions on another way to do this?

Thanks

Colleen

Re: Locking data into a Qlikview model

datanibbler — Thu, 26 Feb 2015 08:39:51 GMT

Hi Colleen,

you could store it away monthly in qvd_files? That way, the historical data would remain available, but no one could mess with it? Would that help?

Re: Locking data into a Qlikview model

jonathandienst — Thu, 26 Feb 2015 08:47:06 GMT

If you build a QVD generator layer with one or more QVW's that create QVDs based on the Excel data, you can build in rules in the load script to not reload data that is already in the QVD(s), and you can store the QVDs in a location where only the Publisher system account (or server if you don't have Publisher) and the administrators have write access.

HTH

Jonathan

Re: Locking data into a Qlikview model

maxgro — Thu, 26 Feb 2015 08:52:12 GMT

you can store end of month data in qvd (snapshot_201501.qvd snapshot_201502.qvd etc....)

and, with qvd, you can also build a qlik doc where you load all monthly qvd, just add a field to identify the snapshot you want to analyze