IBM Support

New options to control the auto-generation of predefined relative time members in IBM Cognos Cube Designer 10.2.1.1 Fix Pack 3

Product Documentation


Abstract

You can now control the auto-generation of predefined relative time members.

Content

You can now auto-generate the following relative time members:

  • prior period members
    For more information on these members, see the IBM Cognos Dynamic Cubes User Guide.
  • next period members
    For more information on these members, see http://www.ibm.com/support/docview.wss?uid=swg27040513.
  • the sub tree of reference members for all relative time members

    Relative time reference members are relative time members that refer to regular members within a time hierarchy. They have the same caption and business key value as the members to which they refer.

    In the following screenshots, you can see the first level of reference members highlighted in blue.



    The purpose of the reference members is to show the sub tree of the hierarchy that a relative time member corresponds to.

    By default, the sub tree of reference members is generated. Depending on the hierarchy structure, there may be a large number of reference members, and you can now exclude them from being auto-generated.

Steps



1. From the Project Explorer tree, right click the hierarchy you want to work with, and then select
Open Editor.

2. Select the Relative Time tab.

3. Select one of the following options for prior period members:

  • Auto-generate members to include predefined members (default).
  • Do not auto generate members to exclude predefined members.

4. Select one of the following options for next period members:
  • Auto-generate members to include predefined members.
  • Do not auto generate members to exclude predefined members (default).

5. Select one of the following options for the Reference Relative Time Members Subtree:
  • Include to include a sub tree of members (default).
  • Exclude to exclude a sub tree of members.

[{"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Cube Designer","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.2.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
17 June 2018

UID

swg27041029