Skip to main content

Posts

Showing posts from July, 2014

DataFunction Execution in script

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,

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

Custom Error Page

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

Filebased datasource security

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.txt   </string>   </ArrayOfString>  </value> AllowedWebRootFiles  Provi

Webplayer PDF export

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.

Visualization Area Sizes

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

Spotfire Cloud Update

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