Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
borisman
Creator III
Creator III

Self-aware QVDs

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?

5 Replies
buzzy996
Master II
Master II

Interesting,let see some one will give answer here!

Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand
borisman
Creator III
Creator III
Author

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.

bhagirath
Creator III
Creator III

check out this link

some company has launched this as kind of modeling approach

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

bestofwest
Creator II
Creator II

!) 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'