Skip to main content

Posts

Persoanlized Info Links and Scheduled Updates

imagine a store manager has access to his or her own store.. and can only view that data

Step 1 -- create a information link that is NOT personalized and gets data for all stores.. so if you open this link it will show everything to everyone, lets say it has a column called as "store number".


Step 2 -- Create an personalized info link that brings back list of stores current user has access too
Generally this is will bring very small number of rows a

Step 3 - In the analysis, add the first information link, Don't worry that at this point it is bringing all data.


Step 3 -- Then do Insert column, select  from Information Link and select the link you created in step 2.

Step 4 -- As part of the insert steps, Match the two tables on the store number column and select the correct kind of join

step 5 -- Now Go to Edit >> Data Table Properties >> Select the table from Info Link created in step 1

Step 6) You should see a tab "schedulde updates" updates tab in that …
Recent posts

Great example of Spotfire based solution votolab.com

Register at http://votolab.com/


Visual analysis and dashboards Making Open Data more accessible Accessing Open Data from government sources can be hard. Data is spread across disparate systems in multiple formats, often with no easy way to uncover the important insights that are key to you and your organization. We make it easy to visualize and understand this data. Wide range of Open Data sourcesFrequent data updatesPre-built dashboardsIn-depth analysisAd hoc analysis100% web based - zero installationIndustry leading visualizations

Blank Spotfire Library Web Page

Spotfire web player does not support compatibilty mode, and you may see blank pages when opening the spotfire library in your browser window.
To ensure that the Web Player site is not being displayed in "Compatibility View". This is how you edit the Web Player server: On the Web Player Server: 1.Start Microsoft IIS Manager. 2.Click on the Web Player website. 3.Open up the HTTP response header settings. 4.Add a setting with name="X-UA-Compatible" and value="IE=edge" . Note: If the compatibility mode is disabled from the Web Player Server-side no action from the clients using the Web Player is required,  i.e., end users can continue using Internet Explorer with their standard configuration
Please note this is solution to one of the causes and you may need to add the site to trusted zones or allow scripting depending on your infrastructure settings.

Personalized in-db connectors for version 6.5 onwards

Personalized in-db connectors for version 6.5 and further

Go to File >> Add Data Tables >>

Select Connection to
"SQL Server" (This could be any database type that supports custom queries)
In the next dialog, provide server authentication method, username password as required.
Hit the connect button

If connection is successfull you should be able to select a database
Select a database and in the "Views in Connection" windows select Custom Query >> New Custom Query
In the Query window, add a query name, then at the bottom hit the parameters tab and check the box at the bottom "User parameters for personalized Queries" Then write in the query, you can use parameters like ?current_user, ?current_group or ?current_domain. These values are filled up by spotfire at run time based on User login information and can be used to restrict data based on user access.



In Built Statistical Functions in Spotfire used for calculations

You can include any additonal Statistical methods using Open Source R, Tibco Enterprise Runtime for R, SAS, Matlab
Avg(Arg1, ...)ChiDist(Arg1)ChiInv(Arg1)Count(Arg1)CountBig(Arg1)Covariance(Arg1, Arg2)FDist(Arg1)FInv(Arg1)First(Arg1)GeometricMean()IQR(Arg1)L95(Arg1)Last(Arg1)LAV(Arg1)LIF(Arg1)LOF(Arg1)Max(Arg1, ...)MeanDeviation(Arg1, ...)Median(Arg1)MedianAbsoluteDeviation(Arg1, ...)Min(Arg1, ...)NormDist(Arg1)NormInv(Arg1)NthLargest(Arg1, Arg2)NthSmallest(Arg1, Arg2)Outliers(Arg1)P10(Arg1)P90(Arg1)PctOutliers(Arg1)Percent(Arg1, Arg2)Percentile(Arg1, Arg2)Q1(Arg1)Q3(Arg1)Range(Arg1)StdDev(Arg1)StdErr(Arg1)TDist(Arg1)TInv(Arg1)TrimmedMean(Arg1, Arg2)U95(Arg1)UAV(Arg1)UIF(Arg1)UniqueCount(Arg1)UOF(Arg1)ValueForMax(Arg1, Arg2)ValueForMin(Arg1, Arg2)Var(Arg1)WeightedAverage(Arg1, Arg2)There are also Binning functions

List of Statistical Functions Available in Spotfire

You can include any additonal Statistical methods using Open Source R, Tibco Enterprise Runtime for R, SAS, Matlab

Data relationshipsLinear regression (numerical vs numerical), Spearman R (numerical vs numerical),Anova (numerical vs categorical), Kruskal-Wallis (numerical vs categorical) Chi-square (categorical vs categorical).

Hierarchical ClusteringUPGMAWPGMASingle LinkageComplete LinkageWard's Method

Hierarchical ClusteringDistance MeasuresCorrelationCosine CorrelationTanimoto CoefficientEuclidean DistanceCity Block DistanceSquare Euclidean DistanceHalf Square Euclidean Distance

Regression ModellingLinear RegressionRegression Tree Method

Classification ModellingLogistic Regression MethodClassification Tree Method

ForecastHolt-WintersForecast using Regression Modelling,Classification model methods above




K-means ClusteringLine similarity comparison

Changing Map Label Positions

When using Feature Layers in Spotfire e.g US States, world countries etc, by default spotfire tries to put the label towards the center of the geography.

However if you are using multiple layers sometimes the default position may not work out nice.

To solve this Spotfire lets you change the position of the label. To do so

1) Right click on the feature layer
2) Drag any Label to a desired position
3) Repeat for other labels
4) Right click and uncheck Edit Label Positions
Here is a video demonstrating this quick feature