Unbalanced hierarchy not working

[ninjamayo]

I have an unbalanced hierarchy that looks like this in my database:

NAME | LEVEL_ONE | LEVEL_TWO | LEVEL_THREE
----------------------------------------------------
Test,      All Members      Accounts         Upgrades
Test2,    All Members      Billing               Information
Test3,    All Members      HR                    null

My hierarchy goes Level_one -> Level_two -> Level_three -> Name and I set it to balanced = false. When I run my report and get the tree I can never see the Test3 under All Members / HR because Level_three is null. Any ideas why?

[MFGF]

I have an unbalanced hierarchy that looks like this in my database:

NAME | LEVEL_ONE | LEVEL_TWO | LEVEL_THREE
----------------------------------------------------
Test,      All Members      Accounts         Upgrades
Test2,    All Members      Billing               Information
Test3,    All Members      HR                    null

My hierarchy goes Level_one -> Level_two -> Level_three -> Name and I set it to balanced = false. When I run my report and get the tree I can never see the Test3 under All Members / HR because Level_three is null. Any ideas why?

Does this help?

http://www.cognoise.com/index.php/topic,21686.msg65967.html#msg65967

MF.

[ninjamayo]

OK so basically the balanced property doesn't really work within FM.

[MFGF]

OK so basically the balanced property doesn't really work within FM.

What do you mean by "the balanced property"?

MF.

[ninjamayo]

Within FM and when selecting a hierarchy you can see there is a property called Balanced and another one called Ragged. Supposedly when setting Balanced to false the tree if unbalanced will show up in Cognos Report properly. I tried that and it doesn't seem to work.

[MFGF]

Within FM and when selecting a hierarchy you can see there is a property called Balanced and another one called Ragged. Supposedly when setting Balanced to false the tree if unbalanced will show up in Cognos Report properly. I tried that and it doesn't seem to work.

Oh - I remember that vaguely. It's specifically for SAP BW if memory serves. Edit - yes it is, I just looked it up. That's a specific option for SAP BW cubes, not for relational data. It's in the FM User Guide, Page 183 onwards: http://public.dhe.ibm.com/software/data/cognos/documentation/docs/en/10.2.2/ug_fm.pdf

You're going to need to balance the hierarchy (ideally in your database) to be able to use it.

Cheers!

MF.

[ninjamayo]

OK thanks, that is useful to know actually