Database Reference
In-Depth Information
Figure 9-7.
Comparing Excel reports from both tables and cubes
SSAS Projects
Now that you know what a cube is, the question is how to make them. You can create them programmatically
using either MDX or XMLA; however, most of the time you want to use Visual Studio instead. The process of
creating a cube is easier in Visual Studio because of the graphical presentation and wizards that walk you through
the process.
To start creating your cubes with Visual Studio, begin by creating an SSAS project. In Figure
9-8
a new SSAS
project is added to the PublicationsIndustries solution.
