SELECT FACT.ELEMENTID , FACT.NAME , DIM.ELEMENTID , DIM.NAME , HIER.ELEMENTID , HIER.NAME FROM CMPWBCUBE_V FACT , CMPFOREIGNKEY_V FK , CMPUNIQUEKEY_V UK , CMPWBDIMENSION_V DIM , CMPITEMHIERARCHY_V HIER WHERE FACT.ELEMENTID = FK.OWNINGRELATION AND FK.UNIQUEKEY = UK.ELEMENTID AND UK.OWNINGRELATION = DIM.ELEMENTID AND HIER.OWNDIMENSION = DIM.ELEMENTID WITH READ ONLY