SSAS - Cube

> Database > SQL Server - SQL Server Analysis Services (OLAP)

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.

Advertising

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.