Thank you for advise.
Actually, I am concern on both my data warehouse/universe design. I find difficulties when I try to implement a simple, flexible, and user-friendly design.
My first design is to create a fact table with single revenue measure. The user need to use crosstab to show the values. I think it is simple and appropriate design. However, I find that there are always some calculations appeared between each product. User cannot simply drag and drop to get the result. The calculation needed to be done in reporting level (Please check the following link for an example) while user does not have enough skill to do that
Another approach is that I create a fact table with three measures, separating the total revenue into 3 facts. i.e., Good Revenue, Fair Revenue, and Poor Revenue. In that case, they do not need a crosstab. They will be happy and simply drag and drop all they want. Calculation is much simple than the one above.
But I think this approach violates general designs. Let’s say it will be a mess if there are 1000 products.
summoner 
(BOB member since 2008-12-18)