I have a field in my fact table called Products, which have product
descriptions from A-Z. Is it possible to have a dimension called "My
Products" that contain only the Products that I specify?

Basically, I want a dimension that is comprised of the products I select,
using a WHERE statement. Such as WHERE Product IN (..,..,..)

Thanks, Andre