I ended up creating a new dataset and basically using what you describe above. When the dimension attributes are placed in the WHERE clause, it works.

Thanks for your feedback.