Collapse All Expand All

To use the SQL Server Analysis Services (SSAS) engine, you must enable the engine and have an instance of SQL Server Analysis Services (SSAS) installed on the target computer. You cannot use SQL Server versions earlier than SQL Server 2008 R2, and depending on the SSAS features you want to use, later versions of SQL Server might require that cumulative updates (CUs) or service packs (SPs) be installed.

If you install SSAS after you complete Setup, you can enable the SSAS engine on the PredixionAdmin intranet portal. Similarly, if you chose not to enable the SSAS engine during setup, you can enable it on PredixionAdmin. For more information see, Managing Server Configurations.

The target computer must also meet the overall requirements for Predixion Insight™ 4.0. For more information, see Requirements.

During setup, you can choose a default or custom installation.

Default Installation

When you choose the default installation you will have at least one analytic engine, SSAS or R, installed, enabled and ready to use after you complete Setup without making further setup selection.

Setup looks for SSAS and R on the target computer. If an instance of SSAS is found, the SSAS engine is enabled. If R is installed and it is R 3.01 or later, R is enabled; otherwise, the latest version of R is installed. SSAS is never installed for you.

Custom Installation

When you choose the custom installation, you can set the following options for SSAS and the SSAS engine:

• The SSAS engine is enabled by default. If you disable it, you can enable it on the PredixionAdmin intranet portal after you complete Setup, For more information see, Managing Server Configurations.
  If the SSAS engine is enabled, but SSAS is not installed on the target computer, the SSAS verification check fails. You must disable the SSAS engine or install SSAS to complete the installation of Predixion Insight.
  The SSAS engine is installed regardless of SSAS being installed on the target computer, but you cannot use it until you install SSAS.
• Choose the default SSAS instance or specify a named instance.

You can test the connection to the SSAS instance during Setup.

SQL Server Versions and Editions to Use with the SSAS Engine

The supported SQL Server versions and editions to use with the SSAS engine:

• SQL Server 2008 R2 Data Center Edition, SQL Server 2008 R2 Enterprise Edition, and SQL Server 2008 R2 Developer Edition. SP1must be installed to support the Microsoft clustering algorithms.
• SQL Server 2012 Enterprise Edition, SQL Server 2012 Business Intelligence Edition, or SQL Server 2012 Developer Edition. CU4 or later or SP1 with CU2 or later must be installed to support Microsoft association algorithms.SQL Server 2012 Express SP1 is supported. SSAS must be configured for MOLAP.

The following table lists detailed requirements. To learn what SQL Server version is installed on a computer, open SQL Server Management Studio, click Help and then click About.  

Version	Service Packs	Version Number	Limitations
SQL Server 2008	RTM with SP3	10.0.5500.0	None
SQL Server 2008 R2	RTM	10.50.1600.1	Clustering methods fail
SQL Server 2008 R2	RTM with SP1 or later	10.50.2500.0	None
SQL Server 2012	RTM before CU4	11.00.2100.6	Association method fails
SQL Server 2012	RTM with CU4 or later	11.00.2383.0	None
SQL Server 2012	RTM with SP1 before CU2	11.00.3000.0	Association method fails
SQL Server 2012	RTM with SP1 and CU2 or later	11.00.3339.0	None
SQL Server 2014	RTM	12.0.XXXX	None

 

 

---

© 2015 Predixion Software, Inc. All rights reserved.
2/26/2015

[email protected]