Open 'BI Administration' tool and Open offline or online Repository and provide password.
On Physical Layer 'Oracle Data Warehouse ' extend 'Catalog' and SELECT 'W_PRODUCT_D' and select (Press CTRL key from ur keyboard) tables ' Dim_W_PROD_CAT_DH_Purchasing , Dim_PROD_CAT_DH_General, Dim_W_PROD_CAT_DH_UNSPEC
Select Physical Diagram
Selected Objects Only
Click on 'New Join' and Click on One W_PRODUCT_D Table and second click on 'Dim_W_PROD_CAT_DH_Purchasing'
specify column and do so forth for other tables.
Save and Load RPD.
Sher ullah baig
Thank you very much for providing detailed steps!
There another related to my problem question.
As our OeBS (its our OLTP source database) consultant says, we have and product hierarchy (Analitics) configured with the flexfields and 3 segments - 1,10,11. I think that I have to set up this hierarchy with the help of the document mentioned in my previous question. Am I right?