Download the PHP package instaclick/phpolap without Composer
On this page you can find all versions of the php package instaclick/phpolap. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Table of contents
Download instaclick/phpolap
More information about instaclick/phpolap
Files in instaclick/phpolap
Download instaclick/phpolap
More information about instaclick/phpolap
Files in instaclick/phpolap
Vendor instaclick
Package phpolap
Short Description phpOlap is a php API for OLAP (XMLA)
License MIT
Package phpolap
Short Description phpOlap is a php API for OLAP (XMLA)
License MIT
Please rate this library. Is it a good library?
Informations about the package phpolap
README
phpOlap is a php API for OLAP (XMLA)
phpOlap can be used to explore schema (cubes, dimensions, hierarchies, levels, ...) and execute MDX Query, generate layout, ...
phpOlap is only supported on PHP 5.3.2 and up.
API : http://phpolap.org/
Database exploration
Query
Layout
<?php
require_once '../autoload.php';
use phpOlap\Xmla\Connection\Connection;
use phpOlap\Xmla\Connection\Adaptator\SoapAdaptator;
use phpOlap\Layout\Table\HtmlTableLayout;
use phpOlap\Layout\Table\CsvTableLayout;
$connection = ...
$resultSet = $connection->statement("
select Hierarchize(Union(Union({([Measures].[Unit Sales], [Gender].[All Gender], [Marital Status].[All Marital Status])}, Union(Union(Crossjoin({[Measures].[Store Cost]}, {([Gender].[All Gender], [Marital Status].[All Marital Status])}), Crossjoin({[Measures].[Store Cost]}, Crossjoin([Gender].[All Gender].Children, {[Marital Status].[All Marital Status]}))), Crossjoin({[Measures].[Store Cost]}, Crossjoin({[Gender].[F]}, [Marital Status].[All Marital Status].Children)))), Crossjoin({[Measures].[Store Sales]}, Union(Crossjoin({[Gender].[All Gender]}, {[Marital Status].[All Marital Status]}), Crossjoin({[Gender].[All Gender]}, [Marital Status].[All Marital Status].Children))))) ON COLUMNS,
Crossjoin(Hierarchize(Crossjoin(Union({[Promotion Media].[All Media]}, [Promotion Media].[All Media].Children), Union(Union({[Product].[All Products]}, [Product].[All Products].Children), [Product].[Food].Children))), {[Store].[All Stores]}) ON ROWS
from [Sales]
where {[Time].[1997]}
");
// html table
$table = new HtmlTableLayout($resultSet);
echo $table->generate();
// csv
header("Content-type: application/vnd.ms-excel");
header("Content-disposition: attachment; filename=\"export.csv\"");
$csv = new CsvTableLayout($resultSet);
print($csv->generate());
exit;
All versions of phpolap with dependencies
PHP Build Version
Package Version
Requires
symfony/class-loader Version
~2.2
The package instaclick/phpolap contains the following files
Loading the files please wait ....