Drilling Through Between Packages

You can set up drill-through access between packages.

The two packages can be based on different types of data source, but there are some limits. The following table shows the data source mappings that support drill-through access.

Table 1. Data source mappings that support drill-through access

Source data source

Target data source

OLAP

OLAP

Note: OLAP to OLAP drill through is supported only if the data source type is the same, for example, SSAS to SSAS.

OLAP

Dimensionally modeled relational

OLAP

Relational data

Note: For more information, see Business Keys.

Dimensionally modeled relational

Dimensionally modeled relational

Dimensionally modeled relational

Relational

Relational

Relational