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...

from System import DateTime from System.Globalization.CultureInfo import InvariantCulture mydate= DateTime.ParseExact('2014/04/12','yyyy/MM/dd',InvariantCulture) print mydate

If you need to Execute multiple DataFunctions on a button click , it is not possible to map the Action Control(Button) to multiple functions. However you can write a script to run the functions. See sample in blue below. Please note we are using Index for item and not name, so you need to ensure you are running the correct function. To get the correct name you could do Print Document.Data.DataFunctions.Item[0] Replacing the index to verify the name, once you know the index you can then use the following script to trigger the DataFunctions Document.Data.DataFunctions.Item[0].Execute() Document.Data.DataFunctions.Item[1].Execute() Please note that this functions are run triggered immediately one after the other, there is no waiting for 1st to finish to trigger the second. If you need to wait for function 1 to finish and then trigger function 2, then make sure that function 1 returns a unique value that is assigned to a property, and then attach a script to property change, ...

I recently had a colleague asking me to show him the data in a calendar format.. Something like this I basically used a scatterplot for this.  You can check out the original DXP here  http://bit.ly/spotcalendar Some key settings to make it a calendar. Please note Order date is the date of interest here These expressions are out of the box expressions, no need to handcode them, but select them in the axis value  X Axis    <BinByDateTime([Order Date],"DayOfWeek",0)> Y Axis    Week([Order Date]) Trellis into panels   <BinByDateTime([Order Date],"Year.Quarter.Month",2)> Manual layout 4 X 3 Labels  UniqueConcatenate(DayOfMonth([Order Date])) Shape Tiled Markers Marker by   <UniqueConcatenate([Order Date])> Happy plotting your calendar!!!

If your Spotfire Web Player environment is open to external users you can replace the  default error messages that are displayed for the Spotfire Web Player to prevent users  from injecting user controlled error messages through a URL. To modify this behavior you must create a new error message file and then modify the  configuration file.  After you make these changes, any error that occurs in the Spotfire  Web Player will be redirected to this static error page. Note: If you make this change, users will not receive any details or information about  the error. Adding a Custom Error web Page 1 In web.config update the section system.web/customErrors to: <customErrors mode="On" defaultRedirect="~/ExampleError.html" /> 2 Create a custom error web page. For example, <!DOCTYPE html> <html lang="en" xmlns="http://www.w3.org/1999/xhtml"> <head> <meta charset="utf-8" /> <title>Error - TIBC...

Are you seeing this error when using a file based datasource like excel in webplayer.? The data source may be missing or has been changed. This generally happens for one of the following reasons First from a security perspective spotfire ensures that you cannot just open any file, you need to provide a white list of locations that should be accessible to the webplayer. Change the property for your case in the web.config file. This is controlled by two settings in the web.config  AllowedFilePaths  Provide the full path to directories or files on a  local disk, other than the Spotfire Web Player  installation directory, that you want to access  in the Spotfire Web Player. Specify each file or directory in a separate  <string> tag.  For example: <value>   <ArrayOfString>   <string>   C:\MyData\   </string>   <string>   C:\Logs\spotfire.tx...

Normally lot of servers have active scripting disabled, and it is required to use export to PDF option when using the spotfire consumer or spotfire business author. if you see an issue like this below, give the steps a try and it may just resolve “This visualization uses JavaScript.  Enable Active Scripting under Internet Options in the Control Panel to display the visualization.” Please follow the procedure below: ====================================================== Login to WebPlayer Server with 'Administrative Privileges' ( If you do not have the rights, please have your Windows Administrators perform the below steps) 1. Click Start. 2. Type gpedit.msc in the Start search box and press Enter. 3. Select Local Computer Policy > Computer Configuration > Administrative Templates > Windows Components > Internet Explorer > Internet Control Panel > Security Page > Internet Zone. 4. Right-click on Allow active scripting and select Properties. 5....

Discovered this gem this afternoon, Spotifre out of the box does a great job at resizing visualization area based on screen size. helps you maximize the screen real estate, But while you are developing you may want to build a best layout for a certain size (like ipads, or corporate desktop size or those megascreens etc). If you go to Edit >> Document Properties you can select Visual Area Size from a few presets or specify a custom size But just realized you can add your own custom sizes in teh list of drop downs, This can be done in preference manager, If you are administrator you can set options for everyone to use You can store a specific size in the preferences to have it show up like any other presets in the Visualization area size drop-down list of the Document Properties dialog. Select Tools > Administration Manager . Go to the Preferences tab. In the Selected group list, click on the group for which to set the preferences. In the P...

This afternoon I logged into my Spotfire cloud account at  https://spotfire.cloud.tibco.com and saw  some cool new features.. I am just going to paste some screen shots here cause these are so simple to use and need no explanation .. but yet so powerful.. I love Spotfire cloud even more now and can't wait to see the next set of features!!! Here are two updates this afternoon that made my day!! New grouping feature allows you to combine two or more categories displayed in a visualization into one It is now easier than ever to configure visualizations! The most important configuration options are accessible by clicking directly on the axes of a visualizatio n