sql_language thread: Need help with MDX for query against cube
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]
)
|





