I am working on SSAS Project… and stuck on following issue..
Currently having following scenario..
Having ProductCategory, Product, SalesOrder, Time dimensions…
Sum of product one of fact measure
Total sale another fact measure
Product is having one attribute User exp means how many months the project is having user experience.
Schema.. ProductId, ProductName, ProductCatId(Used for hierarchy), monthofexp like 0,1,2,3,6,….24 etc.
Need to prepare report as following…
Upto 6 month exp = sum(total no of product.)
6 to 12 month exp = sum(total no of product.)
24 to 36 month exp = sum(total no of product.)
And so on…..
It’s really appreciated if you help me to find out the way…