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
Quote from: tstjean on 17 Apr 2014 07:58:10 AM
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.