What is Impersonation Information in SSAS?
SSAS interview Questions : Explain what is Impersonation Options in SSAS? When creating a data source object in an Analysis Services model...
When creating a data source object in an Analysis Services model, one of the settings that you must configure is an impersonation option. This option determines whether Analysis Services assumes the identity of a specific Windows user account when performing local operations related to the connection, such as loading an OLE DB data provider or resolving user profile information in environments that support roaming profiles.
How set impersonation options in SQL Server Data Tools
- Double-click a data source in Solution Explorer to open Data Source Designer.
- Click the Impersonation Information tab in Data Source Designer.
- Choose an option described in Impersonation options in this topic.