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
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 sources Frequent data updates Pre-built dashboards In-depth analysis Ad hoc analysis 100% web based - zero installation Industry 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 c ompatibility 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. Add caption

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) Uniqu

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 relationships Linear regression (numerical vs numerical),  Spearman R (numerical vs numerical), Anova (numerical vs categorical),  Kruskal-Wallis (numerical vs categorical)  Chi-square (categorical vs categorical). Hierarchical Clustering UPGMA WPGMA Single Linkage Complete Linkage Ward's Method Hierarchical Clustering Distance Measures Correlation Cosine Correlation Tanimoto Coefficient Euclidean Distance City Block Distance Square Euclidean Distance Half Square Euclidean Distance Regression Modelling Linear Regression Regression Tree Method Classification Modelling Logistic Regression Method Classification Tree Method

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