THE SQL Server Blog Spot on the Web
Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | Join | Help

MDX QUERY

  •  08-26-2008, 9:41

    MDX QUERY

    I need to find out about each item, how many stores have sold it! query below gives the total no. of stores count where all the items have been sold! what is wrong?

     pl. help!

    with

    set temp as {nonemptycrossjoin({[Item].[Item Name].currentmember},{[Location].[Location Name].children},{[Measures].[Sales Qty]},2)}

    member measures.SetCount as temp.count

    select {measures.SetCount} on columns, {[Item].[Item Name].&[0104205090]:[Item].[Item Name].&[0104259903]} on rows

    from sales

     

    Filed under: ,
View Complete Thread
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement