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

Need suggestions on MDX or SSAS cube aggregation method Expand / Collapse
Posted Friday, May 10, 2013 9:13 PM


Group: General Forum Members
Last Login: Tuesday, December 16, 2014 8:43 AM
Points: 10, Visits: 114
Cube consists of one fact table and 4 dimensions, dimDate (DateKey), dimTime (TimeKey), dimLocation(LocationKey), dimProduct (ProductKey). I would like to get the top 5 Product and its individual sales at certain date (for instance, Product A was sold for $140 and ranked as number one), not sum value which is defined in aggregation property. Any suggestions?
Post #1451804
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse