EXPORT ORACLE WAREHOUSE BUILDER METADATA TO ORACLE DISCOVERER
www.keysoft.co.in
Copyright Keysoft Solutions
Metadata to Discoverer
To export the ETL Process (i.e. EGSS_WAREHOUSE) to discoverer, use the following steps
www.keysoft.co.in
Copyright Keysoft Solutions
Metadata to Discoverer Step 1 : Select the Collections in OWB. Step 2 : Right-Click the collections and select the create collection.
www.keysoft.co.in
Copyright Keysoft Solutions
Metadata to Discoverer Step 3 : Type the collection name as SALES_META and then Click Next. Step 4 : Select the Dimensions, Cube for the collection and then Click Next. Step 5 : Click Finish
www.keysoft.co.in
Copyright Keysoft Solutions
Metadata to Discoverer Step 6 : Now Export the SALES_META object to Discoverer using transfer Wizard.
www.keysoft.co.in
Copyright Keysoft Solutions
Metadata to Discoverer Step 7 : Select Project, then Metadata Export, and then click Bridge.
www.keysoft.co.in
Copyright Keysoft Solutions
Metadata to Discoverer Step 8 : Oracle warehouse Builder Transfer wizard: Welcome windows will open Step 9 : Click Next.
www.keysoft.co.in
Copyright Keysoft Solutions
Metadata to Discoverer Step10: Select the option Oracle9i Discoverer and then Click Next.
www.keysoft.co.in
Copyright Keysoft Solutions
Metadata to Discoverer Step 11: Enter the Parameters
Step 12: Click Next and then click Finish
www.keysoft.co.in
Copyright Keysoft Solutions
Metadata to Discoverer Step13: Click OK
The Metadata is exported successfully to discoverer. You can use this metadata in Discoverer Administrator
www.keysoft.co.in
Copyright Keysoft Solutions
About Keysoft
For Training on BI visit: http://www.keysoft.co.in/training.aspx or mail us at
[email protected] For BI Services mail us at:
[email protected]
www.keysoft.co.in
Copyright Keysoft Solutions