I'm a forum newbie and and XMLA newbie... so apologies if this question has been asked 100's of times and/or I'm not expressing it appropriately;

I'm looking for a worked example of how a Cube can effect a Where Clause so that it sub-selects rows from the Fact table. (Note I know this can be done with an MDX Query against the Cube -- but I want this to be part of the Cube definition so only these rows are included).

E.g. if I have a Dimension Hierarchy Product_Types --> Products --> Product_Facts
and I want to create a Cube only showing Product_Types.Name = 'CARS'.

This is obviously a simple SQL where clause and so one option is to create a Car_Facts_View (View). Is that what you folks would do?