Creating OLAP sets for measures

Every measure must be linked to the Measure Type (Units, Currency, and Date) and the UOMs (unit of measure) sets. The application generates these sets in OLAP, based on the measure types and UOM when the measure dimension is created in a cycle or module. Each set contains measure elements (names) in the {[element1],[element2],..} format. The process is initiated when you start or update (refresh) the cycle period data.

These sets are used to calculate data or identify a specific group of elements based on the Measure Type or UOM (for example, formatting) in the worksheets.

One set for each distinct measure type (SET_TYPE_Units, SET_TYPE_Currency, SET_TYPE_Date...) is created. For example:

  • SET_TYPE_Units = {[BUNITS],[FUNITS],[HUNITS], ...}
  • SET_TYPE_Currency = {[BCOST],[BREV],[BSELL], ...}

One set for each distinct Unit of Measure (UOM), labeled SET_UOM_ and the UOM name, is also created. For example:

SET_UOM_USD, SET_UOM_EUR, SET_UOM_Units, SET_UOM_Each, ...}