topic Re: Schedule Script to Load Current FACT - but Keep Previous DIMS? in QlikView

Schedule Script to Load Current FACT - but Keep Previous DIMS?

Thu, 02 Aug 2012 15:51:01 GMT

Hiya Guys,

I have 5 Dimension tables, and 1 Fact table.

The Dimension tables will change very rarely - and I would like to automatically update my Fact table very regulary.

If I load all the tables once, and then in subsequent loads only generate a new Fact .qvd and import - QV removes the previous Dimension tables created... is there any way around this? (so I am only loading the current Fact data and keeping the old Dimensions?).

Also, I would like to schedule the Fact load... maybe once a minute?! - very small dataset... does anyone have a best-practice way of setting-up a Schedule for such a high-frequency update? - Windows Task Scheduler/QEMC/other?... load time of the Fact table is litterally only a couple of seconds - but I don't want to grind the Server to a hault!

Any information/suggestions welcome!

Cheers,

Steve.

Re: Schedule Script to Load Current FACT - but Keep Previous DIMS?

rwunderlich — Thu, 02 Aug 2012 16:14:39 GMT

Take a look at "Partial Reload" in the Ref guide and Help.

-Rob

Re: Schedule Script to Load Current FACT - but Keep Previous DIMS?

Thu, 02 Aug 2012 16:51:54 GMT

Thanks Rob,

Easy when you know what you're looking for! 🙂

I don't suppose you have any experience/ideas with regards to the best way to achieve my scheduling requirements?

Cheers,

Steve.

Re: Schedule Script to Load Current FACT - but Keep Previous DIMS?

rwunderlich — Thu, 02 Aug 2012 18:53:42 GMT

I've never tried to schedule every minute on QEMC, but I would give it a go if your reload takes less than a minute.

-Rob

Re: Schedule Script to Load Current FACT - but Keep Previous DIMS?

Fri, 03 Aug 2012 07:35:03 GMT

Thanks Rob,

I'll give it a go and post back my findings! 🙂

Incidentally, is there any advantages/disadvantages to using QEMC over a .bat file under Windows Task Scheduler?... I don't understand why the two different methods exist...

I really appreciate your time and help.

Cheers,

Steve.