Structure your Framework Manager

A model is normally structured into two layers/views. Database/ Physical view and Business/ Presentation view. These can be implemented using Namespaces.

You import the metadata into Physical layer from DB using data source connection. You will use Import Metadata Wizard. You will change the Query Subjects & Query Items, create relationships (joins) and other activities here.

In the Presentation layer, you create Query Subjects taking input from the existing Physical layer. You change the names of the Query Items and other cosmetic modifications.

You can choose only the Presentation layer while creating the Packages and apply appropriate security settings.