Its been quite some time since I last touched OBIEE and I am finding I seem to have either forgotten quite a bit, or I knew a lot less then I thought
In the Business Management (BMM) layer, I was looking at a logical table source.
Specifically I was looking at a logical table source and its "Content" tab
I noticed most logical table sources on the Content tab, there's generally at least one Hierarchy showing up. But I noticed on a fact table, and one other dimension table that there seems to be multiple hierarchies listed under the "Logical Dimension" column as shown below
I was just wondering, how does this "Logical Dimension" column get populated?
I am a bit confused as to how certain tables can have such a long list of Hierarchies, and I'm not sure how these get populated?