Conceptual Schema Definition Language (CSDLBI) Reference (Archived)

Applies to: SQL Server Analysis Services Azure Analysis Services Fabric/Power BI Premium

Important: This document is archived. For the latest information, refer to Open Specification [MS-CSDLBI]: Conceptual Schema Definition File Format with Business Intelligence Annotations.

CSDLBI 1.0

The initial set of additions to the CSDL schema to support tabular models contained annotations in support of data modeling, custom calculations, and enhanced presentation:

  • New elements and properties to support tabular models at the 1100 and 1103 compatibility levels. For example, a property was added to specify the type of database query used to populate the model.

  • New properties and extensions to existing entities. For example, the Association element was extended to support relationships.

  • Visualization and navigation properties. For example, properties were added to support custom sorting fields, default images, and

CSDLBI 1.1

This version of the CSDLBI schema includes additions in support of multidimensional databases (such as OLAP cubes). The new elements and properties are as follows:

  • Support for dimensions as entities.

  • Support for hierarchies.

  • Exposes ROLAP partitions.

  • Support for translations.

  • Support for perspectives.

See also

CSDLBI Concepts
Technical Reference for BI Annotations to CSDL