Drill through from cube hierarchy to Report Studio report

[terry_stjean]

I have a cube with an Item dimension which has 4 levels and the bottom level is the Item number.
I want to create a Drill through report to a Report Studio report based on relational tables.
I would like to give the user the ability to filter the cube on any of the levels in the Item dimension and pass those filters back to the Drill through report.
Suggestions?
Do I have to create an optional prompt for each level in the Item dimension and map those the each corresponding column in the Item table ?

Terry

[MFGF]

Do I have to create an optional prompt for each level in the Item dimension and map those the each corresponding column in the Item table ?

Hi Terry,

Assuming each level in the hierarchy equates to a different query item in your relational package, you will need to take this approach, yes.

Cheers!

MF.