I have to create two hierarchies
1.) Year-Quarter
2.) Year-Month, on the same dimension table.
As we know, when we create multiple hierarchies the leaf node should be same in both the hierarchies, in that case guide me how to deal with different leaf nodes on the same dimension table?
Different logical dimension tables.