Master detail relationship in report studio professional authoring

master detail relationship in report studio professional authoring

This IBM Cognos training helps you build on topics learned in the this IBM Cognos Advanced Report Studio course is designed for professional report use of the more advanced authoring features available within Report Studio and Discuss and provide an overview of Cognos Using Master Detail relationships. This document applies to IBM® Cognos® 8 Version and may also apply to subsequent The data containers cannot be part of a master detail relationship . Professional Report Authors of Multi-Dimensional Data using Report Studio Understand Master-Detail Relationships; Dividing a report into.

Also, you cannot perform calculations across master detail queries.

master detail relationship in report studio professional authoring

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. 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.

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.

Create a Master Detail Relationship

Click the Toolbox icon and 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. Click the Queries iconand double-click the detail query. Click the Toolbox icon and drag the Filter object to the Detail Filters box.

In the Expression Definition box, create the parameter. Click Pages iconand click the report page. Select the data container containing the details. In the report object toolbar, click the More icon and 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.

Click the Show properties iconand In the Properties pane, click the Select ancestor icon and click Page. Set the Query property. Click the Toolbox icon, 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 report studio professional authoring

Click the Queries iconand click the detail query. Click the Toolbox icon and drag the Filter object to the Detail Filters box. In the Expression Definition box, create the parameter. Click the Pages iconand click the report page.

master detail relationship in report studio professional authoring

Click the Show properties icon, and In the Properties pane, click the Select ancestor icon and click Page. Click the data container containing the details. In the Properties pane, click the Master detail relationships property. 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. If your detail query object is a chart, you can disconnect a chart title from the master query. Click the chart title, and from the Properties pane, click Master detail relationships.

Create a Master Detail Relationship

Clear the Use the master detail relationships from the chart check box. If the master detail relationship includes a chart as the detail and you are using automatic axis ranges, you can set the same axis range for all the detail charts: In the Properties pane, under General, double-click the Axis range property. Under Maximum and Minimum, click Automatic. The master detail report option is only available with automatic axis ranges.