Analytics tools tips and tricks

Spotfire database holds most of the information regarding users, libraries and other configuration items. The bootstrap file is used by the spotfire server app to connect to this database. This file contains encrypted information and is protected by the Bootstrap password which is required to login into configuration console. If you have forgotten this password, there is no way to reset it. However you can cancel out of this dialog and will need to define a new bootstrap file. Once you hit cancel you will be taken to the Configuration console, where you can create new Bootstrap File To define a new bootstrap file ...that you will need information about the Spotfire server database, Database Name(SQL) or SID (ORCL), port number to connect and a username password to use. Creating a new bootstrap should let you then use the configuration console.

This script is a sample script to toggle zoom slider on X axis of a bar chart You can adopt this script to show hide Y axis or other chart types from Spotfire.Dxp.Application.Visuals import BarChart barchart1.As[BarChart]().XAxis.ManualZoom = not (barchart1.As[BarChart]().XAxis.ManualZoom ) Here barchart1 is mapped to the barchart whose zoom slider needs to be toggled

Assign this script to an action control (like button, link or image) from Spotfire.Dxp.Application.Visuals import BarChart barchart1.As[BarChart]().SortedBars = not (barchart1.As[BarChart]().SortedBars ) barchart1 is mapped to the Bar Chart Visualization you would like to toggle sorting for

Unofficial stuff I have run into so far http://easyspotfire.blogspot.com/ http://spotfired.blogspot.com/ http://www.extendanalytics.com/blog http://www.spotfireextensions.com/blog http://www.explainsstuff.net/ http://www.bearonspotfire.com/ Official stuff  http://spotfire.tibco.com/tips/ http://spotfire.tibco.com/demos?Section=Quick+Reference+Topics http://learn.spotfire.tibco.com/ Found something interesting related to spotfire that can help our community, feel free to email me spotfirenotes  at  gmail  dot  com

If you see that you are not able to select "Yes, save credentials..." options in the datasource settings dialog >> Credentials tab i.e is because you are not using "Database Authentication". Please note that spotfire stringly recommends not saving credentials, but rather use the second option "No, but save....." however if you would like to still use it, please change to the Login Tab and then click on the "Edit" Button to switch to "Database Authentication"

This is a list of WMS layer(s) I have used in the past, I am adding it here for reference http://webservices. nationalatlas.gov/ wms ?SERVICE= WMS &REQUEST=GetCapabilities Please ensure you read the usage and license term from respective providers. Please share WMS layers you you found interesting in spotfire use cases by mailing me at spotfirenotes at gmail dot com or entering in the comments

If you are mapping a multiselect list box property to an axis and would like to have names without the aggregation on the axis label use something like in this example expression lets assume my heatmapColumns are mapping to [Gross Profit],[Sales Total],[Discount] When you do map to property it would generate this expression Change your original expression  from $map("Sum($esc(${ heatmapColumn s }))", ",") Generated output would look like Sum([Sales Total]),Sum([Gross Profit]),Sum([Discount]) To see the column names on your screen rather than the aggregation method and column name change the equation to something like below To $map("sum($esc(${ heatmapColumn s })) as [${ heatmapColumns }]", ",") Generated output would look like sum([Sales Total]) as [Sales Total],sum([Gross Profit]) as [Gross Profit],sum([Discount]) as [Discount] Cheers!!

Quoted from Spotfire server installation manual To display data on a map, the data needs to be geocoded. Geocoding in Spotfire is the process of using some type of identifiers in a data table and matching those to similar identifiers in another set of data tables (a geocoding hierarchy) which contains latitude/longitude coordinates or geographic features. These coordinates or features are then used for correctly positioning the data in a map context. Spotfire 6.5 features pre-packaged geocoding hierarchies, so-called geocoding tables. To make the geocoding tables available to users 1) locate the geoanalytics folder in the Spotfire Server installation kit. 2)) Copy the file geoanalytics.part0.zip to the configured By default it will be on your spotfire server machine C:\tibco\tss\6.5.0\tomcat\application-data\library Details available in teh spotfire server installation manual See “Configuring a Specific Directory for Library Import and Export” on page 108. When this fi...

Quoted from Spotfire manuals Visualization Properties in Expressions In some cases, you may want to use the expression or the display name currently set on an axis as a dynamic part of another expression, so that it changes with your selections. For example, this may be interesting in a visualization title or in a tooltip or label. You may also want one axis to be automatically set to use the same expression as the one set on another axis. There are a number of different "axis expressions working like properties" available in the visualizations. These properties exist only in the context of a visualization and they have values that are defined by the currently used settings in the visualization. For example, a scatter plot can expose the display name of its X and Y-axis expressions as properties and these can in turn be used to set the visualization title. The syntax to use is ${Axis. Axis Name. DisplayName} and ${Axis. Axis Name. Expression}, for the di...

This article is about changing memory size used by the Spotfire server java instance. In most cases you will not need to modify it, however if you see issues around java process running out of memory, this may help Quoted from Spotfire server installation manual Modify the Virtual Memory. To set up the start script when not running as a Windows service: ============================== ============================ 1). Open the file <installation dir>/tomcat/bin/setenv.bat/.sh in a text editor, such as Notepad. 2). Locate the line that sets the variable JAVA_OPTS:     set JAVA_OPTS=‐server ‐XX:+DisableExplicitGC ‐XX:MaxPermSize=256M ‐Xms512M ‐Xmx1536M     or     JAVA_OPTS="‐server ‐XX:+DisableExplicitGC ‐XX:MaxPermSize=256M ‐Xms512M ‐Xmx1536M". 3). Alter the -xms and the -Xmx values ‐Xms512M ‐Xmx1536M to the amount of memory you wish to allocate. 4). Save the file. 5). Restart the server. To set up the start script w...

If you have a greyed out Web Player url in the book mark section as seen above, chances are you have not enabled the web player preference. Here are the steps to enable it. In your Spotfire Analyst Client, login as Administrator Go to Tools >> Adminstration Manager Open the preferences Tab. Select the Everyone Group on the left tree. You can select other groups too, but it setting on Everyone makes it default for everyone. You can also set settings per group Hit the Edit Button at the bottom Right of the Window Expand the Application Node in teh left side tree. You Should see the item DxpLibraryWebURL Lets you specify an URL to the analysis in the Web Player. The URL will appear in the last step of the Save as Library Item wizard. If desired, the user can click the URL to open the analysis in TIBCO Spotfire Web Player, or copy the link for later use. Leave blank if you do not want a link to the analysis in the Web Player to show up in ...

This article lists out steps to enable a custom single sign-on solution on Spotfire Web Player till  You will need to build the customauthentication module for your webplayer first. A sample if provided in Spotfire sdk. Once you have it ready, the output of that project is a dll which we will use on the webplayer. In most cases this will be a very small change to the example itself. Once you have build the custom authenticator project. Here are the remaining steps to enable the custom Authenticator on the web. Step 1 Enable impersonation on Spotfire server Login to Spotfire configuration console.  Easiest way to access is  on your Tibco Spotfire server machine go to Start >> All Programs >> Tibco Spotfire Server x.x  >> Configure Spotfire Server Provide password on the window that pops up. Once logged in go to configuration tab and then select the impersonation page On impersonation section screen, select yes for enable impersonat...