We have an OLAP project which uses Sharepoint 2013 Excel Services to show excel files that contains external data from SQL Server Analysis Services (SSAS) cube.
Our Authentication method to login users is FBA (Forms Based Authentication) Our Goal is to show only subset of data from SSAS cube for each user based on their role which has already been defined in SSAS side. Because of using form based authentication, roles don’t apply on excel files from ssas, Any Idea?
Finally we use Customized windows authentication form to handle this topic