phpOLAPi is a PHP-client for XMLA webservices. It allows to build and execute MDX queries, transform the results into different structures and even explore database schemas, cubes, measures, dimensions, etc.
This article demonstrates, how to query OLAP cubes in Microsoft SQL Server Analysis Services (SSAS) using an ODBC connection. Although, the code examples are provided in PHP, this method should work with any other programming language. In PHP, the same can be done via the sqlsrv extension. In a nutshell, we are going to tunnel MDX queries through SQL via OPENQUERY() or OPENROWSET() functions.
Guzzle is probably the most popular PHP HTTP Client, but since the latest version introduced native support for the PSR-7 HTTP message interface, there is no more built-in cache. In this tutorial I will demonstrate how to use any caching library supporting the standard PSR-6 cache interface with Guzzle.