Dictionary Entries

Dictionaries contain a subset of entries from schema snapshots.  Each of the entries can have additional metadata associated with it including a preferred name "Alias" as it should appear in Qlik Sense.

Manage Tab

The Manage tab displays a list of entries associated with one or more dictionaries based on the filtered selection: .  

Dictionary: the name of the dictionary included in the filter

Dictionary Entry Type: either Dimension or Measure

Alias: the field name as it appears in the QVD

Expression: freeform text field for coding expressions using Qlik Script language

Master Item: indicates that this is a Master Item (either a Master Dimension or Master Expression) as defined in Qlik Sense documentation

Governed: indicates that this dictionary entries has passed through the governance process and requires Reviewer approval for changes

Contributer Input: the name of the Data Steward or Data Owner that is responsible for the dictionary entry if it is has been designated Governed

Reviewer Input: the name of the team leader of supervisor that is responsible for setting the Governed flag for this dictionary entry

note: IPDF does not include a governance workflow in this release.  Governance, contributor and reviewer fields are provided for convenient integration with other manual or automated work flows.

Open

Clicking the arrow next to the  links provides additional metadata for the dictionary entry:

Open

Clicking the link allows updates to be applied to the dictionary entry.  

In addition to the fields described on the Manage tab of this help page, these fields are available:

Description: business language description of the entry - intended for data consumers and developers

QS Script: not used in this release

Prefixes: not used in this release

Tags: indicates that this is a Master Item (either a Master Dimension or Master Expression) as defined in Qlik Sense documentation

Notes : freeform text field for notes on data evolution, quality, use cases and notes for data managers and developers

Click on the link to apply updates.

Append Origin Items Tab

This feature provides an automated way to add entries to the Dictionary. 

Step-by-step guide

1. Select the Dictionary from the drop down list of Dictionaries

2. Select the Schema Snapshot that you want to import entries from

3. The Origin Tables now contains a drop down list of tables found in this Schema Snapshot that you can automatically create dictionary entries for.  Either select the box in the header (select all) or individually select tables of interest.

4. click on the button 

A status bar will show progress.  Upon completion a success message will appear.  If a success message does not appear, note the error information and contact IPDF support.

note: during the append process, existing dictionary entries with names that match names being appended through this process will not be overwritten.

Related articles