naming conventions of fact tables and dimension tables in qlikview

[Anonymous]

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

[engishfaque]

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

[rajeshvaswani77]

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

[barryharmsen]

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)

[rajeshvaswani77]

Thank you so much Barry. I just needed this.

regards,

Rajesh Vaswani