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
Author
Message
Posted Friday, May 10, 2013 9:13 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, June 12, 2014 6:49 AM
Points: 10, Visits: 111
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