September 9, 2013 at 11:18 pm
Hi All,
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…
September 10, 2013 at 9:19 pm
Would someone help me out over here.. Thanks!
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply