MDX Query to get "Probable product(s) by hour"

• Rachitha

  SSC-Addicted

  Points: 441

  More actions

  March 23, 2009 at 8:17 am

  #132434

  Hi guys,

  I have a requirement to get "Most Probable product(s) by Hour". Following are the Dimensions and Facts i have.

  1. DimItem Dimension -> all items

  2. DimTime Dimension -> Time dimension with hierarchy "Year - Quarter - Period - Week - Day - hour"

  3. FactSales -> Have measures Date/Item Level "Quantity"

  For the selected date -> i want to get hour level Item(s) having max quantity

  Sample Data:

  Hour1-> ItemA -> #5

  Hour1-> ItemB -> #6

  Hour1-> ItemC-> #7

  Hour5-> ItemA -> #5

  Hour5-> ItemB -> #5

  Hour5-> ItemC-> #4

  ....

  ....

  ....

  i want to write an MDX query to get the output as follows

  Hour1 -> ItemC

  Hour5 -> ItemA, ItemB

  or atleast

  Hour1 -> ItemC

  Hour5 -> ItemA

  Hour5 -> ItemB

  Please provide your valuable suggestions.

  Thanks,

  Rachitha

• Rachitha

  SSC-Addicted

  Points: 441

  More actions

  March 25, 2009 at 8:56 am

  #966025

  I got solution for this..

  Thanks,

  Rachitha..