Prefixes
variables Starts with a "v" e.g. vYear
Key Fields Starts with a "%" e.g. %companykey
Flag Fields Starts with a "_" e.g. _IsEnable
Cycle Group Starts with a "<" e.g.<YearMonth
Drilldown Group Starts with a ">" e.g. >CountryStateCity
Key Field Separator Separated by "_" e.g. Company&'_'&Nbr as Key
Temp Fileds/Tables End With "_tmp" e.g. Daily_Trans_tmp
Field Names
Use business names for fields. e.g. Customer Nbr instead of CustNo
Rename fields in scripts where possible - not in charts and tables
Publisher Naming Standards
Abbr. Abbr. Type Meaning
All Environment Applicable to all environments
DEV Environment Development Environment
PRD Environment Production Environment
TST Environment Test Environment
APR Publisher Item Publisher Access Point Resource
JOB Publisher Item Publisher Job
SDF Publisher Item Publisher Source Document Folder Resource
TSK Publisher Item Publisher task
DSR Publisher Item Directory Service Resource
variables Starts with a "v" e.g. vYear
Key Fields Starts with a "%" e.g. %companykey
Flag Fields Starts with a "_" e.g. _IsEnable
Cycle Group Starts with a "<" e.g.
Key Field Separator Separated by "_" e.g. Company&'_'&Nbr as Key
Temp Fileds/Tables End With "_tmp" e.g. Daily_Trans_tmp
Field Names
Use business names for fields. e.g. Customer Nbr instead of CustNo
Rename fields in scripts where possible - not in charts and tables
Publisher Naming Standards
Abbr. Abbr. Type Meaning
All Environment Applicable to all environments
DEV Environment Development Environment
PRD Environment Production Environment
TST Environment Test Environment
APR Publisher Item Publisher Access Point Resource
JOB Publisher Item Publisher Job
SDF Publisher Item Publisher Source Document Folder Resource
TSK Publisher Item Publisher task
DSR Publisher Item Directory Service Resource
This is the excellent one .....
ReplyDeleteQlikview Online Training