Can I please get some help in the following scenario?
I have a Dimension table in the physical layer of the RPD.
That dime table is added as a Logical Table source for many other dimensions in the BMM layer.
My question here is, can I create a separate dimension in BMM layer which has only the above mentioned dimension table as its LTS and create a hierarchy out of it?
If yes, then should the newly created dimension be joined to all the facts in the BMM layer?