Entities & relationships

Allows selecting an entity to display in a column of the report.

When selecting an entity in a Layout block,

• if the chosen entity is a parent (more aggregate) or equal to the entity set in the Layout rows, then the name of the parent member is returned.

• if the chosen entity is a child (less aggregate) or not related to the entity set in the Layout rows, then it returns the count of members in the child entity.

The drop-down list to the right, allows selecting what part of the entity should be displayed: the code, description or both.

For example, let’s consider a Layout where

• the entity Product Group is set in the "By Row" axis,
• the Product entity in a block will return the number of products within each product group, because Product is a child entity of Product Group.
• the Division entity in a block will return the division to which the product group belongs (assuming the entity Division is a parent of Product Group).