TIBCO Spotfire FAQ

September 2009 - Posts

  • Problem adding S-PLUS plug-in to existing Eclipse installation.

    Unzipping the S-PLUS plugin .zip into a working Eclipse installation with other plugins (with the workspace selection dialog turned off) causes an exception on Eclipse startup. The result is an  Eclipse instance without any valid S-PLUS views.

    Solution: Although the option to add S-PLUS to an existing Eclipse installation is not supported, you can solve this problem by removing the ECLIPSE/configuration/org.eclipse.osgi directory.

  • How to remove unused levels from my factor variable in TIBCO Spotfire S+

     You can use the drop argument with the subset operator ( [] )

       > g5 <- factor(LETTERS[1:5])

       > g5

       [1] A B C D E

       > g4 <- g5[1:4]

       > g4 # note levels are printed since they do not match the values

       [1] A B C D

       Levels:

       [1] "A" "B" "C" "D" "E"

       > g4drop <- g4[drop=TRUE]

       > g4drop # levels are not printed since there is no mismatch

       [1] A B C D

       Here is another example using a sample subset from fuel.frame:

       > smallish.cars <- fuel.frame[fuel.frame$Type %in% c("Compact", "Small",
       "Sporty"),]

       > smallish.cars
       Weight Disp. Mileage Fuel Type
       Eagle Summit 4 2560 97 38 3.030303 Small
       Ford Escort 4 2345 114 38 3.030303 Small
       Ford Festiva 4 1845 81 42 2.702703 Small
       Honda Civic 4 2260 91 37 3.125000 Small
       Mazda Protege 4 2440 113 37 3.125000 Small
       Mercury Tracer 4 2285 97 31 3.846154 Small
       ... <snip>

       # -- Display current levels of factor

       levels(smallish.cars$Type)
       > levels(smallish.cars$Type)
       [1] "Compact" "Large" "Medium" "Small" "Sporty" "Van"

       # Use drop parameter
       # of subset operator to
       # remove unused levels

       > smallish.cars$Type <- smallish.cars$Type[drop=T]

       # -- Display current levels of factor
       > levels(smallish.cars$Type)
       [1] "Compact" "Small" "Sporty"

  • S+ Install: Execute setup.exe NOT setup.msi for installation

     Users should always run setup.exe to install S-PLUS, not setup.msi. This
       is especially important for installations on Windows Vista.

       If the file extensions are hidden so you cannot distinguish between the
       two setup files, follow these instructions:

       1. Select Tools -> Folder Options
       2. Select the View Tab
       3. Uncheck "Hide extensions for Known file types"
       4. Select OK

  • How to define and distribute a new DXP color scheme

       1. In a TIBCO Spotfire plot, right-click and select

          Properties
       2. In the Properties dialog > Colors tab, configure a Color Scheme
       3. Click Save As... (New Scheme or Update Scheme) to save the color scheme locally. The new color scheme will from now on be available on this particular machine (using the Open... button in the current dialog)
       4. To distribute the color Scheme, click Export...
       5. Save a .visconfig file (locally)
       6. Using a TIBCO Spotfire administrator account, go to Tools menu > Administrator Manager
       7. Select the Preferences tab
       8. Select a Group to give access to the color scheme
       9. In the window to the right, select the Configuration Sets tab
      10. Click Import and browse to the saved .visconfig
      11. Enter a suitable Configuration name, then click OK.
      12. The new color scheme will now be available for all users in the choosen group (the next time they start TIBCO Spotfire and connect to the server).

  • How to bin the values on the bar chart x-axis

    If you have a numeric column on the x-axis in your bar chart, it can be binned. To activate the binning, right-click on the x-axis selector > select Auto-bin column. It's now also possible to control the number of bins, using the bin-slider directly above the x-axis selector.

  • Using the Min function when calculating new columns

    The Min function can be used to create a new column containing the smallest value out of several columns for that row.  

       1. For example, load the following dataset into Spotfire : ID col1 col2 col3 a 1 5 56 b 5 54 85 c 12 23 72
       2. Go to Insert > Calculated Column...
       3. In the Expression box enter Min([col1],[col2],[col3])
       4. Select OK - a new column will be created with the values 1, 5 and 12 (the smallest values across the three columns for each row of data).

  • TIBCO Spotfire does not recognize dates in the 'YYYYMMDD' format

    TIBCO Spotfire does not recognize dates in the 'YYYYMMDD' format. Data in this format is interpreted as integers instead of dates.

    There is currently no way to force the data to be imported in a date format.

    A possible workaround is to create a new column (in date format) after the import.

    Example (using the below data as an example):
    ColA;ColB
    20060724;A
    20060831;B

    1. Go to TIBCO Spotfire File menu > Open > File and select the data file
    2. Change the data type during import for ColA to String (from Integer) and import
    3. Then, after the data is opened, go to Insert menu > Calculated Column  and enter the following expression:

    Date(Concatenate(Left([ColA],4),"-",Mid([ColA],5,2),"-",Right([ColA],2)))

    4. Then, click OK - now you have a date column based on the date string that was imported.

  • Does the Web Player Server support Web Garden for IIS 6.0?

    The Web Player Server does not support the Web Garden for IIS 6.0. The Web Player analyses are held “in process” and when you run Web Gardens, the sessions are out of process and you cannot tell which process the analysis will end up in. Different calls to the server may end up in different processes.

  • Can the DateDiff function in TIBCO Spotfire be used to compare months?

    The DateDiff function does not compare the month. It currently only compares in day, hour, minute, second or millisecond.

    To compare months one could instead e.g. use the Month function to extract the months from the dates (and if needed, the Year function to extract the year), and then subtract the results.

  • Can the Web player be configured to access multiple Spotfire Servers?

     Can the Web player be configured to access multiple Spotfire  Servers?
    ----------------------------------------RESOLUTION----------------------------------------
    No, the Web Player is currently only designed to access a single Spotfire Server

  • Is there a migration path to be able to move DecisionSite applications and guides to TIBCO Spotfire?

    All the developer tools, API's, etc. are different for TIBCO Spotfireand DecisionSite so there is no way to use applications created for DecisionSite in TIBCO Spotfire.

  • The function "lastperiods" does not work as documented

     As per the documentation, the function lastperiods(x,[Axis.X]) should return the current node and the x - 1 previous nodes. However, it returns the current node and the x previous nodes.
    ----------------------------------------RESOLUTION----------------------------------------
    This issue has been fixed in Patch A50142, available for download on TIBCO Spotfire Product Patches page at http://support.spotfire.com/patches.asp.

  • Spotfire.ApplicationStarter.exe - Unable To Locate DLL - mscoree.dll

    After installing Spotfire DXP on a client machine the following error occurs when trying to start the client:

    Error:
    Spotfire.ApplicationStarter.exe - Unable To Locate DLL

    The dynamic link library mscoree.dll could not be found in the specified path [PATH]

    ----------------------------------------RESOLUTION----------------------------------------
    The error indicates it is failing on loading a .NET 2.0 component.  The mscoree.dll file exists in c:\Windows\system32 and it's a core dll for .NET 2.0 (Microsoft .NET Runtime Execution Engine).

    Please try uninstalling then reinstalling .NET 2.0 on the client machine having the issue and then run the DXP install again.

    The .NET 2.0 installer can be found here:
    http://www.microsoft.com/downloads/details.aspx?FamilyID=0856eacb-4362-4b0d-8edd-aab15c5e04f5&DisplayLang=en

  • TIBCO Spotfire hangs when loading embedded data on machines with .NET 3.5 SP1 installed "After installing Service Pack 1 for Microsoft .NET Framework 3.5, you are unable to open analysis files with embedded dat

     After installing Service Pack 1 for Microsoft .NET Framework 3.5, you are unable to open analysis files with embedded data in TIBCO Spotfire.

    On 32-bit systems the application hangs during the loading of the analysis file, on 64-bit systems you experience an OutOfMemoryException.

    To verify which version of the .NET Framework you have installed, please follow these steps:

       1. Open the Windows Start menu
       2. Click on Settings -> Control Panel
       3. Open the "Add or Remove Programs" application

    The installed version(s) of the .NET Framework are listed here. The version of .NET that causes this issue is listed as: "Microsoft .NET 3.5 Framework SP1"
    ----------------------------------------RESOLUTION----------------------------------------
    This is a known issue with Service Pack 1 for Microsoft .NET 3.5.

    See the following Microsoft page for a technical description: http://connect.microsoft.com/VisualStudio/feedback/ViewFeedback.aspx?FeedbackID=361615.

    While this is a known issue with the service pack from Microsoft, a TIBCO Spotfire patch - A50484 - has been created to solve the problem. To resolve this issue, please download and apply the latest patches for TIBCO Spotfire 2.1.

    TIBCO Spotfire patches can be downloaded from the following page:
    http://support.spotfire.com/patches_spotfire.asp

  • How do I create a details visualization?

    Below are the steps to create a details visualization:

       1. Create a visualization that you want to use to control the details visualization. Comment: This should be the visualization in which you want to be able to mark items and retrieve details about these items in the details visualization.
       2. Right-click on the master visualization and select Create Details Visualization and the type of visualization to use as details visualization from the pop-up menu.
       3. Select whether to Use existing data table or to Add new data table. Comment: If the details visualization is to work on the same data table you have been using so far in the analysis, use the first option. The second option is for the cases when you want to bring in additional information to the analysis. For example, you may have access to more details about the rows in the first data table in a database and you want to bring these in to the analysis for the marked rows only. Then use the second option.
       4. If the Add new data table option was selected, follow the steps in the Add Data Table wizard.
       5. Set up the new details visualization to the desired view.

Spotfire's interactive information visualization and analytic solutions give users a remarkable experience for quickly and easily querying data and reporting results for superior business intelligence. From portfolio management and customer retention programs to key processes such as CRM, marketing, research, bioinformatics, yield and asset management and design for manufacturing, enterprises around the world rely on Spotfire's business analytics software to improve operational performance.

©Copyright 2000-2011 TIBCO Software Inc | Privacy Policy | Terms of Use I Blog I Contact Us I Content Center