Skip to Main Content
Spotfire Ideas Portal
ADD A NEW IDEA

Data Access

Showing 494

Queries that are not dependant on each other should be executed in parallel so that users do not wait longer than necessary to consume their reports

*Goal:*As a report developer I desire the ability to ensure queries that are not dependant on each other are executed in parallel to ensure that users do not wait longer than necessary to consume their reports *Customer comments:** Detailed inform...
almost 10 years ago in Spotfire / Data Access 0 Future Consideration

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."...
almost 10 years ago in Spotfire / Data Access / Information Services 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 6 years ago in Spotfire / Data Access 3 Future Consideration

Remove dragging of folders in Information Designer

Remove the ability to drag folders to move them in the Information Designer. The function is rarely used deliberately and it's too easy to accidentally move a folder and then struggle to find it again.
over 8 years ago in Spotfire / Information Services 1 Future Consideration

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...
over 8 years ago in Spotfire / Data Access 2 Future Consideration

reduce sql statement length for data connection

Customer is facing error as below that indicates the length of SQL exceeds the limite by the database when loading data from Google BigQuery via connector/data connection. The query is too large. The maximum standard SQL query length is 1024.00K c...
over 1 year ago in Spotfire / Data Access 0 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...
over 8 years ago in Spotfire / Data Access 0 Future Consideration

Open File & Replace Data Tables on Data->Other->SQLDirect

In order not to lose work, it would be good if a database connected by SQLDirect (in Menu Data->Sources->Others->) has been deleted (for example, because a server has been migrated), the dxp allows to replace said tablepointing to a new d...
over 3 years ago in Spotfire / Data Access 0 Future Consideration

Spotfire BigQuery connector to support BIGNUMERIC

We are seeing pulling data into Spotfire from GCP BigQuery as BIGNUMERIC type columns are not fetched. Updating BigQuery or adding another view does not help due to problematic data values. Can a hotfix on spotfire 12 version be provided.
over 1 year ago in Spotfire / Data Access 0 Future Consideration

Column selection/prompting for a Data Connection or Information Link

Description Background Data Connections and Information Links have a _prompting_ option such that users may filter the incoming data, *before* it's loaded into a .dxp. The users' selections are translated into _WHERE_ clauses in the underlying SQL...
over 1 year ago in Spotfire / Data Access 0 Future Consideration