The Spotfire Community is moving to TIBCOmmunity and this forum location has closed. During the transition, you can still search the old forums but posting has been disabled. We encourage you to pick up the discussion at the new Spotfire community on TIBCOmmunity.
Browse by Tags - TIBCO Spotfire Community

Browse by Tags

Community Home » All Tags » SQL(RSS)
  • Plot from results of a SQL Select statement

    Does anyone know how to perform a SQL Select statement on an existing data table (in this case, intersecting it with itself where certain conditions are true) and return another data table which can be plotted? The advantage of this is that it can be combined with a dropdown to allow the user to change...
    Posted to Forum by timpainter on Wed, Aug 29 2012
  • How to use Oracle Functions or Clauses in Spotfire client 3.3

    Hi , Could any one guide me how to use oracle functions or Clauses in Spotfire client v3.3 like Trunc(), IN operator etc Thanks
    Posted to Forum by scmy83 on Fri, Jul 27 2012
  • Creating aliases for tables

    Hi, I am new to Spotfire and wanted to know if there is a way of creating aliases for tables within the Information Designer in spotfire. To be specific I have 4-5 date keys in my fact table and needed aliases for the Date Dimension. Please let me know if there is a way around this or is creating...
    Posted to Forum by vinayak08 on Tue, Jul 10 2012
  • Making an SQL union between 2 tables in Information Link

    Hi, I have two tables with the same fields. I would like to automatically extract on-demand data from both of them, using the same filtering. I created an information link like this (using SQL freetext): select * from TABLE1 Where <conditions> UNION select * from TABLE2 Where <conditions>...
    Posted to Forum by JK10 on Sun, Jul 1 2012

    Hi, Where must a pl/sql function be saved? I try to pass a date parameter but it doesn't work, it gives me "unable to parse parameter value" as error! Could you give me a solution PLZ?
    Posted to Forum by sema on Tue, Apr 24 2012
  • NEW JOB OPPORTUNITY Spotfire Developer Boston, MA

    A next-generation health care informatics company is hiring a Tibco Spotfire developer full time. We connect patient information across varied medical settings and time periods to generate a truly longitudinal and comprehensive view of patient care. Our innovative offerings provide our customers and...
    Posted to Forum by Tom Hayes on Wed, Mar 14 2012
  • Help on Altering Column Values Within an Information Link?

    I am trying to create an information link wherein the values of one of the columns must be altered from 0 and 1 to No and Yes. (Desired result: 0 = "No", 1 = "Yes") Using this SQL statement does not work in the Information Designer: SELECT CASE when Col1 = 0 then 'No' else...
    Posted to Forum by FJL on Tue, Oct 4 2011
  • Multiple Input Parameters in Spotfire IL for SQL Stored Proc

    I have a SQL Stored Procedure below which takes as an input a list of compounds. In SQL I can run the following command and get info for a list of cmpds using this query: EXEC getCmpdInfo 'cmpd1,cmpd2' I intended to use it in Spotfire by having the procedure prompt me to enter values. When the...
    Posted to Forum by lbeard on Fri, Aug 19 2011
  • Information Links including Prompts or Parameters

    Hi, all. When creating Information link, I modified SQL to use" in-line view" and "UNION" function. And I tried to add "Prompts" or "Parameters" function to the Information Link to filter some data. But it didn't work and I got an error message, "Failed...
    Posted to Forum by arkwon on Tue, Aug 2 2011
  • About spotfire tool

    Hi, I am new to spotfire tool,i would like to learn this tool. would be great if anybody send some documents related to this tool. Is it reporting tool or ETL tool. pls do the needful. regards balu
    Posted to Forum by sbalu300 on Thu, Jun 9 2011
Page 1 of 2 (13 items) 1 2 Next >

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