You may want to explore the very similar question been answered before:
The main approach when drilling across (big) datasources
is using Filter Actions (same as in the referred thread above).
Having a cube as a datasource brings some specific flavour,
mostly by restricting of what one could do with dimensions.
Hope it could help a bit.