1 2 3 4 5 6 7 8 9 10 11 12 13 14
|
WITH
SET [TOP] AS '({Filter([ProductChain].[chain].[Product].members,[Measures].[OrderNb]<>0)})'
MEMBER [DeliveryTime].[Month].[AggPeriod] as 'SUM([DeliveryTime].[Month].[Month].&[2007]&[1]&[1]:[DeliveryTime].[Month].[Month].&[2007]&[1]&[3])', format='0,#'
MEMBER [Measures].[ChainCode] as '[ProductChain].[chain].Properties("Product Code")', format = '&'
MEMBER [Measures].[ProductFamily] as '[ProductChain].[chain].Properties("Category Name")', format = '&'
MEMBER [Measures].[GrossSales] as '[Measures].[CA]', format = '#0.00'
SELECT
{[Measures].[ChainCode],[Measures].[ProductFamily],[Measures].[GrossSales],[Measures].[OrderNb]} on columns,
{[TOP]} on rows
FROM
[OrderItemRef]
WHERE
([DeliveryTime].[Month].[AggPeriod],[Gamme].[Gamme].[Selection].&[regal]&[2360704C-0898-445B-B520-142424769F47],[Chain].[Principal].&[2360704C-0898-445B-B520-142424769F47]) |
Partager