Base pactices

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 Configure 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 Use custom queries.

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 Configure 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 Add 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.