COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: veera.1989 on 02 Feb 2012 05:13:52 PM

Title: unable to create master detail relationship
Post by: veera.1989 on 02 Feb 2012 05:13:52 PM
hi everyone,

i am using cognos 8.4

i am unable to create master detail relationship between two lists 

when i try to do it it shows me error message : no master query context can be found for this object

can any body explain the reason behind the problem

thanks
veera
Title: Re: unable to create master detail relationship
Post by: tjohnson3050 on 02 Feb 2012 09:11:57 PM
You need to put one list inside a second list.  Select the imbeded list, then set the master detail relationship property and define the relationship.
Title: Re: unable to create master detail relationship
Post by: HalfBloodPrince on 02 Feb 2012 10:36:44 PM
Steps:These steps describe how to have two lists on a single page, and have a Master Detail relationship between them.

1. In Report Studio, insert two lists on one page.

2. Add the required columns to both lists.

3. In the master list, group the column that is to be used as the link in the master detail relationship.

4. Insert a filter into the master list so that you only see the records that you want to see in the child list.

5. From the View menu, select Report Pages.

6. Click anywhere on Page1 to enable the Properties pane on the bottom left of the screen.

7. In the Properties pane, under Data\Query link the master query to the page.

8. Double-click anywhere on Page1 to return to the report layout screen.

9. Click anywhere on the detail query. From the Data menu, click Master Detail Relationships.

10. Create a New Link to establish the appropriate relationship between the two queries.

11. Click OK.