Qlikview Data Model,Exporting Images & Structures and best practices:
QlikView Data Model best practices dictate that, a star schema is desirable whenever possible. If not a star schema, the smallest possible snowflake schema is fine, especially in limiting the fact tables to one. A scenario may exist, however, where there is only one large fact table containing many dimensions.
Similarly, if you have a data model with a snowflake schema, working to consolidate the data and build a star schema is usually not going to cause increased performance/ decreased time of query in most cases. This does change with very large data sets, and in those cases, it is worthwhile to spend the time to consolidate and collapse as much as you can, to confirm the star schema.
One of the key considerations is limiting the number of connections required for QlikView to access data, so when working with large data sets, consolidate your data and limit the number of dimension tables, as well as consolidate/concatenate multiple fact tables.
Exporting Images and Structures:
The Table Viewer can export images or structures of the existing data model in a QlikView document. These images or structures can be useful in documentation and analysis of a QlikView application. The Table Viewer menu bar, as shown in the following screenshot, can be used for any of the exporting or print commands.
Related Page: How To Use Visual Cues And Alternate States In QlikView?
The data model viewer provides you with an overview of the data structure of the app. You can preview the data in the tables and fields in the data model viewer. You can also create dimensions and measures on-the-fly. In the data model viewer, each data table is represented by a box, with the table name as the title and with all fields in the table listed. Table associations are shown with lines, with a dotted line indicating a circular reference. When you select a table or a field, the highlighting of associations instantly gives you a picture of how fields and tables are related.
Table Viewer menu commands help you with the exporting, copying, or printing of data model images and structures, as described in the following lists. Note that the Internal Table View and Source Table View drop-down list options are discussed in the next section, named ‘Viewing internal and source tables’.
Internal Table View is the default option and shows how the data is stored in QlikView. It also shows synthetic keys if they are created.
Source Table View shows how QlikView reads the data and if synthetic keys are present it does not show them.
The layout of tables in the Table Viewer generally persists even when the document is closed and re-opened. However, changing the data models slightly can make the tables in the Table Viewer appear in different locations than the ones previously defined.
Get Updates on Tech posts, Interview & Certification questions and training schedules