1. Modeling
  2. Dimensions
  3. Lists
  4. List types

Model builders use lists to group related items in a model. You can create different types of lists that suit your requirements.

Refer to the table below for a description of each list type.

List typeDescription
Flat listFlat lists contain list items with no hierarchy. For example, you can use a flat list for information that does not require structure at multiple levels, such as transactional data. 
Simple list

Simple lists contain list items with a parent/child hierarchy. For example, you can use a simple list to organize employees in different departments. Drag and drop list items to create a hierarchy in one list.

Note: You can only add data to child list items.

Composite hierarchyComposite hierarchies contain multiple lists that each roll up to a parent list. For example, the G3 Location list rolls up to the G2 Country list, and the G2 Country list rolls up to the G1 Region list.
Numbered listNumbered lists contain list items with unique identifiers. For example, you can use numbered lists to manage duplicate names in a model.
List subset List subsets contain list items from larger lists. For example, if you have a long list, you can create a list subset to target specific list items.

Use appropriate name conventions for your lists. For example, if your list contains a group of employees, name it Employees.

Create your list in General Lists in the model settings bar.