Index (dimension) name clashes - how to handle?

[soininen]

Currently, it is possible to have clashing index names in indexed values, e.g. all nested Map indices are called 'x' by default. Also, it is possible to name the indices as 'parameter', 'entity_class', 'alternative' etc. potentially clashing with "implicit" index names. It is starting to be a bit of a problem already when plotting data in Toolbox (see spine-tools/Spine-Toolbox#2057).

I am not sure if there is much we can do about it with the current design, but maybe this is something we can set straight with the upcoming new database structure with its Dimensions. Any ideas?

[jkiviluo]

Dimensions should handle this. Dimension table will have unique name constraint.