Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
naming conventions of fact tables and dimension tables in qlikview.Do they follow any naming convention ? Please share info .Any posts are appreciated
Thanks
Dear rgv,
Naming convention is necessary, it will helps to developers as well as business users.
For example:
CST_DATA table should be renamed with Customers: Customers is more understandable instead of CST_DATA.
Prefix:
Manufacturer_Country table which consist on map fields should be prefixed with Map_Manufacturer_Country
Prefix for Key Field: Percentage sign ( % )
Prefix for Measures: Hash sign ( # )
Prefix for Flags: Underscore ( _ )
Try to use prefix for clear understanding.
Reference book: QlikView 11 for Developers
Please note: Have a look into Book QlikView 11 for Developers, for better and with example understanding
QlikView 11 Developer Tutorial
QlikView 11 for Developers - QlikView Book
Kind regards,
Ishfaque Ahmed
Hi,
You can have the fact tables start with fact
ex: fact_revenue
dimension tables with dim ex: dim_country
you can choose to leave the dim table names as it is.
Finally depends on the conventions you would like to follow.
thanks,
Rajesh Vaswani
You might also be interested in the QlikView coding conventions white paper that is available from our website: http://www.bitmetric.nl/bitmetric-qlikview-coding-conventions/
The site has a form that asks for your contact details. Don't worry though, I won't call or email you (unless you are located in The Netherlands, then I might)
Thank you so much Barry. I just needed this.
regards,
Rajesh Vaswani