Accessing the FoodMart Cubes - How do I do this? 1

[MarleneD]

I noticed that FoodMart,which comes with Analysis Services, has predefined cubes at C:\Program Files\Microsoft Analysis Services\Samples\foodmart 2000\FoodMart 2000\

How can I access these cubes from Analsis Manager?

I loaded the FoodMart database to SQL Server and created a Data Source from Analysis manager.

However, I am not sure how do I access the pre-defined cubes.

Thank you.

 

[MDXer]

under \Analysis Services\Samples there is a Foodmart200.Cab this is the archive for the foodmart DB just restore it to your server and you should be able to access it.

"Shoot Me! Shoot Me NOW!!!"
- Daffy Duck

 

[MarleneD]

Thanks for your post.

How do restore it the cubes for FoodMart to the Analysis Server?

At the moment I DTS the FoodMart Access database into a SQL Server database.

In Analysis Manager, the FoodMart data source is pointing to the SQL Server FoodMart database.

The cubes are still at C:\Program Files\Microsoft Analysis Services\Samples\foodmart 2000\FoodMart 2000