Scenario: Retrieving dimension elements from a given cube - 6.3

Talend Open Studio for Big Data Components Reference Guide

EnrichVersion
6.3
EnrichProdName
Talend Open Studio for Big Data
task
Data Governance
Data Quality and Preparation
Design and Development
EnrichPlatform
Talend Studio

The Job in this scenario retrieves several dimension elements from a demo Palo cube Sales.

To replicate this scenario, proceed as follows:

Setting up the Job

  1. Drop tPaloInputMulti and tLogRow from the component Palette onto the design workspace.

  2. Right-click tPaloInputMulti to open its contextual menu.

  3. In the menu, select Row > Main to connect tPaloInputMulti to tLogRow with a row link.

Setting up the DB connection

  1. Double-click the tPaloInputMulti component to open its Component view.

  2. In the Host name field, type in the host name or the IP address of the host server, localhost for this example.

  3. In the Server Port field, type in the listening port number of the Palo server. In this scenario, it is 7777.

  4. In the Username field and the Password field, type in the authentication information. In this example, both of them are admin.

Configuring the Cube Query

  1. In the Database field, type in the database name in which the cube to be used is stored.

  2. In the Cube field, type in the cube name in which the dimensions of interests are stored. In this scenario, it is one of the demo cubes Sales.

  3. In the Cube type field, select the Normal type from the drop-down list for the cube to be created, meaning this cube will be normal and default.

  4. Next to the Edit schema field, click the three-dot button to open the schema editor.

  5. In the schema editor, click the plus button to add the rows of the schema to be edited. In this example, add rows corresponding to all of the dimensions stored in the Sales cube: Products, Regions, Months, Years, Datatypes, Measures. Type in them in the order given in this cube.

  6. Click OK to validate this editing and accept the propagation of this change to the next component. Then these columns are added automatically into the Column column of the Cube query table in the Component view. If the order is not consistent with the one in the Sales cube, adapt it using the up and down arrows under the schema table.

  7. In the Dimensions column of the Cube query table, type in each of the dimension names stored in the Sales cube regarding to each row in the Column column. In the Sales cube, the dimension names are: Products, Regions, Months, Years, Datatypes, Measures.

  8. In the Elements columns of the Cube query table, type in the dimension elements you want to retrieve regarding to the dimensions they belong to. In this example, the elements to be retrieved are All Products, Germany and Austria (Belonging to the same dimension Regions, these two elements are entered in the same row and separated with a coma.), Jan, 2009, Actual, Turnover.

Job execution

  1. Click tLogRow to open its Component view.

  2. In the Mode area, select the Table (print values in cells of a table) check box to display the execution result in a table.

  3. Press F6 to run the Job.

The dimension elements and the corresponding Measure values display in the Run console.