Module Sub Group (SSAS Cube/tabular model)

Module Sub Group content depends on module type:

  • For modules that targets SSAS Multidimensional databases, the module sub group is like the cube and contains sections for Businesn Logic (Calculation Scripts) and Actions 

    Cubes are the final output of the Profitbase SSAS solution. A Cube typically addresses a department or an area of focus (i.e. a Business Domain), such as Finance or Sales.

    The Cubes most important content is measure groups that define their Fact Tables consisting of Measures, Calculated Measures, Dimension IDs and System IDs.

    Dimension IDs provide the link between a Fact Table and Dimension Trees.  Example: a dimension with base dimension ID of ‘AccountID’ will automatically link to ‘AccountID’ column of transaction table. 

    A cube can contain multiple measure groups. You can for example have a Finance and Sales measure group in one cube. This enables features like KPIs than use information from both measure groups. 

  • For Tabular SSAS modules, there are two types:

    • Cube name and Advanced Cube Settings is used for models w/comp.level 1103.
    • Cube name and Perspectives is used for models w/comp.level 1200 and later (MS SQL/SSAS 2016->).
  • For Data Warehouse only, this acts as a folder, and there is no objects created in the data warehouse.

Main section

Name

 This is the name of the Time Dimension. It can be overridden when used in a module. The name can have translations.

Description

 User defined description.

Comments

User defined comment (supports RTF-format). See more here.

Enable

Checkbox to enable/disable this module sub group w/module definitions
 Available from PS6.4 release 7.

Status section

This contains status of last operation. Click here for more details and usage.

For SSAS type modules there are two statuses, one for the data warehouse and one for the target SSAS database. Also, there are a detailed status that needs to be load/refreshed.

Click on [Load detailed SSAS status] to get a detailed status. The table shown tells if each part is processed in the data warehouse and the SSAS database.

SSAS Calculation Script section

The Calculation Script section, allows for changing the order sequence of the cube calculation elements via drag and drop. It also lets the user see the entire Calculation Script by clicking the command.

Cubes do not contain more configuration than this. The main configuration is done in the measure groups.

SSAS Action section

 Actions are predefined definitions stored in the SSAS Cube that sends commands to client application to perform certain operations based on what the user selects in his client.

Click here for more on Actions. 

Advanced SSAS Cube settings section

This section has advanced settings for the SSAS Cube's dimension error handling, processing etc.

Use this with care and read Microsoft's documentation for the Cube.

Note: Do not change Storage Mode or other settings, unless you know what this will result in.

SSAS Tabular Perspectives (from PS6.2)

The Tabular Settings section, gives possibilities to add Perspectives. A perspective is a named collection of columns across tables.

To add a new Perspective, select from the drop down and enter a unique name. Check the columns to include and click Save.