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 |