Cannot Drill Through From a Relational Source to a Cube

By default, you cannot drill through from a relational data source to a cube. This is because a cube expects a Member Unique Name (MUN) as a parameter value and relational sources do not use MUNs.

Members have properties which include a business key and a caption. If either of these match data items within the relational source, drilling through can be performed as long as the cube target report is authored in Report Studio.

If the source data source has a query item, for example display name, that corresponds to a member property in the target cube, for example caption, you must create the parameter on the caption in the target report.

To pass the data item to the cube target, do the following:

In the cube target report, create a parameter that accepts the caption of the member. This parameter should be created in a Query Calculation object from the Toolbox tab with the following syntax. Type the following
```
filter([ Hierarchy or Level],caption([Hierarchy of Level]) = ?Parameter?)
```
For example:
```
filter([sales_and_marketing].[Products].[Products].[Product line],caption([sales_and_marketing].[Products].[Products].[Product line]) = ?Product Line?)
```

For more information about drill-through access, see the Drill-Through Access chapter in the IBM® Cognos Business Intelligence Administration and Security Guide.