Spotfire Ideas Portal
Is there a way to limit how much data is embedded at a system/server level? We are looking for an overall way to stop users from abusing embedded data, and breaking the usage pattern of using proper databases (whereas they can currently attempt to replicate all of their data into Spotfire DB)
I agree this will be a useful feature and gets my vote. Having said that you can easily police this rule by using a database query:
SELECT items.ITEM_ID,
items.ITEM_PATH,
ROUND(LENGTH(data.DATA)/1024/1024, 0) AS MB_SIZE,
items.CHILD_CREATED_DATE_TIME AS ITEM_CREATED_DATE_TIME,
items.CHILD_CREATED_BY_NAME AS ITEM_CREATED_BY_NAME,
items.CHILD_MODIFIED_DATE_TIME AS ITEM_MODIFIED_DATE_TIME,
items.CHILD_MODIFIED_BY_NAME AS ITEM_MODIFIED_BY_NAME,
items.PARENT_CREATED_DATE_TIME AS FOLDER_CREATED_DATE_TIME,
items.PARENT_CREATED_BY_NAME AS FOLDER_CREATED_BY_NAME,
items.PARENT_MODIFIED_DATE_TIME AS FOLDER_MODIFIED_DATE_TIME,
items.PARENT_MODIFIED_BY_NAME AS FOLDER_MODIFIED_BY_NAME
FROM SPF_LIBRARY_ITEMS_FLAT_V items,
LIB_DATA data
WHERE items.ITEM_ID = data.ITEM_ID
-- Item using more than 50 MB
AND ROUND(LENGTH(data.DATA)/1024/1024, 0) > 50
ORDER BY 3 DESC
You can get the SPF_LIBRARY_ITEMS_FLAT_V view definition here:
https://community.tibco.com/wiki/tibco-spotfire-metadata-queries#toc-4
Thanks