Based on this article
We tried to implement perspectives with on our environment in which we are running sql server 2019 standard edition locally with SSAS. Nonetheless, you can only create perspectives if you have SQL Server Entreprise edition, which renders the functionality mentioned in the article above to not work. (Or standard edition if you have Azure Analysis services). Look at topic below:
Therefore, we suggest to possibility to be able to select which table you want to be able to be seen per endpoint, like in the case of roles per endpoint. For you roles you can either select to which endpoint a role is dedicated or vice versa.
We suggest to implement the same ability but then with objects within the semantic layer (measures, tables, columns). What this would practically mean is that instead of having one endpoint, which creates one table in SSAS with multiple perspectives, you would have a database for each endpoint created with the tables that you selected. Which means it could look something like this (excuse me for my photoshop skills)
Again, this would solve the issue that we mentioned above for users which are locally hosting. Nonetheless, this could also turn out to be useful for other scenarios. Which could potentially be mentioned in the comments below from other users.
