BI Server SQL Language

The BI Server supports a subset of SQL for running queries against Data Models. Queries can be provided as part of a point name or used in a Data View (please see the BI Server Data View SQL). In the next sections we will detail the different SQL keywords that the BI Server’s query engine supports, and how they may differ from standard SQL.

• Introduction to BI Server SQL
• Using the SELECT Keyword
• Using Window Functions
• Using Ranking Functions
• Using Analytic Functions
• Using the FROM Keyword
• Using the JOIN Keyword
• Using the GROUP BY Keyword
• Using the WHERE and HAVING Keywords
• Using the ORDER BY, OFFSET and FETCH Keywords
• Using Aggregate Functions
• Using the UNION, COLLATE and CASE Keywords
• Using Hierachical Columns
• Using the PIVOT Keyword
• Using Scalar, Arithmetic and BIT Manipulation Functions
• Using Conversion Functions
• Using Date and Time Functions
• Using Quality Functions
• Using String Functions
• Using TimeSpan Functions
• Using Type Checking Functions