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