KnowledgeBase Content Details

September 05, 2019

Question:

You may sometimes need to monitor the reports to see what all items (like Information Links, Data Connections) they are using. This article briefly describes how to create such view to import it into a Spotfire. The applicable item types are: query (=information link) folder, SBDF (= TIBCO Spotfire Binary Data Format file), dataconnection, connectiondatasource, datafunction, and colorscheme.

Answer:

Run the following query or similar to it against the Spotfire database.

select  x.DEPENDENT_ID, x.REQUIRED_ID, y.TITLE, z.DISPLAY_NAME from 
LIB_RESOLVED_DEPEND x join LIB_ITEMS y on x.REQUIRED_ID = y.ITEM_ID
join LIB_ITEM_TYPES z on z.TYPE_ID = y.ITEM_TYPE
where DEPENDENT_ID = 'e0e8b108-1fb3-49db-b9a7-8fab34f4afa7'

DEPENDENT_ID is the GUID of the analysis file.

The above query will produce a view as shown in the screenshot below.

User-added image

REQUIRED_ID is the GUID of the item used in the analysis file.
TITLE is the name given to the item in Spotfire Library.
DISPLAY_NAME is the type name which states whether it is Information Link or Data Connection, etc.

Disclaimer: The content of this article is for informational purposes only. The subject material may change in any new versions with no notice and there is no responsibility by TIBCO to maintain or support future access to this internal application content. Modification of any internal application content is not recommended and can lead to an unsupported configuration.  It is not intended to be used "As Is" in a Production environment. Always test in a Development environment.

Back to KnowledgeBase