If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

unable to create master detail relationship

Started by veera.1989, 02 Feb 2012 05:13:52 PM

Previous topic - Next topic

veera.1989

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

tjohnson3050

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.

HalfBloodPrince

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.