Manually configuring a Spotfire Web Player service

https://docs.tibco.com/pub/spotfire_server/7.6.1/doc/html/tsas_admin_help/GUID-13E15745-41ED-4811-A263-20D84838EC1A.html

How to execute any IronPython script from the JavaScript (mashup API) in TIBCO Spotfire

How to execute any IronPython script from the JavaScript (mashup API) in TIBCO Spotfire


https://community.tibco.com/wiki/how-execute-any-ironpython-script-javascript-mashup-api-tibco-spotfirer

1. Define the selected IronPython script to execute when the property is updated.
2. Create a new document property in the Spotfire Analyst client and define a script trigger.
3. Modify the property by calling the Document.setDocumentProperty method in the JavaScript code where you want the script to trigger

// Define the Spotfire handle var webPlayer = new spotfire.webPlayer.Application(server, customization); webPlayer.onOpened(onOpenedCallback); ... // Callback triggered after analysis is opened function onOpenedCallback(analysisDocument) { // Modify property to trigger Spotfire script xyz analysisDocument.setDocumentProperty("abc", ""); }

Spotfire User group Sync.

The following user filter string seems to be working for us.

&(objectClass=user)(|(memberOf=CN=Spotfire-Admins,OU=Spotfire,OU=SecurityGrp,DC=h...b,DC=com)(memberOf=CN=Spotfire-Users,OU=Spotfire,OU=Security....Grp,DC=h...b,DC=com)(CN=Spot*))

CN=Spot* - will sync all the users who start with Spot

e.g Spotfire_test_user@test.com

Spotfire automation service helpful links

https://community.tibco.com/wiki/tibco-spotfire-web-services-api-tutorials-and-examples

https://docs.tibco.com/pub/doc_remote/sfire_dev/area/doc/api/TIB_sfire_autsvcs/Index.aspx?_ga=2.41956005.1812230274.1513473603-641631342.1497457480

https://community.tibco.com/wiki/create-automation-services-custom-task-tibco-spotfire

https://docs.tibco.com/pub/doc_remote/sfire_dev/area/doc/api/TIB_sfire_autsvcs/Index.aspx?_ga=2.41956005.1812230274.1513473603-641631342.1497457480

https://docs.tibco.com/products/tibco-spotfire-server-7-11-0

https://docs.tibco.com/pub/spotfire_server/7.6.1/doc/html/tsas_admin_help/GUID-EDEC3041-B238-4FEC-930E-EFF885B26E43.html

Hide menu, header, etc from webplayer

http://spotfired.blogspot.com/2015/03/hide-menu-header-etc-from-webplayer.html


By adding the options parameter to the webplayer url, you can hide the header, toolbar, export visualization, about, etc. This can be very helpful when integrating with SharePoint or other web portals.

Example to hide the satus bar and page navigation: 
http://www.spotfire.com/SpotfireWeb/ViewAnalysis.aspx?file=/HSSE/Incidents&options=2-0,4-0

Header	1
Status bar	2
Toolbar	3
Page navigation	4
Filter panel	5
Details on demand	6
Undo\Redo	7
Export visualization image	8
Analysis information	9
Download as DXP file	10
Help	11
About	12
Close	13
Logout	14
Edit button	15

You can also pass other parameters to set filters a specific value

Get and set filter value in Spotfire using python script

import Spotfire.Dxp.Application.Filters as filters
import Spotfire.Dxp.Application.Filters.ListBoxFilter
from Spotfire.Dxp.Application.Filters import FilterTypeIdentifiers
from Spotfire.Dxp.Data import *
from Spotfire.Dxp.Application.Filters import *
finalStr = ""
filt=Document.FilteringSchemes[0][myTable][myTable.Columns["Control Name"]].As[ListBoxFilter]()
strVals=''

for value in filt.SelectedValues:
  strVals=strVals+value+',';

finalStr =strVals.strip(',')

myPanel=Application.Document.ActivePageReference.FilterPanel
myFilter=myPanel.TableGroups[1].GetFilter("Control Name")
myFilter.FilterReference.As[ListBoxFilter]().Reset()
myFilter.FilterReference.As[ListBoxFilter]().IncludeAllValues = False
myFilter.FilterReference.As[ListBoxFilter]().SetSelection(finalStr.split(','))

-myTable = Variable 

Schedule Updates Resetting the Marking - Spotfire

Resolution

 

The problem occurs when the  "Key columns for linked data" is not set. To enable the "Key Columns for Linked Data":

1). Open the Analysis.
2). Select Edit>>Data Table Properties.
3). Select Edit>> Key columns for linked data >>Select the Key Columns
4). Click "Ok" and Save the analysis.

Hive Data source connection with Spotfire

Use JDBC connection to connect Hive database

jdbc:hive2://server.xx.net:8443/57_5383188;ssl=true;transportMode=http;httpPath=gateway/default/hive;?tez.queue.name=adhoc;

Hive commands

https://www.edureka.co/blog/hive-commands-with-examples