QV and the consolidation data process

[#1]

Hi.

I need to know how QV can aid the consolidation data process.

Are there any articles or white papers about this subject?

Thanks

[johnw]

I'm not sure quite what you're asking. Something like how you can create the equivalent of a data warehouse using QlikView? If so, I think the basic approach is to create a "warehouse" of QVDs that your applications load from instead of from your databases.

A good blog post on the basic idea is here, even if I'd disagree with some of the specifics:

http://www.quickqlearqool.nl/?p=1064

There's a discussion of the advantages of QVDs over reading directly from the databases here:

http://community.qlik.com/forums/t/16542.aspx