How to get list of Table, Columns, Visualizations and Datasource information, etc  for an analysis file
 

This article describes how to list information about tables, columns, visualizations, data sources etc for a TIBCO Spotfire analysis file, using the Application Profiler tool.

All

TIBCO Spotfire Analyst has an Application Profiler tool generally used for diagnostics while migrating from one version to another. But this tool can also help finding the details of Table name, Visualizations on a page, Column names, Data source information of a table etc.


Below is from the manual
=========================
The Application Profiler is used to gather information about analysis files. Given a set of files, local or from the library, the tool loads each file and outputs a number of data tables in STDF files (e.g., one with one row per analysis file, one with one row per data table, and one with one row per visualization). The Application Profiler is a useful tool before or after applying a hotfix or upgrading to a major release of Spotfire. As the output from the tool can be examined, it allows you to monitor if any visualizations or other parts of an analysis appear or behave differently over time (e.g., how many visualizations do the analyses have, has the total rendering time changed over the last three months, has there been any changes in the time it takes to load data in a specific analysis).
==========================

Follow below mentioned steps(also shown in video below):

1)Logon to the Analyst Client and go to Tools>>Application Profiler. Note: to have access to this tool, you must have the TIBCO Spotfire Diagnostics > Application Profiler license.
2)Select the Add>>Select the file or the folder where the Analysis file is located e.g. Local File, Library etc
3)Select Start button
4)Once the Task is completed select the Show Analysis button





Note: Depending on what you are trying to achieve, for some use cases, Searching the Library may be a better option (or complement the Application Profiler results)

Example:
To find all dxp files in the Library that use (depend on) a specific Information Services Data Source:

1. Find the ID (GUID) for the data source of interest, e.g. listed in the properties on it. Note: to easily list all your data sources, search for  type::datasource (in one of the places where you can search the Library, such as in the Library Administraton tool ) 
Example ID: 35f8aa38-a698-4531-9825-af578a769694




2. Now search for any dxp files that depend on that ID (i.e. that particular data source):
item_type::dxp AND depends_on(id::35f8aa38-a698-4531-9825-af578a769694)

For more information on Library Search expressions, please refer to "Searching the Library" in the Spotfire Analyst Users Guide:
https://docs.tibco.com/pub/sfire-analyst/latest/doc/html/en-US/TIB_sfire-analyst_UsersGuide/index.htm#t=lib%2Flib_searching_the_library.htm&rhsearch=search&rhhlterm=search&rhsyns=%20

• Application Profiler, Spotfire Analyst Users Guide
  • https://docs.tibco.com/pub/sfire-analyst/latest/doc/html/en-US/TIB_sfire-analyst_UsersGuide/index.htm#t=diag%2Fdiag_application_profiler_dialog.htm&rhsearch=Application%20Profiler&rhhlterm=Application%20Profiler&rhsyns=%20
• Searching the Library, Spotfire Analyst Users Guide:
  • https://docs.tibco.com/pub/sfire-analyst/latest/doc/html/en-US/TIB_sfire-analyst_UsersGuide/index.htm#t=lib%2Flib_searching_the_library.htm&rhsearch=search&rhhlterm=search&rhsyns=%20