Wrox Home  
Search P2P Archive for: Go

  Return to Index  

sql_language thread: Need help with MDX for query against cube


Message #1 by "J House" <jesse@s...> on Mon, 12 Nov 2001 18:46:53
I found out how, if any one cares

I needed to use the Aggregate() function

WITH Member [Product].[myAgg] AS
'Aggregate
( {
[Product].[Food].[Baking Goods].[Jams and Jellies].[Jam].[Super],
[Product].[Food].[Baking Goods].[Jams and Jellies].[Jam].[Plato]
} )'

then in the where clause
WHERE 
(
[Measures].[Profit], 
[Product].[myAgg]
)


 



 

  Return to Index