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.