Enable GeoCoding Tables for Map Chart

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 file is in place, a Spotfire Administrator or Library Administrator can
import these files to the Library.

To import the geocoding tables into the Library

Start Spotfire and log in as a Spotfire Admin.
Select Tools > Library Administration.
Navigate to the Library folder where you want to import the demo files. For instance, you can create a folder called GeoAnalytics.
Select Import.
Click Browse and select the file geoanalytics.part0.zip.
Click OK.
Click OK.

Click Close when the dialog states
Import Done.

Comments

Using Accordions in Spotfire Text Areas

Spotfire 6.0 provides great tools for quickly building your dashboard, but here we will learn to spice up things with the help of new 6.0 text area. If you are not aware the new 6.0 Text area supports HTML, Javascript and CSS. This opens up possibilities for doing a lot more with the text area. Some of the basic stuff can be seen here http://spotfire.tibco.com/qrt/UBSAN/presentation.html?pcode=100044 One of the cool things you can do is build an accordion panel in the text area for better utilization of the valuable screen real estate and helping the overall experience.(Watch the 0:15 second video below to see how accordion works - Sorry for the jitter in the video. The screen recorder does not record fast enough) Here is the html behind the text area : Please note that Spotfire controls are automatically created when you add text area controls, like filters, drop down lists etc. <DIV id="myaccordion"> <H3>Analysis Details</

Calendar Chart in Spotfire

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

Spotfire Auto Save for recovery

This is an extension I build to auto save local copies of currently open DXP every 15 minutes.. I have tested briefly and it seems to be doing its job, please please please try and test it if you can access a server and deploy.. Key Notes - This add-on will Auto Save Files while only in Spotfire Analyst Client. The save time is hard coded for every 15 minutes. Files are saved only if they are changed or user has done some actions like marking, filtering etc. The Files are saved in temporary location of the system, generally which will be like C:\Users\<username>\AppData\Local\Temp\Spotfire AutoSave If a Library file is opened it will be saved on your local machine under the temp path C:\Users\<username>\AppData\Local\Temp\Spotfire AutoSave\Library Content\ Library path will be replicated in this autosave location. e.g. C:\Users\<username> \Local\Temp\Spotfire AutoSave\LibraryContent\mylibraryfolder\mylibraryfilename_mmddyyyy_HH

Analytics tools tips and tricks

Search This Blog