Skip to main content

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 view

" In reload the following data for each user"


you should now see two tables and two checkboxes next to it
Select the checkbox for the table coming from info link 2 (personalized)

and then schedule your analysis


how it works..

when scheduled update runs for first time, first Info link brings data for all stores. and look for the and second link brings list of stores that the system user has access too.

However Spotfire has now cached the data for all stores from the main informaion link 

When a new user opens a scheduled analysis, then the lookup query is run for every user(because you checked that box earlier to force it to run for every user)

Once the loop up table is retreived then the join step is done against the cache in memory and the lookup table

Generally the lookup tables are small and are retreived very fast and join happens in memory..

The big infolink however is not reloaded and hence you save time

This set up gives you personalized data even on scheduled updates

Comments

Popular posts from this blog

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