After creating a lookup relation on an MDA Data - Object, in the report builder you can use the MDA Data - Object to generate a report.
Note: Please get in touch with your administrator for creating a lookup relation on an MDA Data - Object.
The following image highlights how various collections such as Account Name and Active User are related to JP Tree6 Usage Data.
Note: You will be provided with only 2 sub-level objects containing lookup relation. For example, in the following image JP Tree6 Usage Data > Account Name > Active User, where JP Tree6 Usage Data has a lookup relation on Account Name and Account Name has a lookup relation on Active User. However, you cannot have an MDA Data - Object containing lookup relation at the third sub-level, such as JP Tree6 Usage Data > Account Name > Active User > [Another Collection Name containing lookup relation].
Sample Use Case
You might want to generate a report on the number of CTA Type Names that have been generated by Industry. In this report Base Redshift Collection::Industry is a child of Redshift Child Collection, which contains CTA Type Name.