How to show Preview Image of Spotfire Analysis File inside Spotfire Analyst.

How to show Preview Image of Spotfire Analysis File inside Spotfire Analyst.

When opening an analysis file from the Spotfire Library, the preview/thumb image of the corresponding analysis file is displayed on the right hand side panel of the library after selecting the corresponding analysis file. The corresponding Spotfire Analysis Thumb Image of analysis file(s) is stored inside the table - "LIB_PROPERTIES" of the Spotfire database.

Note: If you are not able to see the preview image of the analysis file when opening it from the Spotfire library, check the "Select Preview Image" option for the corresponding analysis file.To get the select preview image option, open Spotfire Analyst >> Edit Menu >> Document Properties >> Library tab.

  Follow the below steps:

1). Create an Information Link from the TIBCO Spotfire database table - LIB_PROPERTIES.

2). Click on the SQL button and modify it as follows.

SELECT

    L1."ITEM_ID" AS "ITEMID",
    L1."PROPERTY_NAME" AS "PROPERTYNAME",
    L1."PROPERTY_VALUE" AS "PROPERTYVALUE",
    CONVERT(varChar(MAX),L1."PROPERTY_BLOB_VALUE") AS "PROPERTYBLOBVALUE"
FROM
    "spotfire_database"."dbo"."LIB_PROPERTIES" L1
WHERE
    (L1."PROPERTY_NAME" = 'Spotfire.Preview.Thumb')
    AND <conditions>
    
3). Save the modified SQL.

4). Select the column - "PROPERTY_BLOB_VALUE" and then click on the Edit button. Change its datatype from blob to string.

5). Execute the information link.

6). Inside Spotfire Analyst, create a calculated column with the expression - Base64Decode([PROPERTY_BLOB_VALUE])

7). Spotfire Analysis Thumb Image will be displayed inside the above created column.

Attached is a sample analysis file  (Filename: LIB_PROPERTIES.dxp) for the reference.

Disclaimer: The above query is a sample query which is created for reference while having Microsoft SQL Server as a Spotfire database. https://docs.tibco.com/pub/sfire-analyst/10.3.0/doc/html/en-US/TIB_sfire-analyst_UsersGuide/other/other_details_on_document_properties_library.htm