Create a Dimension with values fetched from QlikView

Use Case

Use Case

If your QlikView report contains information for several Dimensions, you do not need to create a separate element for each Dimension Value in Metric Insights. All you need to do is just copy QlikView "filter values" into MI. This article covers step-by-step instructions on fetching this data from QlikView.

NOTE: If a new filter value is added to this QlikView report later, it will be automatically copied to MI upon triggered data collection.

1. Open the QlikView Plugin you are going to use as a Data Source for the future Dimension

  1. Go to Admin > Data Sources. The list with all data sources created in the system is going to be opened.
  2. Select the plugin you plan to use as a Data Source for the future Dimension. Alternatively, crate a new one: Establish Connectivity to QlikView

1.1. Update the list of QlikView Reports

Update the list of QlikView Reports

Metric Insights extracts data from the QlikView server in the form of reports. Information obtained from these external reports is further used as data source for MI elements: Metrics, Reports, Datasets, etc. QlikView Reports can be added in the Plugin Editor. There are two options to add reports to the plugin:

  • Automatically: If the External Reports fetch method field is set to 'automatically', go to the QlikView Reports List tab and simply click Refresh list to collect all QlikView reports currently available at the server
  • Manually: You can also update the QlikView Reports List by adding report IDs and Names one-by-one or via a CSV file

2. Add a new Dimension

Add a new Dimension
  1. Go to Content > Dimensions. The list with all dimensions created in the system opens.
  2. Click [+ New Dimension]

2.1. Define the Basics

Define the Basics

Provide the basic Dimension definition information, paying attention to:

  1. A unique Name for your Dimension
  2. Value Source: Specify how Dimension Values will be collected for the new Dimension. In this example, we are selecting 'QlikView' plugin from previous steps. It is going to serve as data source
  3. Object: Define the QlikView item report that contains the required values in the Select Object pop up. In our example we need to fetch Country Values, so we have selected a 'Sales by Country' item since it contains the info we are looking for.

Save your entries. The Dimension Editor opens.

2.2. Enter the command for fetching data

Enter the command for fetching data

1.   You can enter the command manually

OR

2.   Use a Visual Editor and choose the required fields

2.3. Check Data and Collect Values

Check Data and Collect Values

2.4. Result

Result

What's next?

You can now use this Dimension to create dimensioned Metrics, Reports and External Reports from QlikView.