When creating a new project, Infotools Harmoni uses an algorithm to automatically grid Learn more about automation. the common questions and answers in your source data.
New grids can be created using any items, but only really makes sense when there is a commonality in the element list.
Grids not only make analysis easier, but they are also a very efficient way to create nets, add bases, add values for averages, etc. across axes and elements all in one go.
In this article
1. Create a grid
A new grid can be created by selecting multiple axes and then choosing to add grid under grid from the design menu. Before creating a grid make sure labels across sources are harmonized. Currently, you can't harmonize items once they are included in a grid.
Before creating a grid or adding items into a grid, make sure labels are harmonized across sources.
To create a grid:
- Select a group of items in your project tree. Items should have a common element list.
- Select add grid under grid.
2. Add items to a grid
Axes can be added into an existing grid by just dragging them in. This only makes sense when elements are similar.
- You can drag standard axes, combined axes, and value axes into a grid.
- You can drag axes from one grid to another.
- You can also combine grids by dragging a grid header into another grid header.
Before adding items into a grid make sure labels across sources are harmonized.
The properties of the elements in the grid into which you are dragging take precedence.
- Any elements that merge with existing grid elements will inherit their properties that i.e. hide/show, values, bases and combined elements that don’t already.
- If the elements you are adding already have hide/show, values or bases set, they will be overwritten with those in the grid.
- Standard elements or combined elements in the axes being added with the same name as a combined element in the grid will be merged.
Currently creating new elements in a grid (construct/new element) is not supported.
When performing undo after an add to grid action, the action that is being undone is the add to the grid only, not the consequences of that action.
Any properties that have been inherited from the grid (hide/show, value, bases, combined elements) will remain in the axes after they return to their position outside of the grid.
- Nets can be added to a grid by selecting combine items under construct from the design menu.
3. Remove grids
A grid can be split back out into individual axes, that is some axes from within the grid or the grid altogether.
- To remove the group altogether, you can use remove grid; this action will break it into separate standard axes.
- An individual axis can be removed by dragging and dropping out of the grid.
When removing a grid or items from the grid, you have the option to preserve or revert to the original labels of the items. If you have already done some label changes, you may want to maintain these.
Once split, standard axes will go back to their original location in the project tree.
Before removing a grid make sure it is not used in any views, stories or dashboards, else they will become invalid even when you recreate the grid.
To remove a grid:
- Select the grid header in your project tree.
- Select remove grid under grid from the design menu.
- You will be given the option to preserve or revert to the original labels. You can also cancel the action.
- The grid will be broken into separate standard axes. These will go back to their original order in the project tree.
3. Copy and paste
You can copy axes and elements out of a grid, but you can't copy and paste into or within a grid. An alternative is to use drag and drop.
Where to from here?
Learn more about constructions.