InVision 2.0 Beta 3

With Beta 3, the primary focus has been on adding support for charting using Highcharts. There are still some work left to be done before this feature is 100% complete, but it’s pretty stable and you should be able to create great looking charts.

In addition to charting (and the obvious bug fixes), we’ve also added a few new features which has been requested. The list below is a rundown of the most important new features added in Beta 3.

New Features

  • Charts using Highcharts
  • New JavaScript Solution object
    • JavaScript Solution objects enables you to write custom JavaScript libraries which are automatically included in your Workbooks. Right now, the primary use case for this feature is to write custom formatters for chart components.
  • Formula support for Setting spreadsheets
  • Dynamic filtering of filters using custom parameters in Slice expressions
    • This feature enables you to filter the contents of a filter when it’s loaded, based on some state in the Workbook. To make this work, you need to add a custom parameter to the Slice expression of the filter, and then pass value to the parameter by calling SetParamValue(…) in the LoadData action of the filter.
  • New Eaze function – EVAL(“expression”)
    • The new EVAL function evaluates a string expression and returns the result of the evaluated expression. This feature is useful for configuring Worksheets, Reports or Settings with dynamically evaluated formulas.
  • Autofill-dragging and copy/paste in spreadsheet drop down columns now updates the secondary column accordingly

Where can I get it?

Internal users can get it from <fileserver>\Installs\D-Software\Profitbase\Profitbase InVision\2.0\Beta3

External users can request a copy (or demo) by contacting Profitbase.

Upgrading from Beta 1 or Beta 2

If you’re upgrading from Beta 1 or Beta 2, you need to run the following SQL update script against the InVision solution database.

ALTER TABLE [dbo].[pbSimSolutionContentList] DROP CONSTRAINT FK_C2020_ContentType_pbSimSolutionContentList_pbNameDefinitions
ALTER TABLE [dbo].[pbSimSolutionContentList] DROP CONSTRAINT FK_C2030_pbSimSolutionContentList_pbNameDefinitions
ALTER TABLE [dbo].[pbSimSolutionContentList] ADD ObjectDefinition nvarchar(max) null
ALTER TABLE [dbo].[pbSimSolutionContentList] DROP COLUMN DateFrom
ALTER TABLE [dbo].[pbSimSolutionContentList] DROP COLUMN DateTo
ALTER TABLE [dbo].[pbSimSolutionContentList] DROP COLUMN TimeResolution

Upgrading from InVision 1.0 to 2.0 Beta 3

If you’re upgrading from 1.0 to 2.0 Beta 3, you need to run the entire upgrade script.

CREATE TABLE [dbo].[pbStyleBundle](
	[ID] [nvarchar](50) NOT NULL,
	[Name] [nvarchar](50) NULL,
	[AppTheme] [nvarchar](max) NULL,
	[LastChanged] [datetime] NULL,
	[LastChangedBy] [nvarchar](50) NULL,
 CONSTRAINT [PK_pbStyleBundle] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

CREATE TABLE [dbo].[pbStyleSheet](
	[ID] [nvarchar](50) NOT NULL,
	[BundleID] [nvarchar](50) NULL,
	[Name] [nvarchar](50) NULL,
	[Definition] [nvarchar](max) NULL,
 CONSTRAINT [PK_pbStyleSheet] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

ALTER TABLE [dbo].[pbStyleSheet]  WITH CHECK ADD  CONSTRAINT [FK_pbStyleSheet_pbStyleBundle] FOREIGN KEY([BundleID])
REFERENCES [dbo].[pbStyleBundle] ([ID])
GO

ALTER TABLE [dbo].[pbStyleSheet] CHECK CONSTRAINT [FK_pbStyleSheet_pbStyleBundle]
GO

ALTER TABLE [dbo].[pbSimSolutionContentMap]
ADD [Definition] nvarchar(max)

ALTER TABLE [dbo].[pbSimSolutionContentMapItem]
ADD [Definition] nvarchar(max)

ALTER TABLE [dbo].[pbSimSolutionContentList] DROP CONSTRAINT FK_C2020_ContentType_pbSimSolutionContentList_pbNameDefinitions
ALTER TABLE [dbo].[pbSimSolutionContentList] DROP CONSTRAINT FK_C2030_pbSimSolutionContentList_pbNameDefinitions
ALTER TABLE [dbo].[pbSimSolutionContentList] ADD ObjectDefinition nvarchar(max) null
ALTER TABLE [dbo].[pbSimSolutionContentList] DROP COLUMN DateFrom
ALTER TABLE [dbo].[pbSimSolutionContentList] DROP COLUMN DateTo
ALTER TABLE [dbo].[pbSimSolutionContentList] DROP COLUMN TimeResolution

Additional resources

  • A preview of the technical documentation can be found here.
  • Read about additional 2.0 features added in Beta 2 and Beta 1.

What’s next

In addition to fixing any remaining issues, we’ll primarily focus on upgrading the Loan Portfolio Manager to run on the 2.0 platform in order to ship a new and improved version as quickly as possible. The Loan Portfolio Manager is an ideal first product to ship on the 2.0 platform, because it’s an isolated business module with a very short deployment time.

– The InVision Team