Hansen, Stefan
- Total activity 215
- Last activity
- Member since
- Following 0 users
- Followed by 0 users
- Votes 0
- Subscriptions 42
Articles
Recent activity by Hansen, Stefan-
Spotfire Client: Using property controls dates in calculations
To use calculations with dates from a property control, you must cast the property control as a date and surround it with quotation marks The proper format is:Date("${DatePropertyControl}")
-
Bookmarks with masked columns become invalid.
Date Posted: 2018-09-27Product: TIBCO Spotfire®Problem:Bookmarks with masked columns become invalid.Solution:When using "Marked Rows > Filter to" and bookmarks, for example: Mark some data in the v...
-
Spotfire Client: "ORA-00972: identifier is too long" error when using long alias names for columns imported from Oracle Database
When you try to give a very long alias names to a column in a custom query(Oracle connector) it may fail to verify with the following error message.--------------------External error:ORA-00972: ide...
-
Spotfire Client: The order of embedded data can affect Spotfires file size
You may notice that the size of .dxp files can vary a great deal even though they have essentially the same data (same number of rows and columns, and same values). Whether or not a data set is sor...
-
JDBC drivers issue with timestamp/datetime column for data logged during daylight saving day.
This article briefly describes the JDBC drivers' issue when the data is logged during the daylight saving day. Whenever we import the data into Spotfire via JDBC connections, the timestamp of the d...
-
How to Calculate the Top Contributing Groups to the Top N% of Aggregated Results
In order to calculate the groups who contribute most to a total, and specifically those groups whose aggregated results make up the top % of the total. For example using a Baseball dataset, you can...
-
Spotfire Client: Supported data types when exporting from R to .sbdf file
When running an R script that contains a Date column, you can get the following error:'... input data has different number of columns than the number of input column types' The following table lis...
-
Sybase Stored Procedure fails to load with error 'java.lang.IllegalArgumentException: The column name is not valid'
Sybase stored procedure fails to load in TIBCO Spotfire with below error and works fine in SQL Developer: InformationModelServiceException at Spotfire.Dxp.Services: An Internal Error has occurred. ...
-
Spotfire Client: Property controls types in that can be used in an analysis
When creating a property control in an analysis, there are three options -Document-Data Table-Column The Document property will apply throughout the Document (.dxp file)The Data Table property will...
-
Spotfire Client: Why do I get an error using importJDBC from the sjdbc package?
When using the importJDBC (or exportJDBC) function in the sjdbc package the following error message comes up:"Message: Problem in .JavaMethod("SJDBCBridge", "sjdbcExportStart", : java.lang.NullPoin...