Click here to monitor SSC
SQLServerCentral is supported by Redgate
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: Monday, June 6, 2016 11:38 AM
Points: 10, Visits: 124
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