Cubes contain all of the settings that define storage, aggregation levels, and processing frequency.
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.
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.