Trying to process a cube but get an error when issuing an impersonation

I built a cube in Business Development Intelligent Studio (BIDS) using some database called "Test_cube", which consists of a table of product sizes, a table of customer metrics and a table of order facts.
Product table attributes: prodID-primary key, prodname, prodtype, prodcost
Customer table attributes: custID-primary key, custname, custloc
Order table attributes: orderID, prodID, custID, quantity, unitprice, totalprice where the primary key was set to orderID , prodID, custID

But I had some errors while trying to deploy a cube, for example

Internal error: operation failed.
The data source, "Test_cube", contains an ImpersonationMode, which is not supported for processing operations.
Errors in a high-level relational engine. Cannot connect data source using DataSourceID "Test_cube", name "Test_cube".
Errors in the OLAP storage module: an error occurred during the measurement, with the identifier "products", the name "products" was processed.
Errors in the OLAP storage module. An error occurred while processing the "prodID" attribute of the "product" dimension from the "Test_cube" database.
Server: The current operation was canceled because another operation in the transaction failed.

+4
4

Impersonation Informationinherit

.

+11

" " , ,

+7

, .

, , , , .

: , VS2012 .

: , SSAS . , .

+1

. , , SSAS . SQL Server, , Process continue else Error.

.

First add your user to the SSAS server administrator. Right-click on the Microsoft Analysis Service. Instance and Point Properties -> Security -> Server Administrators -> add your account.

Then go to Data Source Properties → Security Settings → Impersonation Information → Use a specific username and password for Windows → and specify your username and password. Server Admin

Processing will also continue.

+1
source

All Articles