Annotations


The Dax Template library uses annotations to identify dependencies for Measure Templates and to mark columns, tables, and measures generated by the library. The predefined classes in Dax Template use annotations with the SQLBI_ prefix. However, the library can be used with different configurations, using other naming conventions for the annotations.

SQLBI Annotations

This section describes the annotations with the SQLBI_ prefix.

SQLBI_Template

Describes the template that generated the column/table/measure.

  • TimeIntelligence: Used by the Time Intelligence measure templates.

SQLBI_TimeIntelligence

Describes the type of time intelligence implemented by the time intelligence template.

  • Standard: Use standard DAX time intelligence functions.
  • Monthly: Use custom DAX code with montly-based calculations, without using the DAX time intelligence functions.
  • Weekly: Use custom DAX code with weekly-based calculations, without using the DAX time intelligence functions.

SQLBI_CalendarType

Type of calendar implemented and supported by the time intelligence template.

  • Calendar: standard Gregorian calendar.
  • Fiscal: custom fiscal calendar based on Gregorian months.
  • Weekly: custom fiscal calendar based on weeks.
Last update: Mar 26, 2024