Level member columns cannot be compound. Teradata Schema Workbench allows you to only select a single Member Column when defining a level. If you need a compound key, do one of the following:
- Change your model, that is the hierarchy table, so there is just a single ID key. This is the best option.
- Create a view of the hierarchy table that combines the underlying columns, perhaps again by concatenation.
- Change your model to two levels, where one level takes you down using one column and the next level below uses the other column.