Need suggestions on MDX or SSAS cube aggregation method

  • 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?

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply