title: An MDX expression was expected. An empty expression was specified
body: <p>I am getting this message when i am trying to build my mdx query in my ssrs query builder. Any idea????
  error:
  An MDX expression was expected. An empty expression was specified. (Microsoft SQL Server 2008 R2 Analysis Services)                                                                                     Here is my MDX                                                                                                                                                                               </p>
  
  <pre><code>    with                                                                                        
  member [Measures].[Motor: The Car]                                                                                        
  as                                                                                          
  ( [Web Page].[Web Site Structure].[Motor Insurance].[TheCar], [Measures].[Visit Count])                                                                                     
  member [Measures].[Motor: YourPolicy]                                                                                 
  as                                                                                           
  ( [Web Page].[Web Site Structure].[Motor Insurance].[YourPolicy], [Measures].[Visit Count])                                                                                     
  
  member [Measures].[Motor:Proposer]                                                                            
  as                                                                                            
  ( [Web Page].[Web Site Structure].[Motor Insurance].[Proposer], [Measures].[Visit Count])                                                                                      
  
  member [Measures].[Home:About You]                            
  as        
  ( [Web Page].[Web Site Structure].[House Insurance].[AboutYou], [Measures].[Visit Count])    
  member [Measures].[Motor:About You]            
  as         
  ( [Web Page].[Web Site Structure].[Motor Insurance].[AboutYou], [Measures].[Visit Count])
  member [Measures].[Motor:PricesPage]             
  as           
  ( [Web Page].[Web Site Structure].[Motor Insurance].[ViewPrices], [Measures].[Visit Count])        
  
  member [Measures].[Home:PricesPage]                   
  as           
  ( [Web Page].[Web Site Structure].[House Insurance].[ViewPrices], [Measures].[Visit Count]) 
  member [measures].[Motor:ViewAllPrices]            
  as                   
  ( [Web Page].[Web Site Structure].[Product].&amp;[2].[Motor:AllViewPrices], [Measures].[Visit Count]) 
  
  member [measures].[Home:ViewAllPrices]                  
  as
  ( [Web Page].[Web Site Structure].[House Insurance].[Home:AllViewPrices], [Measures].[Visit Count])              
  member [measures].[Home:YourCover]               
  as            
  ( [Web Page].[Web Site Structure].[House Insurance].[YourCover], [Measures].[Visit Count])
  member [measures].[Home:PolicyHolder]                     
  as                     
  ( [Web Page].[Web Site Structure].[House Insurance].[PolicyHolder], [Measures].[Visit Count])
  member [measures].[Home:Property]                      
  as                        
  ( [Web Page].[Web Site Structure].[House Insurance].[Property], [Measures].[Visit Count])
  
   SELECT NON EMPTY { [Measures].[Motor:PricePanel],             
   [Measures].[Motor:PricePanel-&gt;Compare],               
   [Measures].[Motor:PricePanel-&gt;MorePanel],              
   [Measures].[Home:PricePanel-&gt;MorePanel],                
   [Measures].[MorePanel-&gt;BO+Phone],              
   [Measures].[Motor:AY-&gt;PricesPage],              
   [Measures].[PercentOfVisitsByBrowser],                
    [Measures].[Proposer-&gt;PricesPage],            
    [Measures].[Proposer-&gt;TheCar],              
     [Measures].[TheCar-&gt;YourPolicy],                  
      [Measures].[PolicyHolder-&gt;Property],
       [Measures].[YourCover-&gt;PricesPage],             
       [Measures].[Property-&gt;YourCover],               
        [Measures].[YourPolicy-&gt;PricesPage],               
         [Measures].[BO+Phone],                   
          [Measures].[Compare],                   
          [Measures].[AY-&gt;Proposer],                   
          [Measures].[Motor:PricePanel-&gt;BO+Phone],              
          [Measures].[AY-&gt;PolicyHolder],                 
          [Measures].[Home:PricePanel-&gt;BO+Phone],         
          [Measures].[Home:PricePanel-&gt;Compare],           
          [Measures].[Home:PricePanel],                 
          [Measures].[Home:AY-&gt;PricesPage],                 
          [Measures].[MorePanel],                    
          [Measures].[Motor:About You]                 
  ,[Measures].[Motor:Proposer]                  
  ,[Measures].[Motor: The Car]                 
  ,[Measures].[Motor: YourPolicy]                 
  ,[Measures].[Motor:PricesPage]                 
  ,[measures].[Motor:ViewAllPrices]                
  ,[Measures].[Home:About You]                        
  ,[measures].[Home:PolicyHolder]                  
  ,[measures].[Home:Property]                    
  ,[measures].[Home:YourCover]                           
  ,[Measures].[Home:PricesPage]                      
  ,[measures].[Home:ViewAllPrices]                   
  ,[Measures].[BO+Phone] } ON COLUMNS,                     
          NON EMPTY { ([Timeline].[Financial Date].[Visit Date].ALLMEMBERS * 
          [Product].[Products By Category].[Product Category].ALLMEMBERS ) }       
           DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS         
           FROM ( SELECT ( STRTOSET(@ProductProductsByCategory, CONSTRAINED) ) ON COLUMNS          
           FROM [Visits]) CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS 
  </code></pre>