tags:

views:

58

answers:

1

1)

select non empty 

           [Measures].[carded transactions] on 0,
           {[Date Dimension].[DATE].&[39446]:[Date Dimension].[DATE].&[39505]} on 1

from [Food and Beverage]

where 
(
       FILTER(
   {( [Revenue Center].[Revenue Center].[Revenue Center]
    * [Date Dimension].[Fiscal Calendar].[Fiscal Day] 
    * [Date Dimension].[Day Name].[Day Name])}
    , [Measures].[FnB Checks] > 0
             )
 )

2)

select non empty 

    [Measures].[carded transactions] on 0,
    {[Date Dimension].[DATE].[DATE]} on 1

FROM

 (SELECT 
        ([Date Dimension].[Fiscal Calendar].[Fiscal Day].&[2008]&[1]&[1] 
        : [Date Dimension].[Fiscal Calendar].[Fiscal Day].&[2008][2]&[60]) ON  0  
  FROM [Food and Beverage]
 ) 

where 
(  
  FILTER(
           {( [Revenue Center].[Revenue Center].[Revenue Center]
    * [Date Dimension].[Fiscal Calendar].[Fiscal Day] 
    * [Date Dimension].[Day Name].[Day Name])}
 , [Measures].[FnB Checks] > 0
        )
  )

thanx. help appreciated.

A: 

It looks like they are across different date periods that is why...

ajdams