BI - Cube Concept and MDX Query Help
you can do this with help of MDX Custom filer on filter option when we generated report for cube.

there you write query regaring dimension table and fact table with help of select measures.[attribute] on rows from cube name where conditon apply  . and so on...