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?
Quote from: ninjamayo on 31 May 2016 09:06:51 AM
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.
OK so basically the balanced property doesn't really work within FM.
Quote from: ninjamayo on 01 Jun 2016 04:38:32 AM
OK so basically the balanced property doesn't really work within FM.
What do you mean by "the balanced property"?
MF.
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.
Quote from: ninjamayo on 01 Jun 2016 09:23:08 AM
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.
OK thanks, that is useful to know actually