Cognos - Master detailed relationship

GeekInterview.com > Interview Questions > Data Warehousing > Cognos

Go To First | Previous Question | Next Question

Cognos | Question 134 of 180

Master detailed relationship

Can you apply the Master detailed relationship between Query studio report and report studio report? how?

Total Answers and Comments: 5

Last Update: March 17, 2009 Asked by: sathyajagadeesh

Sponsored Links

Best Rated Answer

—

Submitted by: angel987

master detail relationship cant be applied. You can drill through from a report in report studio to query studio.

Above answer was rated as good by the following members:
nilesh_tiwari

February 04, 2008 05:11:25

iksharan

Member Since: February 2008 Contribution: 6

RE: Master detailed relationship

We Can Apply the Master Detailed Relationship only in Report Studio bcz there we can Merzing two tables like Repeater and List table. Provided in both the table we supposed to have 1 common Relationsheep.

Is this answer useful? Yes | No

February 13, 2008 16:13:14

chandrarekha

Member Since: May 2007 Contribution: 14

RE: Master detailed relationship

we can achieve this by using report studio in report studio we gave a option drill throgh report navigate from summary to detail information we can get this by parent and child reports . parent report contain summary info and child report contain detail info to make a connection b/w parent and child u should have a commoncolumn in both the tables

Is this answer useful? Yes | No

July 01, 2008 02:10:30

angel987

Member Since: June 2008 Contribution: 16

RE: Master detailed relationship

master detail relationship cant be applied. You can drill through from a report in report studio to query studio.

Is this answer useful? Yes | No

1 0

Overall Rating: +1

February 24, 2009 12:00:17

simik

Member Since: February 2009 Contribution: 3

RE: Master detailed relationship

Master detail relationships link information between two data containers (such as list crosstab or chart) within a report: a master data container and a detail data container.
Using a master detail relationship you can use a single report to display information that would normally take two reports.
Master detail relationship can be created for any data container within Report Studio.

1. Create or open a report to use that has one data
container (i.e. a crosstab report)
2. From the Toolbox tab drag a container object next to the container in the work area (i.e. a chart- drag items from the insertable objects pane)
3. Select the second container and drag it into the first container where you want to place it.
4. Click the embedded object to select it.
5. From the Data Menu click Master Detail Relationships to create the master detail links.
6. Click New Link and select the data items from each query that you want to link to the master detail relationship.

Hope this helped.

Is this answer useful? Yes | No

1 0

Overall Rating: +1

March 17, 2009 08:22:37

vishal_9009

Member Since: March 2009 Contribution: 1

RE: Master detailed relationship

Master detailed relationship from query / Analysis studio report and Report Studio report can be created only with the use of Package level drill through.

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank