Friday, August 5, 2016

Partition Settings for our SSAS ROLAP cube using EXASOL

Here are the partition settings we used to set up our SSAS Real-time ROLAP cube using EXASOL as the relational database backend.  Read the full report here:  Build an SSAS ROLAP Cube using EXASOL.

1:  Using Standard settings, adjust the slider to Real-time ROLAP.

2: Under Options, on the General tab, we used the default settings, as listed below:

3: Under Options, on the Notification tab, we made the following adjustments:

  • Scheduled polling - select this option
  • Polling interval     - we set this to one (1) minute.
    You are after a balance between real time, and not overloading the database with excessive queries - there is no correct answer. And, this can be changed easily. See below.
  • Polling query - here we simply used a count(*).
    For our example it was:    SELECT COUNT(*) FROM DWTEST.FACTTESTSALES;
    against the fact table on the relational database. Note:  for production, run the polling query against a track data change table - see ROLAP Polling Query - use a change tracking table.

Making Live Changes to our ROLAP Partition

Once in production, you may decided to change the polling interval, or some other adjustment to your ROLAP partition. You can do that within SQL Server Management Studio.  ( make sure you are running the most current version of SSMS, which is a standalone tool - SSMS - Now a stand-alone, separate tool from SQL Server)

To make changes to the partition, follow these steps:

In SQL Server Management Studio
  1. connect to the Analysis Server
  2. locate the target partition
  3. right click - properties
  4. Proactive Caching - select on the left menu bar
  5. Options Button - select
You are ready to make changes to your partition.

 1:  Use SSMS to open the partition properties:

2: Select the Proactive Caching section, to get access to your ROLAP settings.

See our full report on building an SSAS ROLAP cube with EXASOL here:
Build an SSAS ROLAP Cube using EXASOL.

No comments: