Skip to Main Content
Spotfire Ideas Portal
ADD A NEW IDEA

Data Access

OR condition when implementing Information link prompts

Expected: Need to have OR condition when implementing Information link prompts e.g. from customer SELECTDISTINCT R1."LEAD_AREA_ID" AS "LEADAREAID",H2."MATERIAL_INCODE" AS "MATERIALINCODE"FROM"AGDIME"."RES_MATERIAL" R1,"AGDIME"."HERB" H2WHERE((R1."...
over 10 years ago in Spotfire / Data Access / Information Services 0 Future Consideration

Refresh only one data source

The refrsh button refreshes all data tables. I'd like to have a button that gives me a dropdown list so I can only refresh 1 data source. I have eg a spotfire dashboard with data from 15 data sources. Sometimes I only want 1 data source refreshed,...
almost 9 years ago in Spotfire / Data Access 1 Already exists

Current User Login, Domain and Display Names available in expression

This is useful in the following use cases: You use row-level security at data-source level. This is a top requirement from business in case of of internal reporting! You want to load personalized information (business units, managers and subordin...
about 9 years ago in Spotfire / Data Access 2 Future Consideration

Faster Selection Options For "Data Selection in Connection"

When trying to import data tables into a Spotfire project from a cube connection, it's important to limit the amount of data coming in. Under "Add Data Tables" -> Add -> "Microsoft SQL Server Analysis Services" -> "Data Selection In Conne...
about 9 years ago in Spotfire / Data Access 0 Future Consideration

Control whether rows can be added when adding columns

Add a feature to the Add Columns transformation to control whether new rows can be added and what to do when multiple rows would be added (e.g. provide an aggregation function to use). We sometimes experience issues where our users have built DXPs...
over 7 years ago in Spotfire / Data Access 3 Future Consideration

Syntax "with" using custom queries with SQLServer

To simplify the code using SQL Queries, it would be easy to use this syntax : "with my_table (C1) as (select column1 from table_dept) select C1 from my_table" Database : SQLServer
over 9 years ago in Spotfire / Data Access 0 Future Consideration

Add support for Person or Group columns with Allow multiple selections enabled in Sharepoint online connector.

Person or Group columns with Allow multiple selections enabled are not supported at the moment. Therefore, not all data from a Sharepoint list is available in Spotfire.
almost 4 years ago in Spotfire / Data Access 0 Future Consideration

Information designer - Possibility to re-order columns in Calculated column, Filter, Join

Hello Order of colomn is important in Calculated colomn, Filter, Join, as we wrote %1, %2, %3 ... in the formula.Sometime we need to change a colomn, a get the new one in the same order... Now we can't. Could it be possible to add 2 buttons (Up / ...
over 9 years ago in Spotfire / Data Access / Information Services 0 Future Consideration

Spotfire connector for CockroachDB

There should be a Spotfire connector for CockroachDB.
almost 4 years ago in Spotfire / Data Access 0 Future Consideration

Store calculated columns in data connections

If you have a lot of calculated columns in your analysis file, it's frustrating that the only way to share these is by duplicating the analysis file. If they could be stored in data connections these could be reused across multiple dashboards. The...
over 7 years ago in Spotfire / Data Access / Data Management 0 Future Consideration