SSAS - Dimension

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

1 - Time

Time dimensions are distinct from other dimensions because SSAS contains inherent functionality to group the members into levels. SSAS has built-in logic that puts the correct days into the correct months and the correct months into the correct quarter.

You can either use a Server Time dimension, or use a dimension table that contains time data. Server time dimensions contain hierarchies, levels, and attributes, but these are stored on the server rather than in a separate dimension table.

2 - Management

2.1 - Permission

By default, a role that has access to a cube has read access to all of the dimensions in the cube. But access can be denied to one or more members in the dimension.

The default access is read-only, so users cannot process the cube. However, if you change the permissions of a relevant role to read/write, it will enable users to process the cube.

By default, permissions apply to all dimension members, but an MDX statement can be written to define a subset of the dimension.

An MDX statement can be used:

  • for an allowed member set or a denied member set.
  • to define a default member to control which member users see when they first connect to the cube.
  • to create versatile default members. For example, to use the current calendar year as the default member of a time dimension.