Relative time calculated members in reports

IBM® Cognos® Dynamic Cubes relative time members are specialized calculated members that are added to a time hierarchy.

The relative time feature generates three types of calculated members

Period to Date Change, Period to Date Growth

These relative time calculated members share the following characteristics with Cognos Dynamic Cubes calculated members.

  • They are considered unique.
  • They do not have siblings or children
  • They should not be nested
  • Their rank value in IBM Cognos Analysis Studio is always null.

Current Period, Prior Period, Current Period to Date, Prior Period to Date

These members behave the same as Cognos Dynamic Cubes calculated members with one exception. These members may have children. Therefore, the functions CHILDREN, DESCENDANT, FIRSTCHILD and LASTCHILD can return results.

These relative time calculated members share the following characteristics with Cognos Dynamic Cubes calculated members:

  • They are considered unique.
  • They should not be nested
  • Their rank value in IBM Cognos Analysis Studio is always null.

Reference relative time members

These members refer to other members within the time hierarchy and have the same caption and member key values as the members to which they refer. Within the context of other reference members, these members behave the same as Cognos Dynamic Cubes calculated members with one exception. These members can have children. Reference members at the same level are siblings of other reference members. When applied to a reference member, functions such as FIRSTSIBLING or NEXTMEMBER will return a reference member.

These relative time calculated members share the following characteristics with Cognos Dynamic Cubes calculated members:

  • They are considered unique.
  • They can be nested
  • Their rank value in IBM Cognos Analysis Studio is always null.