8 Replies Latest reply on Oct 17, 2018 3:02 PM by Andrew Bickert

    backgrounder.externalquerycachewarmup.view_threshold Explanation?

    javier.salazar-rivas

      Does anyone have a good understanding on how this tsm set option is suppose to work? The information in the docs is a bit lacking.

       

      from the docs:

      backgrounder.externalquerycachewarmup.view_threshold

      Default vaule: 2.0

      The threshold for caching workbook query results after scheduled extract refresh tasks. The threshold is equal to the number of views that a workbook has received in the past seven days divided by the number of refreshes scheduled in the next seven days.

       

      I get that the more views or low refreshes would yield a higher threshold but I do not understand what the threshold does/means. Does this apply to published data extracts? Or to data sources embedded in workbooks.

       

      Let me know if you need clarification.