Key Concepts
Understanding the following key concepts is crucial for working with SSAS:
- Tabular Data Models: SSAS uses tabular data models, which are based on tables and relationships.
- Cube: A cube is a hierarchical representation of data that allows you to easily analyze data from multiple dimensions.
- Measure: A measure is a calculation that is performed on data in a cube.
- Dimension: A dimension is a descriptive attribute of data, such as time, geography, or product.
Managing SSAS Cubes
Here are some common tasks you can perform with SSAS:
- Creating Cubes: You can create new cubes to store and analyze your data.
- Modifying Cubes: You can modify existing cubes to add new dimensions, measures, or relationships.
- Deleting Cubes: You can delete cubes when they are no longer needed.