topic Re: Self-aware QVDs in QlikView

Self-aware QVDs

Anonymous — Fri, 03 Apr 2015 15:02:23 GMT

Hi mates,

I've heard a couple times this term - Self-aware QVDs - and I am curious what it actually means. I heard this from folks who actually built data warehouse and data marts using QVDs.

Can someone shed some light on this term? My suspicion that this is just a fancy word that entails:

1) ensuring primary unique key for every QVD which is used to join to other QVDs

2) safe naming convention for column names to minimize issues with synthetic keys / accidental concatenation

3) dates compatibility with a shared master calendar QVD

is there anything else?

Re: Self-aware QVDs

buzzy996 — Fri, 03 Apr 2015 15:48:44 GMT

Interesting,let see some one will give answer here!

Re: Self-aware QVDs

Gysbert_Wassenaar — Fri, 03 Apr 2015 16:13:28 GMT

I reckon it's their own personal jargon. I've never heard anyone mention self-aware qvd's before.

Re: Self-aware QVDs

Anonymous — Fri, 03 Apr 2015 16:18:00 GMT

thing is I've heard this from 3 people at least working for different companies some were presenters on a Qlik conference and a conversation with another guy was very brief - Unfortunately i do not have their contact information to ask.

Re: Self-aware QVDs

Anonymous — Fri, 03 Apr 2015 17:04:25 GMT

check out this link

some company has launched this as kind of modeling approach

https://twitter.com/spartan_tech/status/534712502463246336

Re: Self-aware QVDs

Anonymous — Fri, 03 Apr 2015 19:44:55 GMT

!) Create id unique column (number) on every qvd file.

2) use unique names to avoid synthetic keys. QUALIFY is a solution......

3) Create a unique QVD calendar.

One of the column should be forced to date format.

Sample:

SELECT.... date#( date , 'YYYY-MM-DD')

....

calendar (qvd)....

date is the date field on format 'YYYY-MM-DD'