Creating and Maintaining Models

This section lists the best practices and recommendations for creating and maintaining BI Gateway Models.

Data Sources

Following are the recommendations for Custom Queries:

• In the queries used for time series data, include [RequestedStartTime] and [RequestedEndTime] parameters. For more information, see Configuring an Incremental Update for a Dimension.

• Use Stored Procedures if you want to implement custom/complex logic for Azure SQL Adapters. For more information, see Using Custom Queries to Create Custom Source Data Items.

Dimensions

Following are the recommendations for dimensions:

• Enable incremental update for all the time series data.

• For linked dimensions, configure adequate Dimension Refresh Offset. This ensure that the linked dimensions are refreshed at a faster rate than the dimensions using those references. For more information, see Configuring a Dimension Link.

Measures

Following is the recommendation for measures:

• Enable Context Link for measures to reduce the number of time slices for each refresh. Do the following:

  1. Enable Context Link for non-TDD Dimension. For more information, see Adding a Dimension Link.

  2. Ensure that this non TDD Dimension is linked to a TDD Dimension.

     The non-TDD Dimension and TDD Dimension will be available in the Measure Context.

  3. Enable the context link for the non-TDD Dimension. For more information, see Select a Context Link Dimension.