A.To add a level to the structure of a dimension

B.To create aggregations (or pivots) in data

C.To add additional logic to a base input measure or dimension

D.To create custom measures

A.Net Hire Ratio

B.Terminations

C.EOP Headcount

D.Terminations-Voluntary

A.Year -> Quarter -> Month

B.Month -> Quarter ->Year

C.Year -> Month -> Day

D.Year -> Half Year -> Month

A.Derived measures

B.Analysis dimension IDs

C.Structural dimension IDs

D.Base input measures

E.Result measures

A.Tables can be sourced from a Lookup.

B.It supports structural dimensions.

C.Source table records can be spliced across time.

D.It provides full support to calculate hires, movements, and terminations.

E.Source records can be reduced to one active fact record for any point in time.