Application configurations

Introduction

Each Kepion application includes an Application Settings node in the System module. System admins can use this page to manage settings for the selected application, including application availability, application servers, proactive caching, SQL provider selection, and application category.

This article covers: 

• Navigate to Application Settings 
• Turn an application on or off 
• Go to Modeler or Administrator 
• Configure application servers 
• Group applications by category 
• Configure proactive caching 
• Configure the SQL provider used by SSAS 
• View SQL Server environment details 
• View SSAS environment details
• Resources for further learning

Note: The information presented on the SQL Environment and SSAS Environment tabs comes from the underlying application database. If you wish to update this information, please do so directly in the SQL server database engine or analysis services. 

Tip: Explore other ways system admins can customize and configure their Kepion environment here. 

Navigation

Follow the steps below to go to an Application Settings node. 

1. Go to System.

2. Expand the Applications node and go to your target application. 

You will land on this page: 

Turn an application on or off

Use the Turn On or Turn Off button in the edit bar to control the availability of the selected application.

When an application is turned off, users cannot access it from the Modeler, Administrator, or related apps. When the application is turned on, users with the appropriate permissions can access it again.

The application’s availability is shown in the State field:

• Online — The application is turned on and available for use.
• Offline — The application is turned off and unavailable to users.
• Inaccessible — Kepion cannot access the application, usually because of a connection or configuration issue.

Go to Modeler or Administrator

Use the Switch to Modeler or Switch to Administrator button in the edit bar to quickly navigate to another module for the selected application.

These shortcuts take you directly from the System module to the selected application’s corresponding area:

• Switch to Modeler takes you to the selected application in the Modeler module, where you can configure its dimensions, models, forms, dashboards, and other core application content.
• Switch to Administrator takes you to the selected application in the Administrator module, where you can manage access control and related administrative settings.

Configure application servers

The General tab allows you to view and configure application settings. 

Change database server

Note: You must turn off an application before you can change its database server. 

Enter the new name in the Database Server field to change the SQL server where the application database resides.

Change OLAP server

Enter the new name in the OLAP Server field to change the OLAP server used for the current application's deployment. 

Group applications by category

Use the Category field to organize applications across the Modeler, Administrator, and System modules, as well as in the application list. Enter a category name to group related applications together. Learn more.

Proactive caching

Proactive Caching controls how Kepion refreshes cached data in SSAS when the underlying relational data changes.

Use SSAS Proactive Caching When Available

• This option uses the native SSAS proactive caching feature. Analysis Services monitors data source tables for changes and refreshes ROLAP or HOLAP partition caches in near real time.

• This option is only effective when using SSAS Enterprise or Developer editions.

Use Kepion Proactive Caching

• This option allows Kepion to manage cache invalidation using database triggers and a partition tracker table. When data changes are detected, Kepion clears the affected partition caches before the next query.

• This mode is required for SSAS Standard Edition, where it is enabled automatically. It can also be selected for other editions when greater control over cache refresh behavior is needed.

Note: On SSAS Standard Edition, Kepion proactive caching is always used, regardless of this setting, because native SSAS proactive caching is not available in that edition.

SQL provider for SSAS

SQL Provider for SSAS Database specifies the OLE DB driver that Analysis Services uses to connect to the application's SQL Server database.

Auto-detect (default)

The system detects the best available OLE DB driver installed on the server. It checks for drivers in the following priority order: MSOLEDBSQL (Microsoft OLE DB Driver for SQL Server), SQLNCLI11 (SQL Server Native Client 11), then SQLNCLI10.1. The detected provider is displayed beneath the setting for reference.

MSOLEDBSQL

Forces use of the Microsoft OLE DB Driver for SQL Server. This is the modern, actively maintained driver recommended by Microsoft.

SQLNCLI11

Forces use of SQL Server Native Client 11, a legacy driver suitable for older environments.

Note: In most environments, Auto-detect selects the correct provider. Override this setting only if you need to force a specific driver due to compatibility requirements or if the auto-detected provider is causing connection issues between SSAS and SQL Server.

View SQL environment details

The SQL Environment tab allows you to check essential information about your SQL environment. 

View SSAS environment details

The SSAS Environment tab allows you to check essential information about your SSAS environment. 

Resources

• Categorize Applications
• System Module - Applications
• System Module - System Admins
• System Module - File Storage