MSOLAP.8 and a Cached Perspective for Excel 2016?

• SeeCoolGuy

  SSCrazy

  Points: 2902

  More actions

  April 10, 2018 at 12:17 pm

  #344590

  It seems that recently a bug has surfaced for Excel 2016 users, whom are using the main perspective in a tabular database i inherited...when a particular filter is applied, it seems to get cached, I traced the database and reviewed the command, and the query end command is posting a QueryEnd request... and when this command is executed in SSMS, the results are as expected off the Perspective... why should clearing the cache be necessary if the data loading process is executed as Process Full?
  
SELECT 
  NON EMPTY HIERARCHIZE( 
    { 
      DRILLDOWNLEVEL( 
        { 
          [Date].[Fis Year].[All] 
        },,, 
        include_calc_members 
      ) 
    } 
  ) DIMENSION PROPERTIES parent_unique_name, hierarchy_unique_name ON COLUMNS 
FROM [CUBE_MODEL] 
WHERE ( 
        [Measures].[Net Sales] 
      ) CELL PROPERTIES value, format_string, language, back_color, fore_color, 
font_flags 


  <ClearCache xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
<Object>
  <DatabaseID> Adventure Works DW Multidimensional</DatabaseID>
</Object>
</ClearCache>

  -- Francisco

• SeeCoolGuy

  SSCrazy

  Points: 2902

  More actions

  April 12, 2018 at 9:53 am

  #1986616

  I see this issue is patched in CU8 https://support.microsoft.com/en-us/help/4077064/cumulative-update-8-for-sql-server-2016-sp1

  -- Francisco