Pages

Changing/Updating Element Weight or Element Type for a Dimension in Cognos TM1:

Follow the below steps to update/change the element weight or element type for a dimension in Cognos TM1.

Steps:

  1. Expand dimension and select the specified dimension name. For Ex: Say “account1”.
  2. Right-Click on “account1” and also click on “Edit Dimension Structure”, so that Dimension Editor will be opened for the dimension “division” as shown in the Image A.
  3. Select the element in the “division” dimension for which you want to change the element weight.
  4. Right-Click on the element and also click on “Element Properties”, so that Dimension Element Properties window will be opened as shown in the Image B.
  5. Select the element once again and change the Element Weight or Element Type to your requirements as shown in the Image C.

Note: If you change the Element Weight to ‘0’, the data in the element will not be consolidated to its parent element.

In the above case “Sales” element data will not be consolidated to “Gross Margin” element which is a parent of Sales element (please see the Image B).

0 comments:

© 2010 Datawarehousing Support | Home | Disclaimer | Privacy Policy