1 Reply Latest reply on Mar 2, 2017 3:55 PM by Patrick A Van Der Hyde

    Context Filters and Teradata

    Rashmi G

      Hi Everyone - I am trying to connect to Teradata data source and when I check the performance recording I see it takes more time to populate the filters in the dashboard compared to the view itself.

       

      Can anyone advise me on:

      1) How we could improve performance for filter populating

      2) If Context filters can help on this scenario

       

      Thank you!

        • 1. Re: Context Filters and Teradata
          Patrick A Van Der Hyde

          If there are multiple filters on the view and these filters act to reduce the size of the returned number of rows significantly then applying a context filter to one of these high level filters can result in substantial speed improvement.  It depends on the view though.  Here is a good reference for exploring context filters - Improve View Performance with Context Filters  

           

          I hope this helps.

           

           

          Patrick

           

           

          If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.