{"id":20171,"date":"2016-10-03T14:00:20","date_gmt":"2016-10-03T06:00:20","guid":{"rendered":"http:\/\/localhost\/help\/?page_id=20171"},"modified":"2024-02-26T08:58:35","modified_gmt":"2024-02-26T00:58:35","slug":"server-release-4-4-4","status":"publish","type":"page","link":"https:\/\/oihelp.corporate.ifs.com\/help\/p2-server\/server-releases\/server-release-4-4-4\/","title":{"rendered":"Server Release 4.4.4"},"content":{"rendered":"\n

\"P2_RGB<\/p>\n

P2 Server 4.4 is the engine that powers data retrieval<\/strong> from a variety of disparate sources, with built-in relationship models<\/strong> based on a Data Dictionary. P2 Server is how you get your data, transform it into more useful data, and then serve it up to other applications such as P2 Explorer or P2 Sentinel, for further analysis.<\/p>\n

Release 4.4.4 adds significant improvements to the Calculation Editor in P2 Server Management, and\u00a0support for OLEDB and SQL Server 2014.<\/p>\n

\u00a0<\/p>\n

OLEDB Support for Relational Adaptor<\/h2>\n

P2 Server is no longer limited to ODBC support for the Relational Adaptor. With this release, P2 Server now also provides OLEDB support. This provides more flexibility in the types of database driver providers that P2 Server can connect to; as long as a database driver provider supports OLEDB, P2 Server can connect to it.<\/p>\n

Read more: Configuring a Datasource Using the Relational Adaptor<\/a><\/p>\n

 <\/p>\n

Calculation Editor Enhancements<\/h2>\n

P2 Server\u2019s Calculation Editor has been upgraded to help you build expressions with the new Component Selector, and to validate these expressions as you build them. The editor now also contains a Details\/Errors tabbed panel, for showing the selected component details\/validation errors.<\/p>\n

\"calceditor-rn\"<\/a><\/p>\n

Read more: Calculations<\/a><\/p>\n

 <\/p>\n

Edit Box Enhancements<\/h3>\n

In P2 Server 4.4.4 you are now able to insert selected components from the new Component Selector into the expression you are building in the Edit Box.<\/p>\n

P2 Server works with the editor to validate your calculation expression as you build it. As soon as an error is encountered, the Edit Box is highlighted in red. The error is highlighted within the expression when an error is selected in the Errors tab.<\/p>\n

The expression itself is colour-coded within the editor, making it easier to spot keywords and constants within the expression.<\/p>\n\n\n\n\n
\u00a0\"colour1\"<\/a><\/td>\n\u00a0\"colour2\"<\/a><\/td>\n<\/tr>\n
\n

The editor shows constants<\/strong> <\/span>in green<\/strong><\/span>, and keywords and functions<\/strong><\/span> in purple<\/strong><\/span>.<\/em><\/p>\n<\/td>\n

\n

The edit box borders are highlighted in red<\/strong><\/span> when there is an error<\/strong><\/span>, or the expression is incomplete.<\/em><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

The error is highlighted in the expression, when you click on an error in the Errors tab:<\/p>\n

\"error\"<\/a><\/p>\n

 <\/p>\n

Errors Tab<\/h3>\n

If P2 Server returns a validation error, you can check this in the new Details\/Error tabbed panel situated below the calculation edit box. Click the Errors<\/strong> tab for error details, and then adjust the expression as necessary. (The tab name changes according to the errors: \u201cNo Error\u201d, \u201c1 Error\u201d, \u201c2 errors\u201d and so on.)<\/p>\n

\"errors-tab\"<\/a><\/p>\n

Here the expression has been updated, this time with no errors:<\/p>\n

\"errors-tab2\"<\/a><\/p>\n

 <\/p>\n

Component Selector<\/h3>\n

The Component Selector lists components that can be included in the calculation expressions. These include the following groups:<\/p>\n