TX Dictionary Project

Gain valuable insights into your ‘Project Repository’ with TX Dictionary Project

The purpose of the TXDictionary project is to provide visibility into your project repository Meta Data across one or many projects.  The TXDictionary project was designed to assist developers, data architects and Business users to gain insights into their Discovery Hub projects.

It includes a Discovery Hub project designed to take advantage of the multi-layer platform, connection to a project repository, data consolidation, transformation and cleansing in the Data Staging Area, and a robust reportable data warehouse in the MDW.  The TXDictionary project is a great example of leveraging the power Discovery Hub® to simplify a very complex relational data model into a Dimensional Data Warehouse. It also includes a Qlik Model, Qlik application and several Qlik dashboards which provide easy visibility into all your projects in a given repository.

Current list of tables and fields within the project can be found in the attached file: DataDictionary.xls


The following is a sample table contained in the DataDictionary.xls




Dashboards included in Qlik Application created in TX Dictionary project

The Qlik dashboards provide easy access and reporting on one or many projects within your repository.  There are 4 Dashboards included as part of the ‘TX Dictionary’ project ‘TX Dictionary’, ‘Execution Time’, ‘Failed Executions’, and ‘Data Quality’.

TX Dictionary Dashboard

The TX Dictionary dashboard allows users to browse one or many projects to understand project data sources, databases, table and query information, all data fields including data types, transformations, the source or sources of each field and the population methods.  You may filter this information by project, database type, database, container, or by field.  This allows users to really zoom into vital project information at any desired level.

The following is a snapshot of the Dashboard:


Execution Time Dashboard

The Execution Time dashboard provides valuable insight into Execution package information within 1 or many projects.  Monitor execution packages, schedules, execution steps and average execution time by table.  Filter executions by project, scheduled package, and step type.

The following is a snapshot of the Execution Dashboard:



Failed Executions Dashboard

The failed executions dashboard is a companion of the execution dashboard with emphasis on understanding the status of each execution.  Users can view all execution packages post execution along with start and end time information, execution steps, status, total execution time and Execution message log information.  Filter executions by project, scheduled package, execution package and execution status.

The following is a snapshot of the Failed Executions Dashboard:


Data Quality Dashboard

The data quality dashboard gives users a graphical bar chart depicting the amount of good, warning and error information for each table within a project(s).  Filters can be applied by project, data quality status and by table.

The following is a snapshot of the Data Quality Dashboard:




Download and Initializing the TX Dictionary Project

Download the TX Dictionary Project from the Cube Store


Once imported Select ‘Yes’ to run the Connection Manager


Create a ODX database

Connect to an Existing Project Repository and ‘Test Connection’

Create a MDW database

Create a DSA database


Once complete ‘Test Connections’ and validate the Connection States are all Green


Deploy and Execute the Project


Setting Up Qlik Applications and Initializing Dashboards

Copy ‘TX Dictionary.qvf’ file into your Qlik Apps folder

Create QlikSense App from Discovery Hub


This should create the connection script required to connect QlikSense or QlikView to the Discovery Hub Qlik views



If this does not create the ‘MDW’ connection in QlikSense automatically then you need to manually create a ‘MDW’ connection in QlikSense that points to the correct MDW database in Discovery Hub


Deploy QlikView script to a text file, make sure you choose QlikView syntax.

Use the include statement in Qlikview to point to the Qlik script file


Load data in Qlik to ensure connectivity



Was this article helpful?
1 out of 1 found this helpful
Have more questions? Submit a request


  • 0
    Andri Páll Heiðberg

    Do you perhaps have a similar dashboard in the works for Power BI?

  • 0
    Joseph Treadwell

    Hi Andri, We are working on PowerBI and Tableau dashboards for this as well. 

Please sign in to leave a comment.