The dimension ‘[ComputerAdministrator]’ was not found in the cube when the string, [ComputerAdministrator], was parsed. The END SCOPE statement does not match the opening SCOPE statement.

This error occurred the first time that I tried to compile the project "FoodMart 2008".  To get around this, I ran the following script to create an entry in the Employee table for me, as described in this thread:

INSERT INTO [FoodMart 2008].[dbo].[employee]
           ,’First Last’
FROM [FoodMart 2008].[dbo].[employee]
WHERE employee_id = 2


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: