We're trying to mirror the functionality we have with Oracle Express cubes. We have reports which include several filters across the top of the report. Users can then use drop-downs for each filter to "slice and dice" the cube so users can zero-in on specific sub-groups. Example--we have a dimension for geography/specific offices, types of claims, month and year, etc. From filters across the top of the report, users can use drop downs to choose offices (example: New Orleans and St. Louis), age (in ranges) of veteran, report period, state of residence, etc.