Can you try creating two different logical tables(Split the BMM Table in to two) and create dimension hierarchies.
thanks for your reply, but as described in my post, i have followed your suggestment already, but it doesn't work because i can create different logical tables but theirs source table is always TPROD_TDB and OBIEE 11g doesn't permit to create multiple hierarchies on same dimension.
1 person found this helpful
You can have multiple hierarchies per logical table but they must imperatively all share the same lowest level of detail.
If the heirarchies have different levels and lowest levels of detail then by OBI's rule sthey have to be two logical tables. Period.
Yes, that's what I said. Is there something specific you wanted to point out with that blog post?