[BUG] Tenants not working properly, until setting enable_aggregation_view

[Szwendacz99]

Describe the bug

By default, after enabling multitenancy in dashnoards and securityplugin, tenants other than Global, don't work properly in dashboards. Basically after adding index pattern, the pattern is missing everywhere in dashboards, even tho it seem to have been added in the index storing the private tenant. Listing Saved Objects fails like on the screenshot below.

To Reproduce
Steps to reproduce the behavior:

1. Setup multitenancy in securityplugin and dashboards config
2. Enable private tenants
3. login to a user
4. Switch to private tenant
5. Try viewing "Saved objects" in old GUI, or "Assets" in new GUI
6. Try creating new index pattern and then browse it in discover

Expected behavior
I see the private index pattern in Saved Objects, and in discover

OpenSearch Version
3.5.0, but also tested on 3.2.0

Dashboards Version
3.5.0, but also tested on 3.2.0

Plugins

Only the default plugins, tested on rockylinux9 rpm package, and via official container images from dockerhub

Screenshots

Host/Environment (please complete the following information):

• OS: Tested on Rockylinux 9, and via podman-compse with official images from dockerhub
• Browser and version: Firefox 148.0

Additional context
After enabling aggregate view described in https://docs.opensearch.org/latest/security/multi-tenancy/mt-agg-view/
it start to work. But I prefer not to use config, described as "experimental" on production.

[Szwendacz99]

Apparently Dashboards cannot handle custom opensearchDashboards.index name when using multitenancy and securityplugin.... Setting it to default .kibana and the same in config.yaml of securityplugin config fixes the issue :(

[abbyhu2000]

@opensearch-project/admin Please transfer this issue to https://github.com/opensearch-project/security-dashboards-plugin

[cwperks]

@Szwendacz99 Thank you for filing this issue. yes, there are issues when using a non-default dashboards index and there's quite a bit of work remaining to get custom index working well. I'll try to compile a list of issues outstanding.