You can set up drill-through access between different 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.
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 |
