SIS Semantic Model

This screen enables you to select the actions to be taken by Installation Manager (e.g., install, uninstall) and to specify the machine name and configuration options for the Semantic Model used by Student Analytics.

Important: SSAS must be installed in Tabular Mode. Closed

Tabular Mode

Set Up the SIS Semantic Model

Compatibility Level for Semantic Model Databases

The SQL Server Analysis Server compatibility level for all the semantic model databases in the prior versions of Analytics, 3.2.x and earlier, was 1103 (SQL Server 2012 SP1).

When upgrading earlier versions of Analytics to 3.3 or later, you need to install new semantic model databases.

Or, to upgrade the exiting semantic model databases, first change the compatibility level manually to 1200 (SQL Server 2016 or SQL Server 2017 for Analytics 4.0) using SQL Server Data Tools (SSDT), and then upgrade to Analytics 3.3 or later using Installation Manager.

Before upgrading to Analytics 3.3 or later, please review Database Renaming During Upgrade to Analytics 3.3 and Later.

  1. In the Installation menu, click SIS Semantic Model. The SIS Semantic Model Settings screen is displayed. Closed

    Semantics Model Settings Screen

  2. Click Add to add a line to the Settings screen.

  3. Select an appropriate Action. The following Action values are available:

    • None – Performs no action.

    • Install – Performs a fresh installation or upgrade of a component. You can install or upgrade multiple components at same time.

    • Uninstall – Removes all subcomponents on that machine and uninstalls the component from Programs and Features.

    Optional: Click Select All to set the Action field to Install for all components listed on this screen. Click Unselect All to set the Action field to None.

  4. In the Analysis Server field, enter the SSAS server name. If the database server contains multiple SSAS server instances, specify the instance name, e.g., <server name\instance>.

  5. In the Analysis Database field, enter the name of the database to be created or upgraded in the SQL Server Analysis Service. The Analysis Database name should be different from the name of the database specified for CRM Semantic Model.

  6. Click Delete icon to delete a selected line.

  7. Click Options (ellipsis) icon to view and edit the Options form. The SIS Semantic Model Options form is displayed. Closed

    SIS Semantic Model Options

    Specify the names of the analysis databases for the following CampusNexus Student modules:

    • Academics and Admissions
    • Financial Aid
    • Student Accounts
    • Career Services

  8. Click OK to save changes on the Options form. The form is closed.

  9. Click Test to ensure the setup for the corresponding line is correct. If a test on a particular line fails, check all associated fields and click Test again.

  10. If all tests pass, click right arrows.