Skip to Main Content
Spotfire Ideas Portal
ADD A NEW IDEA

Ideas

Allow OVER functions to access multiple aggregations and allow multiple OVERs per Custom Expression

Currently the OVER function is, frankly pretty poorly implemented for anyone wanting to do data analysis that's not time series data. OVER functions should be able to access aggregations in parenthesis. For example, if I wanted to calculate the av...
over 3 years ago in Spotfire / Custom Expressions 0 Future Consideration

calculate over all periods of detail levels

Lets say we have a hierarchy of Year.Month, we want to calculate sum on all the same months (e.g. March) of each year. ParallelPeriod() can only calculate on the same month of previous year.
over 3 years ago in Spotfire / Custom Expressions 0 Future Consideration

Enforce user to create secure ODBC only

At present users can configure secure and non-secure ODBC connection. We want enforce users to create only secure ODBC connection (same as studio encryption works when http is disabled)
about 7 years ago in Spotfire Data Virtualization / JDBC / ODBC / ADO 1 Already exists

End to End platform monitoring capability using app dynamics & Other monitoring tools

Third party tools like App Dynamics should be able to connect with TDV for platform monitoring purpose. Enhancement should be done to enable integration with third party tools
about 7 years ago in Spotfire Data Virtualization / monitoring 0 To be Reviewed

Along with 2-way-SSL setup for authentication in TDV, need to pass user id from client to make it use for authorization in TDV

TDV oData Services are exposed via API Gateway platform. In order to have secure authentication between API Gateway and TDV, we want to implement 2-way-SSL (i.e. mutual authentication) so that none of other system can directly call the TDV oData s...
about 7 years ago in Spotfire Data Virtualization / web services 0 Planning to implement

Date Math Functions supported for In Database Connections

Most modern databases (sql server, oracle, teradata, cloudera, etc) support some level of date manipulation functions like dateadd(), add_months(), datediff(), getdate(), etc. Currently Spotfire doesn't support any of these functions across the ma...
over 7 years ago in Spotfire / Custom Expressions 0 Future Consideration

add function to convert integer to ascii character and vice versa

Please add function to convert integer to ascii character and vice versa. Currently we use expression like below to do so, it's ugly & slow and can not cover all ascii chars. case when ([val]>=48) and ([val]<=57) then string([val] - 48) ...
almost 4 years ago in Spotfire / Custom Expressions 1 Future Consideration

Add support for common data definitions in the Business Directory

My clients are requesting support for common data definitions in Business Directory. This should be a searchable repository that users can use to more easily understand the meaning of terms and data fields present as columns in the views and table...
over 7 years ago in Spotfire Data Virtualization / data catalog / metadata 1 Future Consideration

Exclude Columns Transformation: Honor Exclusions Even When Data Type Changes

I want the exclude columns transformation to honor my request when I exclude column(s). I do not care if the data type changes. If I want the column excluded, then I do not want it in my data tables -- unless I specifically allow it. At the moment...
almost 4 years ago in Spotfire / Custom Expressions / User Experience 0 Future Consideration

Copy paste formula for the calculated column

When we build/create a formula using calculated column, noticed that we are not able to copy the formula after we save it. I think it's very useful if we can copy the formula and paste it to the new calculated column when we needed. Especially whe...
over 7 years ago in Spotfire Data Virtualization / data sources 0 Will not implement