About Data Blocks of a Layout

The Data area of the Layout editor defines the Data Blocks (or columns) of the query that will be executed on the Data model. Data Blocks define the information that will be queried when the Layout is executed, while the Axis area defines the view of the query.

For example, a query displaying net sales and sales volume per product category and quarter is the result of a Layout with two data blocks, Net Sales and Sales Volume, and the dimensions "product category" and "quarter" set by row. (see the image below)

A new Data Block can be created by dragging any element from the Data panel on the left, or by clicking the plus icon.
See About the Layout Object and Configure a Layout for more details.

Each Data Block is identified by a letter displayed in the row header. Those letters can be used in formulas in order to define calculated columns.

Letters in row headers are always displayed in alphabetical order: changing the Data Block order won't change the letters order.
If letters are used in formulas and the Data Block order is modified, letters will automatically change in order to keep calculations consistent.


A Data Block of the Layout can be one of the following:

  • A Cube
  • An algorithm. The result of a formula based on other Data Blocks of the Layout. The formula uses the block letters to refer to other blocks and can refer to other calculated columns. An algorithm is always executed on the fly and its result is not saved in the Data model
  • An Entity. Adding Entities as Data Blocks allow to visualize and edit Relationships with the Entity in the "BY ROW" field of the Axis area
  • A ranking function. A predefined algorithm for ranking analysis. The selected function is applied on the values of the previous Data Block in the list, taking into account only the most nested Entity in the Axis area (i.e. the one in the rightmost position in the "BY ROW" field)
  • A Rule. Rules are formulas configured at the Data model level and can be applied to any Cube that contains in its structure the Entities included in the Rules themselves. With a rule, you can output an Entity member as a result of a formula which is calculated in real time from other members of the same Entity. The selected Rule is applied on the values of the previous Data Block in the list. 


By clicking on a Data Block, you can configure additional settings and properties , such as the column heading, the number of decimals, conditional color alerts, and others.

Click the "FILTERS" button to configure sorting options and filtering conditions based on Data Block values.

The cog icon (  ) beside the "FILTERS" button allows access to information about Data sources of each Block, Block Types, Cube structures, Cube versions and Cube files details.


Whenever a Cube is added as a Data Block without Entities in the axes and no Selections applied, the displayed value is always the sum of the underlying Cube cells.
If you add a Cube as a Data Block, the Entity list in the Data panel on the left will automatically show only Entities that are either in the Cube structure or at a more aggregate level of the Relationship tree.
If you add an Entity in the axes, the Data list in the Data panel on the left will automatically show only Cubes that have that Entity in their structure or another one at a less aggregate level of the Relationship tree.
If you add an Entity in the axes that's not in the structure of all Cubes added as Data Blocks, in the rows or columns corresponding to those Cubes Board will display the sum of the underlying Cube cells.

When you add an Entity as a Data Block and a directly related Entity in the "BY ROW" field of the Axis area, the following scenarios may occur:
- If the Entity in the Data Block is more aggregate than the one in the Axis area, in the column corresponding to the former the Description of its members is displayed by default. By activating the Data Entry feature on the Data Block, you can edit the Relationship between members of the two Entities
- If the Entity in the Data Block is less aggregate than the one in the Axis area, in the column corresponding to the former the sum of its members is always displayed. This scenario does not allow to modify the Relationship between the two Entities


How to create and delete a Data Block

To create a new Data Block, simply drag and drop Cubes, column algorithms, rules, ranking functions, Entities and Relationships from the Data panel on the left to the Data area on the right. You can also create Data Blocks by clicking the "+" button below the Data area.
To create a Data Block defined by a column algorithm, drag and drop the Algorithm placeholder from the "MORE" tab of the data panel to the Data area or click the "+" button below the Data area and select the Algorithm icon.

The first Data Block of a Layout must be a Cube or an Algorithm.
Click on a Data Block to reveal the Block settings panel on the right-hand side of the page.
You can change the Data Blocks
 order by dragging and dropping them to a different position in the list. To do so, hover over the letter displayed in the row header of the desired Data Block to start dragging it.


To delete a Data Block, hover over it and click on the "X" icon at the end of the row.

Once a Data Block is deleted, letters in row headers will adapt accordingly to keep the alphabetical order and to maintain calculations consistent.


Learn how to: