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 monthly-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.