SSAS - Cube

1 - About

Cubes contain all of the settings that define storage, aggregation levels, and processing frequency.

2 - Management

2.1 - Creation

2.2 - Designer

If there are three relationships defined between a fact table and a table (generally a time table), it will create a dimension for each relationship. Fro instance, a dimension for each related date column such as Due Date, Order Date, Ship Date.

2.3 - Permissions

By default, a role that has permissions for the cube has:

  • Access to the individual cells within the cube.
  • Read permissions on the dimensions and dimension members that the cube contains.

Data Science
Data Analysis
Statistics
Data Science
Linear Algebra Mathematics
Trigonometry

Powered by ComboStrap