Master detail relationship in cognos crosstab

Master-Detail Relationships in Cognos | PerformanceG2

master detail relationship in cognos crosstab

To make this page to be generic based on product line is difficult, as you cannot make master detail relationship at summary level. Technical tips pertaining to master-detail relationships in Cognos. A few practical examples might be sectioning a crosstab: 1. Sectioning. 2. Hi Is it possible to establish Master Detail relationship between crosstab and list query in Report Studio. I have two dimensions in crosstab, one.

This is not limited to filters, columns can be applied as well. By using the token prompt inside a field, and populating that with a field reference, it is possible to dynamically modify a list. As a practical example, consider a scenario presented by one of my past clients. A series of reports needed to be bursted to a number of managers.

master detail relationship in cognos crosstab

Each manager had a unique set of filters to be applied. Some of them needed to see data at a high level of granularity, and others needed to see detailed data. The standard method, by joining the burst table to the necessary fact tables, would not work here due to the vast range of requirements.

master detail relationship in cognos crosstab

One way to solve this would be to have each manager create a report view for each report he needed. He would then be responsible for ensuring the filters he used were correct. Unfortunately, that simply was not feasible — not all of the managers were comfortable using Cognos. There were also too many reports and managers for the different managers to keep track of which managers created report views for which reports. Instead, a table was created containing the manager name, email report name, and the necessary filters and columns.

You cannot display parent data in the child frame or child data in the parent frame. Also, you cannot perform calculations across master detail queries. You can use a master detail relationship to show data from separate data sources in a single report.

However, the data sources must be contained in the same package.

Create a Master Detail Relationship

With the dynamic query mode, master detail reports with a crosstab report object are optimized to use a single query whenever possible, rather than a separate query for each report object instance.

Before you begin To create a master detail relationship using queries that reference two different dimensional data sources, you must first link the members by aliasing the levels that contain the members. Procedure To use a parent frame for the master query and a nested frame for the detail query: Add a second data container to the object you inserted. You can insert a list, crosstab, chart, repeater table, or repeater into a list.

You can add a list to a repeater table or repeater. Add data items to both data containers. To associate a report page with the master query and use a data container for the detail query: Click anywhere in the report page. Click the Show properties iconand In the Properties pane, click the Select ancestor icon and click Page.

Set the Query property. You can add a list to a repeater table or repeater. Add data items to both data containers. To associate a report page with the master query and use a data container for the detail query: Click anywhere in the report page.

master detail relationship in cognos crosstab

In the Properties pane, click the select ancestor button and click Page. Set the Query property. In the Insertable Objects pane, on the Toolbox tab, drag a data container to the report.

To link a data item in the master query to a parameter in the detail query instead of to another data item, create the parameter in the detail query. Use parameters to filter values at a lower level in the detail query.

master detail relationship in cognos crosstab

Pause the pointer over the query explorer button and click the detail query. In the Expression Definition box, create the parameter.

Cognos Know How: How to create a chart inside a crosstab with summary

Pause the pointer over the page explorer button and click the report page. Click the data container containing the details.

Cross tab

From the Data menu, click Master Detail Relationships. In the Master box, click the data item that will provide the primary information. To link the master query to a data item, in the Detail box, click the data item that will provide the detailed information. To link the master query to a parameter, in the Parameters box, click the parameter that will provide the detailed information.

To delete a link, select the link and press the Delete key.

master detail relationship in cognos crosstab