Morning all. I think I already know the answer to this but does anyone know of a way to model a ragged or unbalanced hiearchy in FM?
The situation is this;
I have some data items that can be modeled as a hierarchy, the problem is I don't know how many levels there are and different instances of the data item can have different numbers of levels.
Any help appreciated as always.
Thanks
Simon
Quite often ragged hierarchies are caused by some sort of recursion in the data-structure. The most widely used example is that of the manager-employee relationship. It is possible to unravel such a structure by means of an ETL proces or a recursive SQL view, but nevertheless if you want to model this in FM you will still need to assign the levels (and know how many there will ultimately be)
From what we gathered on DMR ragged dimensions are a no-no. This is still a drawback compared with the 'old' C7 cube technology.
An unbalanced hierarchy (different depth of levels) should be possible, but I suspect you need that you do need to repeat the lowest leaf member to the deepest level that exists in the model.
Thanks Blom that's pretty much the conclusions I was coming to