Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Trying to process the cube but getting the error at impersonation information

I have built a cube in Business Development Intelligent Studio(BIDS) using some database with the name 'Test_cube' which consists of Products dimension table, customers dimension table and orders fact table.
The products table attributes :prodID-primary key,prodname,prodtype,prodcost
The customers table attributes :custID-primary key,custname,custloc
The orders table attributes :orderID,prodID,custID,quantity,unitprice,totalprice-calculated query column where primary key was set to orderID,prodID,custID

But I got some errors while trying to deploy the cube like

Internal error : The operation terminated unsuccessfully.
The datasource,'Test_cube', contains an ImpersonationMode that is not supported for processing operations.
Errors in the high-level relational engine.A connection could not be made to the datasource with the DataSourceID of 'Test_cube',Name of 'Test_cube'.
Errors in the OLAP Storage engine: An error occurred while the dimension, with the ID of 'products',Name of the 'products' was being processed.
Errors in the OLAP storage engine: An error occurred while the 'prodID' attribute of the 'products' dimension from the 'Test_cube' database was being processed.
Server : The Current operation was cancelled because another operation in the transaction failed.

like image 204
Manu'sa Bora Avatar asked Sep 01 '14 04:09

Manu'sa Bora


People also ask

How do I process a cube in Visual Studio?

To process a specific cube, follow these steps. In SQL Server Management Studio, connect to your Analysis Services instance. In the tree view, right-click the cube, and then click Process. The Process Cube – [Cube Name] window is displayed.

What is impersonation in SSAS tabular?

Impersonate AccountSpecifies the model use a Windows user account to import or process data from the datasource. The domain and name of the user account uses the following format:<Domain name>\<User account name>.

How do I process a cube in SQL Server?

In the Object Explorer Pane, expand the Analysis Services Instance, expand Databases and then expand the Analysis Services database that contains the cube which needs to be processed. 3. Right click the cube to be processed and then click the Process option from the drop down list as shown in the snippet below.


2 Answers

I used 'Use a specific username and password' and typed in the username and password I use to log into my PC and it worked

like image 120
Akila Weeratunga Avatar answered Nov 03 '22 21:11

Akila Weeratunga


Try this

Double Click on your data source under solution explorer -> Navigate to Impersonation Information tab -> Choose inherit

Now try processing it again.

like image 42
Anand Verma Avatar answered Nov 03 '22 20:11

Anand Verma