Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSAS dimention filter Expand / Collapse
Author
Message
Posted Monday, September 9, 2013 11:18 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, September 20, 2013 6:09 AM
Points: 240, Visits: 230
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…
Post #1492986
Posted Tuesday, September 10, 2013 9:19 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, September 20, 2013 6:09 AM
Points: 240, Visits: 230
Would someone help me out over here.. Thanks!
Post #1493431
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse