MSOLAP.8 and a Cached Perspective for Excel 2016?

  • SeeCoolGuy

    SSCrazy

    Points: 2871

    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: 2871

    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

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply