Overview
Jet Analytics supports functionality that allows the processing of cubes without the cubes being taken offline. Normally in SQL Server Analysis Services, when a cube is processed and rebuilt, it is taken offline during the duration of the processing and is made unavailable to end-users. There is some functionality in SQL Server Enterprise Edition that allows the cube to not be taken offline, but many users do not own this edition of SQL.
The High Availability Cube Processing feature in the Jet Data Manager allows users to take advantage of this without the requirement of owning SQL Enterprise Edition. In this way, the cubes can be updated throughout the business day - with no impact to end users. During the processing of the cube, the users will still have access to the original version of the cube, which is then replaced with the new version of the cube once processing has been completed.
Enabling High Availability Cube Processing
-
In the Solution Explorer right click on the name of the OLAP database and select Edit SSAS Multidimensional Server
-
Check the box labeled Enable Offline Processing
-
Rename the Database field in the OLAP Server section to represent a temporary OLAP database to be used during processing.
This is *not* the database that will be used by end users. -
Type in the name of the database that will be used by end users in the Front Database Name field in the Offline Processing section.
-
Click OK
-
Right-click the OLAP database and click Deploy and Execute.
-
There will now be two additional steps in the Execute OLAP Server routine that will handle the Offline Cube Processing. These are Initialize Offline Processing and Finalized Processing.
-
Click the Start button to start the processing of the cubes. Users will be able to still access the cubes as the cubes are being processed.
Comments