Tricks and tips for everyone


What are the different impersonation options available in SSAS?

What are the different impersonation options available in SSAS?

There are FOUR types available in which you can impersonate Data Source.

  • Use a specific Username and Password.
  • Use the Service Account.
  • Use the credentials of the Current User.
  • Inherit (in SQL 2008 and above)/ Default (SQL 2005).

What is impersonation in SSAS?

Impersonation is to specify which account to be used by the cube to connect to the relational database. Analysis Services is a Windows service, running as SSAS service account. (to view this, double click the SSAS Service from control panel, then click on the Log On tab, see screenshot below).

How do I change data source in SSAS?

Expand the database folder, open the Data Source folder under the database name, right-click a data source in Object Explorer and select Properties. Optionally, modify the name, description, or impersonation option. For more information, see Set Impersonation Options (SSAS – Multidimensional).

How do I give someone access to my SSAS database?

In this article

  1. Step 1: Create the role. In SSMS, connect to Analysis Services.
  2. Step 2: Assign Membership. In the Membership pane, click Add to enter the Windows user or group accounts that will be accessing the cube using this role.
  3. Step 3: Set Cube Permissions.
  4. Step 4: Test.
  5. Step 5: Script role definition and assignments.

What are SSAS roles?

Roles are used in Analysis Services to manage security for Analysis Services objects and data. In basic terms, a role associates the security identifiers (SIDs) of Microsoft Windows users and groups that have specific access rights and permissions defined for objects managed by an instance of Analysis Services.

What is data source view in SSAS?

A Data Source View in SSAS is a set of tables or views from the database that is required to design the cube (We can call this as data set). Analysis services can only access the tables or views inside the Data Source View, anything outside the Data Source View is not accessible.

How do I open data source properties?

You can open data source properties by using one of the following options:

  1. Navigate to File | Data Sources.
  2. Press Ctrl+Alt+Shift+S .
  3. In the Database Explorer (View | Tool Windows | Database Explorer), click the Data Source Properties icon. .

Related Posts