Skip to Main Content
Spotfire Ideas Portal
Status Future Consideration
Product Spotfire
Categories Data Management
Created by Guest
Created on Nov 11, 2016

Purge cached data when saving analysis

PROBLEM: When saving an analysis as a DXP or into the library, with the analysis Spotfire saves a snapshot of cached data from the data tables at the point in time that the developer initially loaded/refreshed them. Generally this could be desirable, but in cases where we wish to implement a report with row-level filtering, the net affect of this cached data is that when loading the analysis end-users may momentarily see the cached data saved by the developer (which could include sensitive or restricted rows) until Spotfire autonomously reloads the data tables.

We do not wish to create a splash screen tab to avoid this (since this isn't properly fixing the issue, nor a desired design feature), and the other workaround of marking rows and deleting them before saving the analysis is not self-explanatory for less experienced developers.

SOLUTION: Add a prompt upon saving an analysis to selectively purge cached data from data tables.

  • Attach files
  • Guest
    Reply
    |
    Dec 3, 2018

    Ok, I thought the solution was describing a workaround, but it's not, that's describing the actual fix.

  • Guest
    Reply
    |
    Nov 29, 2018

    Two other possible solutions:

    • Add an option on the data table to enable/disable caching the data.
    • Add an option on the document properties to disable caching the data for the entire document.

    These solutions would be preferable since you can set them on the DXP and not need to remember to clear the cache every time you save it.

  • Guest
    Reply
    |
    Nov 21, 2018

    Can you detail the solution in a step by step manner ?