The BMM Dimension is based on Location_D. At first level I have country (1attribute of location_d) and is made as a key for first level. At second level I have state (also as key & 2 attribute of location_d) The preferred drill down path at first level is pointed to second level.
When I try to drop dimension to Presentation layer, it doesnt allow. I do not get any errors during consistency check.
I am using OBIEE10g on a Windows XP system.
Is there anything that is wrong?
Mouse pointer is turning to stop as Circle with / ?
Do you have subject area already defined for that BMM?
Try out creating presentation table under subject area and drag and drop tables columns.
Let me know how it behaves
Mark if helps
If you are creating a Presentation catalog based on BMM then, mouse right click on Presentation layer and create manually and drag and drop from BMM.
If your case is adding column to existing Presentation catalog's Presentation table; See the related BMM to that Presentation catalog, you may use mouse right click and Related to.
If these are not helping send me rpd with details to my email I do it for you.
Mark if helps
You want to copy dimension hierarchy to Presentation Layer?!
In that case a BIG NO, I was assuming dimension table as in dwh you were referring dimension (hierarchy ) as in BMM layer.
Hope this helps. Mark if helps