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.
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.
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>.
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.
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
Try this
Double Click on your data source under solution explorer -> Navigate to Impersonation Information
tab -> Choose inherit
Now try processing it again.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With