Create Attributes in Bulk

Starting in Strategy (October 2026), architects can simultaneously create multiple attributes using the new bulk attribute editor. The tables and columns available in the project are searched to automatically identify attribute candidates based on configurable rules. Architects can quickly generate attributes whenever a new source is connected or an existing one is expanded, improving consistency, reducing the risk of misconfigured attributes, and significantly speeding up model setup.

Create Multiple Attributes

  1. Ensure that the Mosaic schema for your new attributes is available for editing. You can unlock the schema in the Schema Editor by clicking the lock icon for the project.
  2. In the Navigation pane, click Objects.
  3. In the top right corner, click Create New Object and select Bulk Attribute Creation
  4. Bulk attribute editor opens.

    5. Starting from this point Mosaic schema is locked.

  5. Candidate columns for ID form of new attributes are pre-selected based on default set of rules. You can continue with the pre-selected columns or define rules suitable for your data source design.

    6. Define Rules

  6. Click on the Define Rules button in the top right corner of the editor.

  7. Under Column Data Type, select the data types used to define the ID columns in your data source. Only columns with data types selected here are displayed as candidate ID columns for new attributes.
  8. Under Attribute Name, define the rules to determine how the name for the attribute is created, based on the name of the column. These rules follow the most common naming convention principles for naming the ID column.
  9. Under Warehouse Search, define additional rules to determine which column should be used as the ID field and which column should be used as the description field, as well as to identify which table should be set as the lookup table based on the table name specified in the rule.
  10. Click Done to close the Define Rules dialog box and go back to bulk attribute editor.

    11. The rules are saved for future use.

    Create Simple Attributes

  11. Under Available Columns, select Attribute tab. A list of candidate columns is displayed in a table.

  12. Under Column Name, select the check boxes next to the column names you want to use to create new attributes.
  13. You can search for columns by typing their names in the Search Box.
  14. Use the View Selected toggle to display only the selected columns.
  15. When your selection is complete, click Add as Attribute. The attributes based on the selected columns are created and displayed under Attributes.

    16. Create Compound Attributes

  16. Under Available Columns select Compound Attribute. A list of candidate columns is displayed in a table.

  17. Under Column Name, select the check boxes next to column names you want to use to create a new compound attribute.

    18. Compound attribute can be created using multiple columns from one lookup table. When you select one column, the list of other available columns is automatically filtered by the lookup table of the selected column. Other columns are grayed out.

  18. You can search for columns by typing their names in the Search Box.
  19. Use the View Selected toggle to display only the selected columns.
  20. Click Add as Compound Attribute. The attribute is added to the list of attributes.
  21. Repeat these steps to create more compound attributes.

    22. Edit Attributes

  22. Under Attribute Name, the automatically generated name of the attribute is displayed. Right-click the name and select Edit to change the name.
  23. To remove an attribute from the list, right-click the name and select Delete.
  24. Under Description Column, a suggested description column is displayed. The suggestion is made by applying the attribute creation rules defined under Warehouse Search to the columns in the lookup table. All data types are considered.
  25. To change the description column, use the drop-down menu and choose from other columns available in the lookup table.
  26. If an attribute does not need a description form, select Use ID as description. In this case only one attribute form is created.
  27. Selected lookup table is displayed under Lookup Table Name. If more than one table matches the rules for identifying the lookup table, use the drop down next to the table name and choose the correct one.
  28. For compound attributes, click Edit next to the lookup table name to display the lookup tables for all the columns used in the attribute definition.

    29. Define the Relationships

  29. In the Children column you can define child attributes. Click Edit to open the children editor dialog box.

  30. From the list of available attributes check the names of the children attributes.

    31. Only the attributes created in the bulk edit are available to create relationships. To define relationships with other attributes in the project, use the attribute editor after the bulk edit is complete.

  31. Use the Search Box at the top of the editor to search for attributes.
  32. Toggle View Selected on if you want to display only the selected attributes.
  33. Under Relationship Type define the relationship between the attributes.
  34. Click Done. The relationship is created.
  35. Once all edits are complete, click Save. The new attributes are created in the Attributes folder.

    36. Mosaic schema is released. Reload the schema to use new attributes in your project.