Choosing pivot table views in db editor is confusing

[PiispaH]

If the user has a database that has 0- and N dimensional entities, alternatives and scenarios, switching between the pivot table views can be a bit confusing. If the db editor is opened and is Scenario pivot view is selected, everything works as expected. However if after that any of the other three pivot table views are selected, the view doesn't actually change. If then a 0-dimensional entity class is selected from the Entity tree, every other view does something except the Element one.

Furthermore if the db editor is opened and the Scenario pivot view selected, going to table or graph view and then selecting any of the pivot table views always opens the Scenario pivot view.

If these views can't be opened shouldn't they just be disabled from the start until they actually have something to show?

[jkiviluo]

The element pivot table choice will not change the the pivot table view unless one chooses an N-d entity class. I think this is because there is nothing to show. However, more logical behaviour would be to make pivot table view empty if no N-d entity class is chosen.

I think it's bit confusing that many things change when changing between views. There is logic to it, since it's trying to show what's relevant, but I hope we could make it more intuitive what happens. But I think it's a matter of bigger design process.

Furthermore if the db editor is opened and the Scenario pivot view selected, going to table or graph view and then selecting any of the pivot table views always opens the Scenario pivot view.

I see this too and it's a bug.