Cognos Olap Hierarchy Question

[cognos05]

Hi ,

I am not sure if this was asked before , we are using cognos transformer to build our olap cubes .

And business is requesting for alternate hierarcy in product dimension which is a ragged hierarchy .

So the same lowest level material has 5 parents in one hierarchy and has 3 parents in other hierarchy and not all materials are included in the alternate hierarchy .

I am able to create this alternate hierarcy as consolidations in tm1 but in cognos they are asking for it to be as an alternate hierarchy in cube .

Any suggestions on if this is possible is appreciated .

Hierarchy 1

Team^10^10-1^10-1-100^ABC100
Team^10^10-1^10-1-100^ABC101
Team^10^10-1^10-1-100^ABC102
Team^10^10-1^10-1-100^ABC103

Hierarchy 2
Sports^10-1-100^ABC100
Sports^10-1-100^ABC100

Thanks,

[MFGF]

Hi ,

I am not sure if this was asked before , we are using cognos transformer to build our olap cubes .

And business is requesting for alternate hierarcy in product dimension which is a ragged hierarchy .

So the same lowest level material has 5 parents in one hierarchy and has 3 parents in other hierarchy and not all materials are included in the alternate hierarchy .

I am able to create this alternate hierarcy as consolidations in tm1 but in cognos they are asking for it to be as an alternate hierarchy in cube .

Any suggestions on if this is possible is appreciated .

Hierarchy 1

Team^10^10-1^10-1-100^ABC100
Team^10^10-1^10-1-100^ABC101
Team^10^10-1^10-1-100^ABC102
Team^10^10-1^10-1-100^ABC103

Hierarchy 2
Sports^10-1-100^ABC100
Sports^10-1-100^ABC100

Thanks,

Hi,

It's certainly possible to add alternate hierarchies within a Transformer model - look for "alternate drill path" in the documentation. The alternate hierarchy doesn't need to have the same number of levels as the main hierarchy, either, but they do need to have a convergence level - normally the lowest level - where the categories/members of the two hierarchies tie up. Can you elaborate on the comment about the alternate hierarchy being ragged? Are you saying that different branches within this hierarchy can have different numbers of levels?

Cheers!

MF.

[cognos05]

Hi MFGF,

Some questions here ,

so the lowest level should always be the same if we define alternate hierarchy?

meaning if a material is lowest level in one hierarchy the same material should be the lowest level in other hierarchy ?

What if my first hierarchy has 150 materials and my alternate hierarchy has only 15 materials .

my requirment is my alternate hierarchy only part of my main hierarchy .

[MFGF]

Hi MFGF,

Some questions here ,

so the lowest level should always be the same if we define alternate hierarchy?

meaning if a material is lowest level in one hierarchy the same material should be the lowest level in other hierarchy ?

What if my first hierarchy has 150 materials and my alternate hierarchy has only 15 materials .

my requirment is my alternate hierarchy only part of my main hierarchy .

Hi,

There needs to be a common level where the two drill paths converge. This is normally the lowest level, but it doesn't have to be. All members (categories) would need to exist on the convergence level though.

If you have different materials in each hierarchy, then this sounds more like a subdimension than an alternate drill path?
https://www.ibm.com/support/knowledgecenter/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.ug.cogtr.doc/t_createunblhierar.html#CreateUnblHierar

MF.