2 Replies Latest reply on Mar 26, 2017 2:59 AM by Dmitry Chirkov

    Tableau runs counts when connecting to Tabular Cube Can I stop this?

    Paul Hannelly

      Hi all,

       

      This is my first question so please be gentle..

       

      I have a bunch of reports that all link to a tabular cube. When Tableau makes the initial connection to the report it is always takes 10 seconds to connect.

       

      After this initial connection everything is then very performant as expected. I added "?:record_performance=yes" to the end of my report;

      This shows what is happening, it turns out that for the initial connection to the tabular cube Tableau is doing a distinct count of every single dimension member;

       

      eg (this is only 3 of the 50+ dimension columns I have in my tabular cube)

       

      WITH

      MEMBER [Measures].[TEMP(count)(290714814)(0)] AS

      'Count([Date].[DayName].[DayName])',

       

      SOLVE_ORDER = 65535

       

      MEMBER [Measures].[TEMP(count)(290714814)(1)] AS

      'Count([Date].[MonthId].[MonthId])',

       

      SOLVE_ORDER = 65535

       

      MEMBER [Measures].[TEMP(count)(290714814)(2)] AS

      'Count([Date].[MonthEndDate].[MonthEndDate])',

       

      SOLVE_ORDER = 65535

       

      SELECT

      DIMENSION PROPERTIES [MEMBER_UNIQUE_NAME],[MEMBER_CAPTION] ON COLUMNS

      FROM [Model]

       

       

      Now my tabular cube has some large tables 300mil+ so these counts are whats taking up the 10 seconds, in fact if I run the code in SSAS it takes exactly 10 seconds, so I have found my issue.

       

      My question is, can I stop Tableau doing this??

       

      This happens on Tableau desktop and Tableau server, and I am using Tableau 9.2.

       

      I hope someone can help, I have been researching and googling this for days.

       

      Cheers

      Paul