Create Multiple Hierarchy using Dimension or Subset

Post Reply
Raveuk
Posts: 1
Joined: Fri Jan 03, 2014 4:17 am
OLAP Product: tm1
Version: 10.2
Excel Version: 2010

Create Multiple Hierarchy using Dimension or Subset

Post by Raveuk »

Hi All

I am new to this forum. Hope I have posted this post in right section.

I am new to Cognos TM1 and would like if someone can help me to solve this issue I am facing.

I am using TM1 10.2 performance modeller, have a product dimension called master product with hierarchy and I would like to update product dimension using T1 graphical interface in performance modeller 10.2.
issue is when I select data source as dimension/subset as ALL members it gives me list of the master product dimension in a list form.
e.g

TOTAL
Parent Name 1
Parent Name 2
parent Name 3
children 1
children 1
children 2
children 3

in the master product dimension hierarchy is
Total
- Parent Name 1
- Children 1
- Children 1
- Parent Name 2
- Children 2
- Parent Name 3
-Children 3

In the mapping section of performance modeller it only shows me as one dimension to map which is master product . I have tried to create levels using variable expression but still it doesn't work pulse cognos documentation is not that helpful.

can anyone help me to solve this and how to get it map.

Thank you
Post Reply