0 Replies Latest reply on Mar 18, 2013 9:56 AM by vishrut malhotra

    Tableau auto casting performance question

    vishrut malhotra

      Tableau seems to be auto casting some of the fields in my DB. Example (from log):

       

      SELECT [Fund].[fund] AS [none:fund:nk],

        SUM((CASE WHEN 10000 = 0 THEN NULL ELSE (CAST(((([SecurityMarketData].[eff_ddur] * [SecurityMarketData].[beta_ir]) * CAST([PMExposures].[rel_exposure_mult] as bigint)) * [PMExposures].[not_mv_weight]) as float) / 10000) END)) AS [sum:Rel Total KRD:qk]

       

       

      I am looking to improve performance and would like to force it to not Cast. Any ideas?

       

      Thanks!!