Create metadata elements from the physical tables Performance Management Architect in your data source. These metadata elements can be used later to create dimension elements and hierarchies, which you can then use to build a cube schema.
To create metadata elements:
In Create Metadata Elements, in the Available Source Objects list, select which objects to add to the folder for this data source in the Metadata Navigator.
To add all objects to the Metadata Navigator, select the check box next to the data source name at the top of the Available Source Objects list.
To add only selected elements to the Metadata Navigator, select the check box next to the names of the elements that you want to add.
Alternatively, to add particular children of an object to the Metadata Navigator, expand the element and select the check boxes next to the names of the children objects that you want to add.
Optional: To store the metadata elements in a folder other than the default folder:
You should be able to view the new metadata elements listed in the Metadata Navigator. Additionally, expand the data source name in the Source Navigator to view the dimensions and levels of this data source.