About this task
Talend DQ Portal provides an access to Online Analytical Processing (OLAP) on the data resulted from the analyses carried on in the Profiling perspective of Talend Studio. In this page, you can easily and selectively extract and view data based on multi-dimensional analytical queries and save the most interesting view.
The Analytical Processing page in the web user interface gives an access to a document with time and indicator dimensions and their corresponding measures (values of threshold indicators). The view can also be displayed in the form of a bar chart.
The below figure illustrates an example of an OLAP document:
An OLAP document is a way to inquiry your business data freely and dynamically. This means that normally the user starts his analysis from a predefined view and then he can completely change the inquiry interacting with the platform.
You have accessed Talend DQ Portal as a user.
Some reports have been generated in the Profiling perspective of Talend Studio.
To change the inquiry that interacts with the platform, do the following:
On the toolbar, click the icon, expand tdq_user and
ExampleA page opens with documents on Simple statistics, Summary statistics and Text statistics.
Click one of the documents depending on what type of data you want to
The Analytical Processing page opens.
From the toolbar of the page, click the OLAP navigator icon to open a matrix table.
Here you can set the parameters of the query and decide what data to analyze.
From this matrix table, click:
define the thresholds you want to use in your query.
define the analyses to integrate in your query.
define the indicators you want to use in your query.
define the connections you want to use in your query.
define the dates you want to use in your query.
Click the icon on the toolbar to display the extracted data in the form
of a bar chart.
If required, click the icon on the toolbar to open a view where you can configure the