PQL & MDX Language Reference

As described in the Query and Calculation overview, Pyramid is able to build and execute queries in both SQL and MDX. Queries for SQL based data sources are first constructed in Pyramid's own query language, PQL, which is logically and syntactically the same as MDX. This means users can build analogous logic between both data source types without having to fully reconstruct the concepts or approach in the vast majority of situations.

The following reference help topics cover each of the functions in both MDX and PQL.