Code Review Tools for Qlikview

Anonymous — Fri, 06 Jun 2014 04:21:57 GMT

Are there any code review tools for Qlikview?

Re: Code Review Tools for Qlikview

tresB — Fri, 06 Jun 2014 04:34:21 GMT

I am not aware of a tool for the same. May be, this helps you:

Script Best Practices:

Naming standards used for columns, tables, variables
Script is well commented - changes date flagged
First tab holds information section
Subject areas each have tab in script
Use of Include files or hidden script for all ODBC connections
All code blocks with comment sections
All file references using UNC naming
Business names for UI fields
Security script in Inlcude file
Turn Generate Logfile option on
UPPER() function used on Section Access fields
Publisher Service Acct added to Section Access
Use numeric flags where possible

Data Model Performance:

Synthetic keys removed from data model
Ambiguous loops removed from data model
Correct granularity of data
Use of QVDs where possible
Use integers to join tables where possible
Remove system keys/timestamps from data model
Unused fields removed from data model
Remove link tables from very large data models
Remove unneeded snowflaked tables (consolidate)
Break concatenated dim. fields into distinct fields
All QVD reads optimized
Use Autonumber to replace large concatenated keys

Re: Code Review Tools for Qlikview

Fri, 06 Jun 2014 04:47:56 GMT

Good post Tresesco

Regards,

Lalit

Re: Code Review Tools for Qlikview

Anonymous — Fri, 06 Jun 2014 05:17:20 GMT

Thank you tresesco

I am following most of these best practices in my report. But I need a code review tool for the same. When more than one person is working on a report, this type of tool will be helpful to check the integrity of the code developed by different developers.

Thanks,

Laxmi

topic Re: Code Review Tools for Qlikview in QlikView

Code Review Tools for Qlikview

Re: Code Review Tools for Qlikview

Re: Code Review Tools for Qlikview

Re: Code Review Tools for Qlikview