Hello addicted2cognos,
You can open report studio against the Metric Studio package and create what you want to see. Once you open the package you should see three folders within the package. One of them is Presentation. If you expand that you will see a namespace called "Relational". You can use the objects in that namespace to create your reports.
-Cognos810