SSAS - Cube

About

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

Management

Creation

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.

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.

Powered by ComboStrap