Database Reference
In-Depth Information
Figure 9-10.
Orginazation of an SSAS multidimensional project
We provide a description of each folder in Table
9-3
.
Table 9-3.
The SSAS Project Folders
Folder
Description
Data Sources
A collection of XML files that hold connection strings and configurations.
Data Source Views
A collection of XML files that describe relational tables and their columns and
relationships between the tables. This XML data is presented and configured in
a graphical format within Visual Studio.
Cubes
A collection of XML files that describe the cubes you want to create on SSAS.
This XML data is presented and configured in a graphical format within Visual
Studio.
Dimensions
A collection of XML files that describe the dimensions you want to create on
SSAS. This XML data is presented and configured in a graphical format within
Visual Studio.
Mining Structures
A collection of XML files that describe the mining structures you want to create
on SSAS. This XML data is presented and configured in a graphical format within
Visual Studio.
Roles
A collection of XML files that describe the security permissions you want to
create on SSAS. This XML data is presented and configured in a graphical format
within Visual Studio.
A collection of .NET
.dll
files that contain custom logic to be used by SSAS.
Assemblies
Miscellaneous
A collection of files that you have added to the project but are not a recognized
project extension. Typically these can be developer notes or a collection of MDX
scripts.
