Microsoft Office Tutorials and References
In Depth Information
Figure 1-35. Executing a simple MDX query
OK, so far you’ve seen the basic cube (using one from the AdventureWorks database) and also how to query from
the cube using a simple MDX query. Let’s now begin a simple exercise to build a cube from scratch.
Using data from the Sales Repository example you saw earlier, let’s configure a cube using the Dimension and
Fact tables you created manually with the AdventureWorksDW database:
Once you have the data from SSIS in the designated tables (structured earlier in this
chapter), you can create a new project under SSAS.
Open SSDT, and create a New Project by selecting Analysis Services Multidimensional and
Data Mining Project.
Provide a valid project name, such as AW Sales Data Project, a Location, and a Solution
Name. Click OK.
A basic project structure is created from the template, as you can see in Figure 1-36 .
Figure 1-36. The basic AW Sales Data Project in Solution Explorer
Search JabSto ::